Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

One of my clients servers recently crashed at the planet, we got an automatic email from them that they had to do a hard reboot. Since then mysqld stops running occasionally and then shopping cart stopped letting users add products to their cart. I found it was a corrupted table storing session data. This table has kept crashing every few days and after tech support at the planet looked into the server they upgraded the bios memory and are planning to replace the entire server as there was some hardware issues.

All the crashes seem to have affected the shopping cart mainly the sessions table. What is a simple solution to fail over to another database if a table becomes corrupted? I've searched the site and saw some questions and answers pointing to these three sites

Would replicating help any if a table is corrupted in one database wouldn't copying it just copy the bad table data? So I need some way to monitor the tables and if any become corrupted redirect traffic or take that db offline until its fixed. Any help is appreciated, the simpler the solution the better


share|improve this question

How about incremental backups of your raw datafiles ?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.