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)
本文出自 “贺春旸的技术专栏” 博客，香港服务器，请务必保留此出处
，香港虚拟主机