MySQL Forums
Forum List  »  Replication

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.

Options: ReplyQuote

Written By
Re: add slave to existing master-master replication
March 29, 2012 09:35PM

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.