Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

http://www.codership.com/ http://mysql-mmm.org/ http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-switch.html

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

Thanks

share|improve this question
add comment

1 Answer

How about incremental backups of your raw datafiles ?

share|improve this answer
add comment

Your Answer

 
discard

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.