场景二,Slave切换
在slave上,只要同步挂掉,
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
有一个线程不为YES,就会切换到另两台主机上。
在slave1上,执行stop slave,
[root@M1 MySQL-mmm]# mmm_control show
M1(192.168.8.25) master/ONLINE. Roles: reader(192.168.8.52)
M2(192.168.8.26) master/ONLINE. Roles: writer(192.168.8.51)
slave1(192.168.8.27) slave/REPLICATION_FAIL. Roles:
结果SLAVE VIP漂移到M1上。
======================================================
在M1上,再执行stop slave
[root@M1 mysql-mmm]# mmm_control show
M1(192.168.8.25) master/REPLICATION_FAIL. Roles:
M2(192.168.8.26) master/ONLINE. Roles: reader(192.168.8.52), writer(192.168.8.51)
slave1(192.168.8.27) slave/REPLICATION_FAIL. Roles:
结果SLAVE VIP漂移到M2上。
=========================================================
在slave1上,执行strat slave
[root@M1 mysql-mmm]# mmm_control show
M1(192.168.8.25) master/REPLICATION_FAIL. Roles:
M2(192.168.8.26) master/ONLINE. Roles: writer(192.168.8.51)
slave1(192.168.8.27) slave/ONLINE. Roles: reader(192.168.8.52)
VIP又漂移到了slave1上