MHA实现MySQL高可用的时候,MHA复制功能检测老是出现各种问题,故总结一下常见报错以及如何解决的
1.某个库 Dead Servers
检测从库状态发现一切正常,那是哪里出问题了呢?
Sun Jul 28 09:27:40 2019 - [info] Dead Servers:
Sun Jul 28 09:27:40 2019 - [info] 172.25.13.13(172.25.13.13:3306)
查看server3(IP地址为172.25.13.13)的防火墙!!!
做测试的时候尽量把防火墙都关掉,防火墙会影响3306端口!!!
2. master_ip_failover_script报错
Sun Jul 28 09:30:48 2019 - [info] Checking replication health on 172.25.13.11..
Sun Jul 28 09:30:48 2019 - [info] ok.
Sun Jul 28 09:30:48 2019 - [info] Checking replication health on 172.25.13.13..
Sun Jul 28 09:30:48 2019 - [info] ok.
Sun Jul 28 09:30:48 2019 - [info] Checking master_ip_failover_script status:
Sun Jul 28 09:30:48 2019 - [info] /usr/local/bin/master_ip_failover --command=status --s