I am in the process of migrating 2 DB servers (Master & Slave) to two new DB Servers (Master and Slave)
DB1 – Master (production)
DB2 – Slave (production)
DB3 – New Master
DB4 – New Slave
Currently I have the replication set up as:
DB1 -> DB2
DB3 -> DB4
To get the production data replicated to the new servers, I'd like to get it "daisy chained" so that it looks like this:
DB1 -> DB2 -> DB3 -> DB4
Is this possible? When I run show master status;
on DB2 (the production slave) the binlog possition never seems to change:
+------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000020 | 98 | | | +------------------+----------+--------------+------------------+
I'm a bit confused as to why the binlog position is not changing on DB2, Ideally it will be the master to DB3.
Best Answer
The binlog on
DB2
wasn't updating the slave updates. To daisy chain the replication, one must setlog-slave-updates
in my.conf.http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates