MySQL Master->Slave/Master->Slave configuration

10Feb09

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.

Advertisements


No Responses Yet to “MySQL Master->Slave/Master->Slave configuration”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: