MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: Dual Master Replication - Backup and Binary Log Purge Strategies
Posted by: Rick James
Date: July 13, 2013 09:49AM

* Don't write to both of Master-Master. Send writes and 'critical reads' to the writable master; reads to the other.

* Simply use expire_logs_days -- but monitor. If one machine is down longer than expire_logs_days, the recovery is a lot more work.

* Backup: Stop the readonly master and dump the disk. Switch Reads to the writable master while it is down. Alternatively, use XtraBackup on the readonly master, but leave it alive.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Dual Master Replication - Backup and Binary Log Purge Strategies
1864
Rob Dunkley
July 11, 2013 03:23AM
Re: Dual Master Replication - Backup and Binary Log Purge Strategies
1048
Rob Dunkley
July 12, 2013 03:44AM
Re: Dual Master Replication - Backup and Binary Log Purge Strategies
1316
Rick James
July 13, 2013 09:49AM


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.