up vote 0 down vote favorite
share [g+] share [fb]

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

link|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
feedback

2 Answers

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!

link|improve this answer
feedback
up vote 1 down vote

For backups / recovery, look at using mylvmbackup.

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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