Are there any tips to keeping a MySQL database intact after a power loss, other than the obvious (a big UPS)?
I’ve had two separate events where the server PC lost power, and Travis helped me get MySQL database tables going again the first time. Travis helped me convert the database tables to MyISAM (more resilient) as part of this repair.
The second time I had to “repair” the MySQL program installation and make a new connection to get going again. Luckily, the data tables appeared to be unharmed the second time, apparently because of the MyISAM conversion. Thanks Travis!
There appears to be two separate but related power fail issues: Database integrity, and Database program integrity.
Back in the days of OS/2, (I’m showing my maturity here), I used IBM DB/2 and weathered many power failures without incident.
Is Postgres or other free databases more resilient at handling power failures? Do you have to use “heavy iron” databases to get some power fail protection?
Your experiences and ideas would be greatly appreciated!