Can a MySQL slave be a master at the same time?
Posted
by mmattax
on Server Fault
See other posts from Server Fault
or by mmattax
Published on 2010-05-25T17:32:44Z
Indexed on
2010/05/25
17:41 UTC
Read the original article
Hit count: 288
mysql
|mysql-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.
© Server Fault or respective owner