Re: add slave to existing master-master replication
Posted by:
Rick James
Date: March 29, 2012 09:35PM
> I am unclear on how to set auto_increment_increment and auto_increment_offset on the new slaves.
Irrelevant -- Slaves are for reading from, not by writing to. Therefore, there will be not AUTO_INCREMENT values created on the Slaves.
If you need to promote a Slave to be a Master, you have worse problems than auto_inc. Just plan for failing over between the Masters. The Slaves give you a source for the data (without interrupting the surviving Master) for rebuilding the dead Master.
Your first two topologies have a "single point of failure" (S1). Your third one is more robust.
Direct reads to the Slaves; this will offload the Masters.
Subject
Views
Written By
Posted
2718
March 28, 2012 03:33PM
Re: add slave to existing master-master replication
1328
March 29, 2012 09:35PM
1093
March 30, 2012 05:35AM
1018
March 31, 2012 10:52AM
1201
April 01, 2012 07:38PM
1455
April 09, 2012 07:58AM
943
April 10, 2012 10:30PM
884
April 13, 2012 08:06AM
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.