leyton.org

So there I am, with a mysql replication setup, with one box getting ready to take over from another as the live database server. Beforehand though we wanted to get it running replication, staying in sync, and also replicating to the new backup database server. So I needed a slave to replicate on, as a master, to the other box, ie.

Master -> Slave/Master -> Slave

But nothing from the original master was replicating down to the final slave. Things run on the middle box replicated down, but not stuff from the top of the tree. Search as I might, nothing jumped out at me, despite having various books spread about me, and google weeping out of frustration…

There must be a configuration option to pass on updates to slaves, I thought, but what? Eventually, after an hour or two of searching, I finally found it: log-slave-updates in my.cnf ensures that a slave writes updates to the binary log, and replicates it down to slaves that are treating it as a master. Switch that option on, and there’s an almost audible - and wonderfully healthy - noise from the computer as the replicated operations pass through the setup, to my new slaves.

Shame the mysql online references aren’t quite as useful, or keyword ridden, as I hope this page proves!

This entry was posted on Monday, December 12th, 2005 at 6:39 pm and is filed under Databases, Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.