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: Teri LeBlanc ()
Date: April 09, 2012 07:58AM

Hello

I am replying to my thread once more since I still don't really know the answer to my original question - for the 2 new slaves to what values do I set auto_increment_increment and auto_increment_offset (knowing that there is a slight chance one of them could temporarily be promoted to master in the event of a datacenter1 disaster). Is it advisable to make each slave have the same value as its corresponding master?

Thanks again
Teri

Options: ReplyQuote


Subject Views Written By Posted
add slave to existing master-master replication 1217 Teri LeBlanc 03/28/2012 03:33PM
Re: add slave to existing master-master replication 620 Rick James 03/29/2012 09:35PM
Re: add slave to existing master-master replication 509 Teri LeBlanc 03/30/2012 05:35AM
Re: add slave to existing master-master replication 494 Rick James 03/31/2012 10:52AM
Re: add slave to existing master-master replication 681 Teri LeBlanc 04/01/2012 07:38PM
Re: add slave to existing master-master replication 696 Teri LeBlanc 04/09/2012 07:58AM
Re: add slave to existing master-master replication 476 Rick James 04/10/2012 10:30PM
Re: add slave to existing master-master replication 413 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.