两台MySQL服务器，版本Percona 5.5.35，配置双主，装在Centos 6.4下
Master1 db1,172.21.120.160(真实IP),172.21.120.173(Writer),172.21.120.174(read)
Master2 db1,172.21.120.170(真实IP),172.21.120.175(read)
遇到一个奇怪的问题，db1 failover 到db2失败，表现为mmm_control无反应，
monitor日志显示
FATAL Admin moved role 'writer' from 'db1' to 'db2'
db1日志显示
2014/06/04 16:19:21 DEBUG Executing /usr/lib/mysql-mmm//agent/configure_ip eth0 172.21.120.175
2014/06/04 16:19:21 DEBUG Listener: Waiting for connection...
2014/06/04 16:19:24 DEBUG Listener: Waiting for connection...
2014/06/04 16:19:27 DEBUG Listener: Waiting for connection...
2014/06/04 16:19:30 DEBUG Listener: Waiting for connection...
2014/06/04 16:19:33 DEBUG Listener: Waiting for connection...
db2日志显示
2014/06/04 16:19:23 DEBUG Executing /usr/lib/mysql-mmm//agent/sync_with_master
问题就处在db2执行sync_with_master操作挂起
手动kill掉进程后Monitor端显示
OK: Role 'writer' has been moved from 'db1' to 'db2'. Now you can wait some time and check new roles info!
mmm_control和db1,db2日志正常，writer IP移到db2
测试从db2 move writer role到db1正常
[root@OL11r2 ~]# mmm_control move_role writer db1
OK: Role 'writer' has been moved from 'db2' to 'db1'. Now you can wait some time and check new roles info!
[root@OL11r2 ~]#
db1 move writer role到db2又挂起
kill 掉进程正常
有谁遇到过吗？
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。