One Master, Two Slaves – Daisy Chaining MySQL
Sunday, October 6th, 2013The crucial detail is log_slave_updates = 1 on the first slave to be able to pass on the replication updates to the next machine in the chain.... Read More
The crucial detail is log_slave_updates = 1 on the first slave to be able to pass on the replication updates to the next machine in the chain.... Read More
Update: Apparently the master connection info gets cached in /var/lib/mysql/master.info so whenever you change the settings in my.cnf you need to remove it before you restart mysql.... Read More
I just realized I needed to replicate some data from one database to another, but only certain tables.... Read More