MySQL Forums
Forum List  »  Replication

Re: Need to have binlog activate on slave?
Posted by: Rick James
Date: August 16, 2014 06:20PM

No.

For purely Master-Slave(s), the Slave(s) do not need their binlog turned on.

For Master-Master, each is both a Master (with binlog turned on) and a Slave.

For having a tree of Master -> Relay(s) -> Slave(s), then the "Relays" act as Slave to the Master and act as Master to the Slaves. Hence the Relays need to have their binlogs turned on.

A Master writes to its "binlog". That data is transferred to each of its Slave's "relay-log" for replay.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need to have binlog activate on slave?
843
August 16, 2014 06:20PM


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.