mha检测复制链路报错
来源:5-13 MMM架构实例演示(下)

fww16
2019-06-11
masterha_check_repl --conf=/etc/mha/mysql_mha.cnf
Tue Jun 11 18:29:02 2019 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Tue Jun 11 18:29:02 2019 - [info] Reading application default configuration from /etc/mha/mysql_mha.cnf…
Tue Jun 11 18:29:02 2019 - [info] Reading server configuration from /etc/mha/mysql_mha.cnf…
Tue Jun 11 18:29:02 2019 - [info] MHA::MasterMonitor version 0.57.
Tue Jun 11 18:29:03 2019 - [info] GTID failover mode = 1
Tue Jun 11 18:29:03 2019 - [info] Dead Servers:
Tue Jun 11 18:29:03 2019 - [info] Alive Servers:
Tue Jun 11 18:29:03 2019 - [info] 10.45.81.227(10.45.81.227:3306)
Tue Jun 11 18:29:03 2019 - [info] 10.45.81.244(10.45.81.244:3306)
Tue Jun 11 18:29:03 2019 - [info] 10.45.81.246(10.45.81.246:3306)
Tue Jun 11 18:29:03 2019 - [info] Alive Slaves:
Tue Jun 11 18:29:03 2019 - [info] 10.45.81.244(10.45.81.244:3306) Version=5.7.21-log (oldest major version between slaves) log-bin:enabled
Tue Jun 11 18:29:03 2019 - [info] GTID ON
Tue Jun 11 18:29:03 2019 - [info] Replicating from 10.45.81.227(10.45.81.227:3306)
Tue Jun 11 18:29:03 2019 - [info] Primary candidate for the new Master (candidate_master is set)
Tue Jun 11 18:29:03 2019 - [info] 10.45.81.246(10.45.81.246:3306) Version=5.7.21-log (oldest major version between slaves) log-bin:enabled
Tue Jun 11 18:29:03 2019 - [info] GTID ON
Tue Jun 11 18:29:03 2019 - [info] Replicating from 10.45.81.227(10.45.81.227:3306)
Tue Jun 11 18:29:03 2019 - [info] Not candidate for the new Master (no_master is set)
Tue Jun 11 18:29:03 2019 - [info] Current Alive Master: 10.45.81.227(10.45.81.227:3306)
Tue Jun 11 18:29:03 2019 - [info] Checking slave configurations…
Tue Jun 11 18:29:03 2019 - [info] read_only=1 is not set on slave 10.45.81.244(10.45.81.244:3306).
Tue Jun 11 18:29:03 2019 - [info] Checking replication filtering settings…
Tue Jun 11 18:29:03 2019 - [info] binlog_do_db= , binlog_ignore_db=
Tue Jun 11 18:29:03 2019 - [info] Replication filtering check ok.
Tue Jun 11 18:29:03 2019 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. Argument “1~” isn’t numeric in numeric ge (>=) at /usr/share/perl5/vendor_perl/MHA/ServerManager.pm line 1157.
Tue Jun 11 18:29:03 2019 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Tue Jun 11 18:29:03 2019 - [info] Got exit code 1 (Not master dead).
配置文件是按照老师课上讲的配置的
1回答
-
sqlercn
2019-06-12
MHA首先要把主从复制配置好,所以先检查一下你三台MySQL的主从复制是否正常,另外发一下你的配置文件看一下。
00
相似问题