mysql+proxy+mmm-milan22
$cd /usr/local/mmm/etc $cp examples/mmm_agent.conf.examples ../mmm_agent.conf $cp examples/mmm_comment.conf.example ../mmm_common.con （1） mmm_agent.conf主要内容 bind_port 9989# Define current server> this db1
mode master
peer db2
# Cluster hosts addresses and access params
host db1
ip 192.168.50.216
port 3306
user rep_agent
password repagent
host db2 ip 192.168.50.217
port 3306
user rep_agent
password repagent
（2）mmm_common.conf主要内容 agent_port 9989 monitor_ip 127.0.0.1
# Cluster hosts addresses and access params host db1
ip 192.168.50.216
port 3306
user rep_agent
password repagent
mode master
peer db2
host db2 ip 192.168.50.217
port 3306
user rep_agent
password repagent
mode master
peer db1
# Define roles that are assigned to the above hosts # Mysql Reader role
role reader //设置读规则
mode balanced //模式为均摊
servers db1, db2 //规则覆盖db1 db2
ip 192.168.50.243,192.168.50.244//对应ip 虚拟的IP
# Mysql Writer role role writer //写规则
mode exclusive //模式为独占
servers db1,db2 //规则负载db1 db2
ip 192.168.50.245 //两台数据库公用一个ip为写，采用HA模式，默认db1使用，db1下线db2接管此ip
（3）设置权限（MMM客户端） GRANT ALL PRIVILEGES on *.* to 'rep_agent'@'%'> 4.配置MMM服务端 $cd /usr/local/mmm/etc $cp examples/mmm_mon.conf.examples ../mmm_mon.conf $cp examples/mmm_comment.conf.example ../mmm_common.conf （1）mmm_mom.conf保持不变 mmm_common.conf主要内容 cluster_interface eth0 # Cluster hosts addresses and access params host db1
ip 192.168.50.216
port 3306
user rep_agent
password repagent
mode master
peer db2
host db2 ip 192.168.50.217
port 3306
user rep_agent
password repagent
mode master
peer db1
# Define roles that are assigned to the above hosts
# Mysql Reader role
role reader
mode balanced
servers db1, db2
ip 192.168.50.243, 192.168.50.244
# Mysql Writer role role writer
mode exclusive
servers db1,db2
ip 192.168.50.245
5.MMM测试 （1）启动MMM客户端 /usr/local/mmm/scripts/init.d/mmm_agent start Starting MMM Agent daemon: MySQL Multi-Master Replication Manager Version: 1.2.6
Ok
以上信息说明客户端启动正常 （2）启动MMM服务端 /usr/local/mmm/scripts/init.d/mmm_mon start # mmm_control set_online db1 # mmm_control set_online db2 # mmm_control show查看分配情况 正常情况下: # mmm_control show
Servers status:
db1(192.168.50.216):master/ONLINE.Roles:reader(192.168.50.243;), writer(192.168.50.244;)
db2(192.168.50.217):master/ONLINE.Roles:reader(192.168.50.245;)
停止 192.168.50.217 mysql服务
# mmm_control show
Servers status: db1(192.168.50.216): master/ONLINE. Roles: reader(192.168.50.243;), reader(192.168.50.244;), writer(192.168.50.245;)
db2(192.168.50.217): master/AWAITING_RECOVERY. Roles: None
Telnet 任何一个虚拟IP 3306都是通的
页:
[1]