MySQL中mmm实现高可用群集
# yum -y install mysql-mmm* 安装结束后，对mmm进行配置# cd /etc/mysql-mmm/
#vim mmm_common.conf //所有主机上都要配置,直接复制多份
cluster_interface ens33
……
replication_user replication
replication_password 123456
agent_user mmm_agent
agent_password 123456
ip 192.168.177.128
mode master
peer db2
ip 192.168.177.135
mode master
peer db1
ip 192.168.177.132
mode slave
ip 192.168.177.133
mode slave
hosts db1, db2
ips 192.168.177.200 #主服务器虚拟IP
mode exclusive
hosts db3, db4
ips 192.168.177.20,192.168.177.30 #从服务器虚拟IP
mode balanced
在主1上面复制：
# scp mmm_common.conf root@192.168.177.135:/etc/mysql-mmm/
# scp mmm_common.conf root@192.168.177.133:/etc/mysql-mmm/
# scp mmm_common.conf root@192.168.177.132:/etc/mysql-mmm/
页:
[1]