mha_replication_check Can't exec "mysqlbinlog": No such file or directory

mhabbyo發表於2017-01-19
Can't exec "mysqlbinlog": No such file or directory at /usr/share/perl5/vendor_perl/MHA/BinlogManager.pm line 106.
mysqlbinlog version command failed with rc 1:0, please verify PATH, LD_LIBRARY_PATH, and client options
 at /usr/bin/apply_diff_relay_logs line 493.
Thu Jan 19 09:59:30 2017 - [error][/usr/lib/perl5/vendor_perl/MHA/MasterMonitor.pm, ln412] Slaves settings check failed!
Thu Jan 19 09:59:30 2017 - [error][/usr/lib/perl5/vendor_perl/MHA/MasterMonitor.pm, ln275] Slave configuration failed.
Thu Jan 19 09:59:30 2017 - [error][/usr/lib/perl5/vendor_perl/MHA/MasterMonitor.pm, ln520] Error happened on checking configurations.  at /usr/bin/masterha_check_repl line 48
Thu Jan 19 09:59:30 2017 - [error][/usr/lib/perl5/vendor_perl/MHA/MasterMonitor.pm, ln691] Error happened on monitoring servers.
Thu Jan 19 09:59:30 2017 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!



修改root 環境變數沒有效果後,軟連結強制呼叫命令:

[root@YRZ-TR-DBM2 ~]# ln -s /home/mysql/mysql/bin/mysqlbinlog /usr/local/bin/mysqlbinlog


Thu Jan 19 09:59:57 2017 - [info] Checking replication health on 10.50.28.96..
Thu Jan 19 09:59:57 2017 - [info]  ok.
Thu Jan 19 09:59:57 2017 - [info] Checking replication health on 10.50.28.97..
Thu Jan 19 09:59:57 2017 - [info]  ok.
Thu Jan 19 09:59:57 2017 - [info] Checking replication health on 10.50.28.65..
Thu Jan 19 09:59:57 2017 - [info]  ok.
Thu Jan 19 09:59:57 2017 - [info] Checking replication health on 10.50.28.66..
Thu Jan 19 09:59:57 2017 - [info]  ok.
Thu Jan 19 09:59:57 2017 - [warning] master_ip_failover_script is not defined.
Thu Jan 19 09:59:57 2017 - [warning] shutdown_script is not defined.
Thu Jan 19 09:59:57 2017 - [info] Got exit code 0 (Not master dead).

MySQL Replication Health is OK.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29291882/viewspace-2132665/,如需轉載,請註明出處,否則將追究法律責任。

相關文章