mysql高可用之mha - 数据库编程

6 --workdir=/tmp --target_version=5.6.25-log --manager_version=0.53 --relay_log_info=/data/mysql/relay-log.info --relay_dir=/data/mysql/ --slave_pass=xxx Fri Aug 7 15:24:57 2015 - [info] Connecting to root@10.10.10.57(10.10.10.57:1022).. Checking slave recovery environment settings.. Opening /data/mysql/relay-log.info ... ok. Relay log found at /data/mysql, up to net-app1b-relay-bin.000014 Temporary relay log file is /data/mysql/net-app1b-relay-bin.000014 Testing mysql connection and privileges..Warning: Using a password on the command line interface can be insecure. done. Testing mysqlbinlog output.. done. Cleaning up test file(s).. done. Fri Aug 7 15:24:57 2015 - [info] Executing command : apply_diff_relay_logs --command=test --slave_user=mha --slave_host=10.10.10.58 --slave_ip=10.10.10.58 --slave_port=3306 --workdir=/tmp --target_version=5.6.25-log --manager_version=0.53 --relay_log_info=/data/mysql/relay-log.info --relay_dir=/data/mysql/ --slave_pass=xxx Fri Aug 7 15:24:57 2015 - [info] Connecting to root@10.10.10.58(10.10.10.58:1022).. Checking slave recovery environment settings.. Opening /data/mysql/relay-log.info ... ok. Relay log found at /data/mysql, up to net-app1b-relay-bin.000011 Temporary relay log file is /data/mysql/net-app1b-relay-bin.000011 Testing mysql connection and privileges..Warning: Using a password on the command line interface can be insecure. done. Testing mysqlbinlog output.. done. Cleaning up test file(s).. done. Fri Aug 7 15:24:57 2015 - [info] Slaves settings check done. Fri Aug 7 15:24:57 2015 - [info] 10.10.10.56 (current master) +--10.10.10.57 +--10.10.10.58 Fri Aug 7 15:24:57 2015 - [info] Checking replication health on 10.10.10.57.. Fri Aug 7 15:24:57 2015 - [info] ok. Fri Aug 7 15:24:57 2015 - [info] Checking replication health on 10.10.10.58.. Fri Aug 7 15:24:57 2015 - [info] ok. Fri Aug 7 15:24:57 2015 - [info] Checking master_ip_failover_script status: Fri Aug 7 15:24:57 2015 - [info] /usr/local/bin/master_ip_failover --command=status --ssh_user=root --orig_master_host=10.10.10.56 --orig_master_ip=10.10.10.56 --orig_master_port=3306 --orig_master_ssh_port=1022 Bareword "FIXME_xxx" not allowed while "strict subs" in use at /usr/local/bin/master_ip_failover line 88. Execution of /usr/local/bin/master_ip_failover aborted due to compilation errors. Fri Aug 7 15:24:57 2015 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln214] Failed to get master_ip_failover_script status with return code 255:0. Fri Aug 7 15:24:57 2015 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln383] Error happend on checking configurations. at /usr/local/bin/masterha_check_repl line 48 Fri Aug 7 15:24:57 2015 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln478] Error happened on monitoring servers. Fri Aug 7 15:24:57 2015 - [info] Got exit code 1 (Not master dead). MySQL Replication Health is NOT OK!

最后发现我们检查结果是not ok的，是master_ip_failover_script中的脚本有错误，我们暂时将其注释掉后，再检查一遍。

[root@rd-mysql-test4 scripts]# masterha_check_repl --conf=/etc/mha/app1.cnf 
Fri Aug  7 15:27:22 2015 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
Fri Aug  7 15:27:22 2015 - [info] Reading application default configurations from /etc/mha/app1.cnf..
Fri Aug  7 15:27:22 2015 - [i

mysql高可用之mha(七)