MHA检查MySQL 主从同步报错
本帖最后由 小小蚯蚓 于 2017-6-23 17:25 编辑我搭建mha，验证mysql主从是否同步，抛出了错误，我的系统的Centos7， mha的版本是：0.52
报错信息如下：
#
# masterha_manager --conf=/etc/mha/mha.conf
Sat Jun 24 01:13:13 2017 - Global configuration file /etc/masterha_default.cnf not found. Skipping.
Sat Jun 24 01:13:13 2017 - Reading application default configurations from /etc/mha/mha.conf..
Sat Jun 24 01:13:13 2017 - Reading server configurations from /etc/mha/mha.conf..
Sat Jun 24 01:13:13 2017 - MHA::MasterMonitor version 0.52.
Sat Jun 24 01:13:14 2017 - Dead Servers:
Sat Jun 24 01:13:14 2017 - Alive Servers:
Sat Jun 24 01:13:14 2017 - 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - 192.168.68.16(192.168.68.16:3306)
Sat Jun 24 01:13:14 2017 - 192.168.68.17(192.168.68.17:3306)
Sat Jun 24 01:13:14 2017 - Alive Slaves:
Sat Jun 24 01:13:14 2017 - 192.168.68.16(192.168.68.16:3306)Version=5.7.12-log (oldest major version between slaves) log-bin:enabled
Sat Jun 24 01:13:14 2017 - Replicating from 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - Primary candidate for the new Master (candidate_master is set)
Sat Jun 24 01:13:14 2017 - 192.168.68.17(192.168.68.17:3306)Version=5.7.12-log (oldest major version between slaves) log-bin:enabled
Sat Jun 24 01:13:14 2017 - Replicating from 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - Not candidate for the new Master (no_master is set)
Sat Jun 24 01:13:14 2017 - Current Alive Master: 192.168.68.15(192.168.68.15:3306)
Sat Jun 24 01:13:14 2017 - Checking slave configurations..
Sat Jun 24 01:13:14 2017 - Checking replication filtering settings..
Sat Jun 24 01:13:14 2017 - binlog_do_db= , binlog_ignore_db=
Sat Jun 24 01:13:14 2017 - Replication filtering check ok.
Sat Jun 24 01:13:14 2017 - Error happend on checking configurations. Argument "1 # M-hM-/M-% MySQL M-fM-0M-8M-hM-?M-^\M-dM-8M-\rM-eM-^A..." isn't numeric in numeric ge (>=) at /usr/lib/perl5/vendor_perl//MHA/ServerManager.pm line 1083.
Sat Jun 24 01:13:14 2017 - Error happened on monitoring servers.
Sat Jun 24 01:13:14 2017 - Got exit code 1 (Not master dead).
如果有知道问题的哥哥姐姐们，希望帮帮我，小女子感激不尽:P:P:P:P:P
首先我有一点不明白。检查mha的主从是否同步是用masterha_manager命令的嘛~
至于MHA的排错，建议先检查一下ssh环境和repl环境是否配置成功，配置文件是否正确
:lol我也是初来乍到，拙建~
页:
[1]