设为首页 加入收藏

TOP

mysql高可用之mha(七)
2015-11-21 01:50:33 来源: 作者: 【 】 浏览:7
Tags: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
首页 上一页 4 5 6 7 8 9 10 下一页 尾页 7/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇阿里云远程如何访问mysql 下一篇eclipse连接mysql

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: