MySQL Forums
Forum List  »  Replication

Re: add slave to existing master-master replication
Posted by: Teri LeBlanc
Date: April 09, 2012 07:58AM


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

Options: ReplyQuote

Written By
Re: add slave to existing master-master replication
April 09, 2012 07:58AM

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.