MySQL Forums
Forum List  »  Replication

Re: howto add a slave in a master-mater replication
Posted by: Rick James
Date: April 08, 2014 11:28AM

> Because the master do not relay the binlogs he receives from the other master, I thought it should miss half of the workload.

False. In Master-Master, both machines need to be both Master and Slave. Both have binlogs _and_ relay logs.

A Slave with nothing downstream necessarily has a "relay log" for receiving the machine it is replicating from, but does not have to have a binlog, since there is nothing downtream from it.

M <-> M Master-Master
M -> S Master-Slave
M <-> M -> S -- I think this is what you are striving for.

A "Relay" is a Slave with Slave(s) hanging off it
M -> R -> S
It needs both binlog and relay log. (It is not something you mentioned.)

> So, it is the same way as to create a slave with one master ?

There is only(?) one difference between
* Creating the first Slave in M -> S, and
* Creating the second Master in M <-> M
For MM, first you do MS, then you do CHANGE MASTER (on the Slave) to turn it into a Master, too.

(Creating subsequent Slaves off the _same_ Master are usually done by cloning an existing Slave.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: howto add a slave in a master-mater replication
1067
April 08, 2014 11:28AM


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.