请稍等 ...
×

采纳答案成功!

向帮助你的同学说点啥吧!感谢那些助人为乐的人

gtid集群搭建好后,检测通过不了,哪位大师帮我分析一下原因

[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 202
0 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

正在回答 回答被采纳积分+3

1回答

sqlercn 2020-01-28 17:33:08

你的Slave节点开启了binlog吗?

0 回复 有任何疑惑可以回复我~
问题已解决,确定采纳
还有疑问,暂不采纳
微信客服

购课补贴
联系客服咨询优惠详情

帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

公众号

扫描二维码
关注慕课网微信公众号