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: March 30, 2012 05:35AM

Hi Rick,

Thanks very much for your comments. We hope never to have to promote either slave to master, but in the event of complete failure of datacenter1 it could happen. (there are also failover application servers in datacenter2)

That is why I wonder about the auto_increment_increment & offset.

The original servers were not built with any expansion in mind. I was therefore thinking that if I went with the 3rd topology (i.e. datacenter1 M1---> datacenter2 S1 and datacenter1 M2----> datacenter2 S2) and if I set the slave settings same as the corresponding master, the data written during the "disaster" will at least be consistent with what would have been written on the masters. Then if masters come back and we need to restore the data it will "match" what would have been written to the masters.

Does that make any sense?

Thanks, Teri

Options: ReplyQuote


Subject Views Written By Posted
add slave to existing master-master replication 1308 Teri LeBlanc 03/28/2012 03:33PM
Re: add slave to existing master-master replication 693 Rick James 03/29/2012 09:35PM
Re: add slave to existing master-master replication 565 Teri LeBlanc 03/30/2012 05:35AM
Re: add slave to existing master-master replication 541 Rick James 03/31/2012 10:52AM
Re: add slave to existing master-master replication 729 Teri LeBlanc 04/01/2012 07:38PM
Re: add slave to existing master-master replication 768 Teri LeBlanc 04/09/2012 07:58AM
Re: add slave to existing master-master replication 517 Rick James 04/10/2012 10:30PM
Re: add slave to existing master-master replication 454 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.