Home > database >  There is something wrong with MHA configuration, a great god come to Chou Chou!!!!!
There is something wrong with MHA configuration, a great god come to Chou Chou!!!!!

Time:01-30

Here is red!!
I the second node, the third node mysqlbinlog, find a directory of red!! , the first original also have no, I don't know why there are
[root @ localhost bin] # ls
Mysql mysqlbinlog
[root @ localhost bin] # vi mysqlbinlog
[root @ localhost bin] # CD/usr/local/bin
[root @ localhost bin] # ls
Mysql mysqlbinlog
[root @ localhost bin] # which mysqlbinlog
/usr/bin/which: no mysqlbinlog in (/usr/local/bin:/usr/local/sbin,/usr/bin:/usr/sbin/bin,/sbin,/home/fengshuo/local/bin:/home/fengshuo/bin)
[root @ localhost bin] #

MYSQL replication connection error!!!!!!!!!!

[info] Executing the command: apply_diff_relay_logs -- command=test - slave_user='root' - slave_host=192.168.117.13 - slave_ip=192.168.117.13 - slave_port=3306 - workdir=/mydata mha_master/app1 target_version=5.7.24 - log - manager_version=0.58 - relay_log_info=/usr/local/mysql/data/relay - the info - relay_dir=/usr/local/mysql/data/-- slave_pass=XXX
Sat, Jan 30 01:16:48 2021 - [info] Connecting to [email protected] (192.168.117.13:22).
Can 't exec "mysqlbinlog" : no files or directories at/usr/share/perl 5/vendor_perl/MHA/BinlogManager PM line 106.
Mysqlbinlog version command failed with rc 1-0, both please verify PATH, LD_LIBRARY_PATH, and client options
The at/usr/bin/apply_diff_relay_logs line 532.

Sat, Jan 30 01:16:49 2021 - [error] [/usr/share/perl 5/vendor_perl/MHA/MasterMonitor PM, ln208] Slaves Settings check failed!
Sat, Jan 30 01:16:49 2021 - [error] [/usr/share/perl 5/vendor_perl/MHA/MasterMonitor PM, ln416] Slave configuration failed.
Sat, Jan 30 01:16:49 2021 - [error] [/usr/share/perl 5/vendor_perl/MHA/MasterMonitor PM, ln427] error happened on checking configurations. The at/usr/bin/masterha_check_repl line 48.
Sat, Jan 30 01:16:49 2021 - [error] [/usr/share/perl 5/vendor_perl/MHA/MasterMonitor PM, ln525] error happened on monitoring the servers.
Sat, Jan 30 01:16:49 2021 - [info] Got the exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!
  • Related