Skip navigation links

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


Advanced Search

add slave to existing master-master replication
Posted by: Teri LeBlanc ()
Date: March 28, 2012 03:33PM

Hello - we have an existing circular replication setup like this:

M1 <---> M2

settings are as follows:

M1:

server-id=1
auto_increment_increment=2
auto_increment_offset=1
log-slave-updates
sync_binlog=1

M2:

server-id=2
auto_increment_increment=2
auto_increment_offset=2
log-slave-updates
sync_binlog=1

We are adding 2 servers in a second datacenter as a DR solution. Not sure yet which config we are going with, but it will be one of these 3:

M1 <---> M2
|
|
V
S1 ----> S2

or

M2 <---> M1
|
|
V
S1 ----> S2

or

M1 <---> M2 ------> S2
|
|
|
V
S1

I am unclear on how to set auto_increment_increment and auto_increment_offset on the new slaves. It doesn't matter while they are slaves, but it could matter if they ever have to get promoted to masters. I am thinking that these values on the slaves should match whatever master they are connected to, so in the event of disaster they kind of "take over" for that master.

I'd appreciate any comments on this

Teri



Edited 2 time(s). Last edit at 03/28/2012 03:38PM by Teri LeBlanc.

Options: ReplyQuote


Subject Views Written By Posted
add slave to existing master-master replication 1282 Teri LeBlanc 03/28/2012 03:33PM
Re: add slave to existing master-master replication 677 Rick James 03/29/2012 09:35PM
Re: add slave to existing master-master replication 552 Teri LeBlanc 03/30/2012 05:35AM
Re: add slave to existing master-master replication 531 Rick James 03/31/2012 10:52AM
Re: add slave to existing master-master replication 717 Teri LeBlanc 04/01/2012 07:38PM
Re: add slave to existing master-master replication 751 Teri LeBlanc 04/09/2012 07:58AM
Re: add slave to existing master-master replication 503 Rick James 04/10/2012 10:30PM
Re: add slave to existing master-master replication 444 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.