Best Setup for Slave of Master-Master Replication?

MySQL & MariaDB Other MySQL® Questions
1

I have in production a 2 master (master-master) replication, and a slave of the master. Currently, the slave is master of one server, so it looks like this:

Master1<----->Master2
|
|
|
Slave1

What happens, is if I have to switch to master2 for writes, the slave never receives the updates, so it essentially is “out of sync”. What is the best way to overcome this problem?

Thanks,
Michael

2

You probably forgot to set “log-slave-updates” on Master1, see http://dev.mysql.com/doc/refman/5.0/en/replication-options.h tml

Hope this helps,
Martin

3

Why, I think you’re right! I’ll make sure, and let you know.

Thanks bunches,
Michael