Can someone guide me to some articles/plans related to MySQL disaster and recovery? In this moment I run a master/slave configuration (NDB is not acceptable because is not ACID compliant).

  • It's really not clear to me what your question is. At first I thought you wanted to earn about disaster recovery but then in your comment to Brent's answer you tell us you already know how to backup and restore. Perhaps you can clarify just what you're after. – John Gardeniers Mar 15 '11 at 10:47
  • I'm interested in plans of the disaster recovery. In other words, what can happen and how we can prevent. – Sacx Mar 16 '11 at 7:10

Your question seems to be really general, so I'll give an answer to match.

Read these two books, they'll cover pretty much everything!


For backups / recovery, look at using mylvmbackup.

For HA / disaster, look at using MySQL's Master/Master replication, with heartbeart.

  • I'm most interested in the plans of doing that. I know how to take the backups and how to restore everything. – Sacx Mar 15 '11 at 8:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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