Can a MySQL slave be a master at the same time?
- by mmattax
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.