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.
Subject
Views
Written By
Posted
4061
April 22, 2013 03:04AM
1464
April 22, 2013 11:27PM
Re: MySQL Backup Strategy for Master-Master Replication
1538
April 24, 2013 09:52PM
1523
May 07, 2013 05:44AM
1473
May 12, 2013 12:37PM
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.