mha切换后检查主从复制出现:
[root@devops-mha-150 logs]# masterha_check_repl -conf=/etc/mha/10.66.150.117.cnf
tue mar 14 12:27:23 2017 - [info] reading default configuratoins from /etc/masterha_default.cnf..
tue mar 14 12:27:23 2017 - [info] reading application default configurations from /etc/mha/10.66.150.117.cnf..
tue mar 14 12:27:23 2017 - [info] reading server configurations from /etc/mha/10.66.150.117.cnf..
tue mar 14 12:27:23 2017 - [info] mha::mastermonitor version 0.56.
tue mar 14 12:27:24 2017 - error getting relay log directory or current relay logfile from repication table failed on devops-mysql-150-116(10.66.150.116:3306)!
tue mar 14 12:27:24 2017 - error error happend on checking configurations. at /usr/loca/share/perl5/mha/servermanager.pm line 269.
tue mar 14 12:27:24 2017 - error error happened on monitoring servers.
tue mar 14 12:27:24 2017 - [info] got exit code 1 (not master dead).
| relay_log_info_repository | table
为table的时候mha检查切换有问题。 这台作为master机器的relay_log_info_repository忘记改为file
改为file就ok了。