Results 1 to 4 of 4

Thread: Are "high-end" relational database able to survive a power failure?

  1. #1
    Join Date
    Sep 2021
    Posts
    1

    Are "high-end" relational database able to survive a power failure?

    Our product is running on a Raspbery Pi collecting data from sensors. The sensor data is stored in a relational open source database (hsql db). In case a power failure happens, the hsql database file sometimes get corrupt.

    Does anyone know whether free high-end database (such as postgresql, MySQL) or commercial relational databases such as Oracle, Sybase, MS SQL are able to survive a power failures? From what I know they write a journal with which the last state before the power failure can be restored. That's good. But my question is much simpler: Do these database have a problem that the database files can be corrupt after a power failure or do they always reliable startup again after power failure?

    I'm asking this, because our customer wants our application to survive a power failure and I need to be able to say that if he wants this, this or that high-end database would be required (which probably would consume too much resources on a Pi).

    Thanks for any constructive answers.
    Regards, Oliver

  2. #2
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86

  3. #3
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    79
    AND, in theory, you could test this in your office... Load up your software etc with a backup db and pull the plug on the machine.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Commercial databases typically survive power failure (will lose uncommitted transactions). But it is not a guarantee, disk may still get corrupted if power fails. As suggested earlier UPS can provide protection from such a situation. Next you can think of replicating the data to another server/location.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •