MySQL-MMM切换演示

MMM（Multi-MasterReplicationManagerforMySQL）是基于双Master结构，后面接N台Slave安装很简单，官网提供了很详细的安装文档：http://mysql-mmm.org/mmm2:guide

安装很简单，香港虚拟主机，官网提供了很详细的安装文档：

:guide

3台环境做测试

服务都起来后，状态如下：

[root@M1 mysql-mmm]# mmm_control show

M2(192.168.8.26) master/ONLINE. Roles:

slave1(192.168.8.27) slave/ONLINE. Roles: reader(192.168.8.52)

[root@M1 mysql-mmm]# mmm_control show

M1(192.168.8.25) master/HARD_OFFLINE. 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)

======================================================

[root@M1 mysql-mmm]# mmm_control show

M1(192.168.8.25) master/ONLINE. 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)

======================================================

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

[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:

======================================================

[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:

=========================================================

[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)

本文出自 “贺春旸的技术专栏” 博客，香港服务器，请务必保留此出处