Skip navigation links

MySQL Forums :: Replication :: add slave to existing master-master replication


Advanced Search

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


Subject Views Written By Posted
add slave to existing master-master replication 1327 Teri LeBlanc 03/28/2012 03:33PM
Re: add slave to existing master-master replication 708 Rick James 03/29/2012 09:35PM
Re: add slave to existing master-master replication 579 Teri LeBlanc 03/30/2012 05:35AM
Re: add slave to existing master-master replication 549 Rick James 03/31/2012 10:52AM
Re: add slave to existing master-master replication 733 Teri LeBlanc 04/01/2012 07:38PM
Re: add slave to existing master-master replication 780 Teri LeBlanc 04/09/2012 07:58AM
Re: add slave to existing master-master replication 527 Rick James 04/10/2012 10:30PM
Re: add slave to existing master-master replication 466 Teri LeBlanc 04/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.