Mysql – Can a MySQL slave be a master at the same time

MySQLmysql-replication

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 set log-slave-updates in my.conf.

http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates

Related Topic