Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

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).

share|improve this question
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
up vote 2 down vote accepted

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!

share|improve this answer

For backups / recovery, look at using mylvmbackup.

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

share|improve this answer
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 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.