bluesky 发表于 2017-2-21 19:28:31

MHA的failover时send_report指定的脚本没有执行是什么原因?

各位前辈大能们,小弟有个疑问想请教下, 我在进行MHA的failover测试时发现设置的send_report脚本不执行,只执行了故障切换,但是没有执行send_report中指定的脚本. 切换时的日志如下:
#截取了最后一部分

----- Failover Report -----

mha: MySQL Master failover 192.168.175.121(192.168.175.121:3306) to 192.168.175.122(192.168.175.122:3306) succeeded

Master 192.168.175.121(192.168.175.121:3306) is down!

Check MHA Manager logs at managed1.com:/usr/local/mha/manager.log for details.

Started automated(non-interactive) failover.
Invalidated master IP address on 192.168.175.121(192.168.175.121:3306)
The latest slave 192.168.175.122(192.168.175.122:3306) has all relay logs for recovery.
Selected 192.168.175.122(192.168.175.122:3306) as a new master.
192.168.175.122(192.168.175.122:3306): OK: Applying all logs succeeded.
192.168.175.122(192.168.175.122:3306): OK: Activated master IP address.
192.168.175.123(192.168.175.123:3306): This host has the latest relay log events.
Generating relay diff files from the latest slave succeeded.
192.168.175.123(192.168.175.123:3306): OK: Applying all logs succeeded. Slave started, replicating from 192.168.175.122(192.168.175.122:3306)
192.168.175.122(192.168.175.122:3306): Resetting slave info succeeded.
Master failover to 192.168.175.122(192.168.175.122:3306) completed successfully.#到这里切换就结束了

#切换完成后应该执行send_report才对. 但是没有执行,我看网上正常的切换步骤是:
Master failover to 192.168.2.129(192.168.2.129:3306) completed successfully.
Sun Jan 18 17:52:45 2015 - Sending mail..//我测试时没有这一步


MHA的参数我也都配置了,如下:
# cat /etc/mha/mha.conf

manager_log=/usr/local/mha/manager.log
manager_workdir=/usr/local/mha
master_ip_failover_script=/usr/local/bin/master_ip_failover
master_ip_online_change_script=/usr/local/bin/master_ip_online_change
report_script=/usr/local/bin/send_report//这个脚本没有执行
password=mysql
ping_interval=1
remote_workdir=/usr/local/mha
repl_password=repl
repl_user=repl
report_script=""
secondary_check_script=masterha_secondary_check -s 192.168.175.122 -s 192.168.175.123
shutdown_script=""
ssh_user=root
user=root


不管是 自动Failover的方式还是手动Failover的方式, 均不执行send_report的脚本,下面是手动failover的执行命令,请教各位大神们, 问题出在哪里了?

bluesky 发表于 2017-2-21 23:31:50

解决了,真想骂娘,后面居然跟了个send_report=""把上面的配置给覆盖了,被这个粗心大意的配置折磨了整整两天啊,抽死我得了!

kider 发表于 2017-2-22 08:32:41

解决了就好,也写出了问题所在,同时给大家也提了个醒,赞!:victory:
页: [1]
查看完整版本: MHA的failover时send_report指定的脚本没有执行是什么原因?