To support Master -> Slave/Master -> Slave configuration, one needs to add log-slave-updates in my.cnf for the node acting as a slave as well as master for other slaves. If this is not done, no data from the master will get replicated to the final slave and the replication will work only between master and 1st level slave.
The log-slave-updates option enables replication instructions from Master 1 to be written to Master 2’s binary log so that they can then be replicated to the true slaves.
Filed under: MySQL | Leave a Comment
Tags: MySQL replication
Search
-
You are currently browsing the Code Eazy weblog archives.
No Responses Yet to “MySQL Master->Slave/Master->Slave configuration”