MySQL Forums
Forum List  »  Backup

Re: MySQL Backup Strategy for Master-Master Replication
Posted by: Rick James
Date: April 24, 2013 09:52PM

Write to only one Master.

Take the backup on the readonly machine.

Why dump the binlogs?

Point-in-time recovery will apply to whichever machine you are recovering on -- that is whichever binlogs you are using.

If you must roll back to a point-in-time, I think you will need to do so on both machines (perhaps with the same backup and binlog), then reestablish the Master-Master replication. This involves a lot of downtime -- consider having a Slave to assist with such.

Options: ReplyQuote

Written By
Re: MySQL Backup Strategy for Master-Master Replication
April 24, 2013 09:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.