gtid集群搭建好后,检测通过不了,哪位大师帮我分析一下原因
来源:5-16 MHA架构实例演示(1)

宝慕林2132329
2020-01-28
[root@rep3 mha]# masterha_check_repl --conf=/etc/mha/mha_mysql.cnf
Tue Jan 28 07:00:38 2020 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Tue Jan 28 07:00:38 2020 - [info] Reading application default configuration from /etc/mha/mha_mysql.cnf…
Tue Jan 28 07:00:38 2020 - [info] Reading server configuration from /etc/mha/mha_mysql.cnf…
Tue Jan 28 07:00:38 2020 - [info] MHA::MasterMonitor version 0.57.
Tue Jan 28 07:00:39 2020 - [info] GTID failover mode = 1
Tue Jan 28 07:00:39 2020 - [info] Dead Servers:
Tue Jan 28 07:00:39 2020 - [info] 192.168.0.201(192.168.0.201:3306)
Tue Jan 28 07:00:39 2020 - [info] Alive Servers:
Tue Jan 28 07:00:39 2020 - [info] 192.168.0.200(192.168.0.200:3306)
Tue Jan 28 07:00:39 2020 - [info] 192.168.0.202(192.168.0.202:3306)
Tue Jan 28 07:00:39 2020 - [info] Alive Slaves:
Tue Jan 28 07:00:39 2020 - [info] 192.168.0.202(192.168.0.202:3306) Version=5.7.29-log (oldest major version between slaves) log-bin:enabled
Tue Jan 28 07:00:39 2020 - [info] GTID ON
Tue Jan 28 07:00:39 2020 - [info] Replicating from 192.168.0.200(192.168.0.200:3306)
Tue Jan 28 07:00:39 2020 - [info] Not candidate for the new Master (no_master is set)
Tue Jan 28 07:00:39 2020 - [info] Current Alive Master: 192.168.0.200(192.168.0.200:3306)
Tue Jan 28 07:00:39 2020 - [info] Checking slave configurations…
Tue Jan 28 07:00:39 2020 - [info] read_only=1 is not set on slave 192.168.0.202(192.168.0.202:3306).
Tue Jan 28 07:00:39 2020 - [info] Checking replication filtering settings…
Tue Jan 28 07:00:39 2020 - [info] binlog_do_db= , binlog_ignore_db=
Tue Jan 28 07:00:39 2020 - [info] Replication filtering check ok.
Tue Jan 28 07:00:39 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln364] None of slaves can be master. Check failover configuration file or log-bin settings in my.cnf
Tue Jan 28 07:00:39 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/bin/masterha_check_repl line 48.
Tue Jan 28 07:00:39 2020 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Tue Jan 28 07:00:39 2020 - [info] Got exit code 1 (Not master dead).
MySQL Replication Health is NOT OK!
1回答
-
sqlercn
2020-01-28
你的Slave节点开启了binlog吗?
00
相似问题