mysql mha masterha_check_repl 错误

kylin3278

[root@swserver samples]# masterha_check_repl --conf=/etc/app1.cnf
Tue Aug  4 15:51:26 2015 - [info] Reading default configuration from /etc/masterha_default.cnf..
Tue Aug  4 15:51:26 2015 - [info] Reading application default configuration from /etc/app1.cnf..
Tue Aug  4 15:51:26 2015 - [info] Reading server configuration from /etc/app1.cnf..
Tue Aug  4 15:51:26 2015 - [info] MHA::MasterMonitor version 0.56.
Tue Aug  4 15:51:29 2015 - [info] GTID failover mode = 1
Tue Aug  4 15:51:29 2015 - [info] Dead Servers:
Tue Aug  4 15:51:29 2015 - [info] Alive Servers:
Tue Aug  4 15:51:29 2015 - [info]   192.168.1.201(192.168.1.201:3306)
Tue Aug  4 15:51:29 2015 - [info]   192.168.1.202(192.168.1.202:3310)
Tue Aug  4 15:51:29 2015 - [info] Alive Slaves:
Tue Aug  4 15:51:29 2015 - [info]   192.168.1.202(192.168.1.202:3310)  Version=5.6.24-enterprise-commercial-advanced-log (oldest major version between slaves) log-bin:enabled
Tue Aug  4 15:51:29 2015 - [info]     GTID ON
Tue Aug  4 15:51:29 2015 - [info]     Replicating from 192.168.1.201(192.168.1.201:3306)
Tue Aug  4 15:51:29 2015 - [info]     Primary candidate for the new Master (candidate_master is set)
Tue Aug  4 15:51:29 2015 - [info] Current Alive Master: 192.168.1.201(192.168.1.201:3306)
Tue Aug  4 15:51:29 2015 - [info] Checking slave configurations..
Tue Aug  4 15:51:29 2015 - [info] Checking replication filtering settings..
Tue Aug  4 15:51:29 2015 - [info]  binlog_do_db= record,test, binlog_ignore_db= information_schema,mysql
Tue Aug  4 15:51:29 2015 - [info]  Replication filtering check ok.
Tue Aug  4 15:51:29 2015 - [info] GTID (with auto-pos) is supported. Skipping all SSH and Node package checking.
Tue Aug  4 15:51:29 2015 - [info] Checking SSH publickey authentication settings on the current master..
Tue Aug  4 15:51:34 2015 - [warning] HealthCheck: Got timeout on checking SSH connection to 192.168.1.201! at /usr/share/perl5/vendor_perl/MHA/HealthCheck.pm line 342.
Tue Aug  4 15:51:34 2015 - [info]
192.168.1.201(192.168.1.201:3306) (current master)
+--192.168.1.202(192.168.1.202:3310)

Tue Aug  4 15:51:34 2015 - [info] Checking replication health on 192.168.1.202..
Tue Aug  4 15:51:34 2015 - [info]  ok.
Tue Aug  4 15:51:34 2015 - [info] Checking master_ip_failover_script status:
Tue Aug  4 15:51:34 2015 - [info]   /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover --command=status --ssh_user=root --orig_master_host=192.168.1.201 --orig_master_ip=192.168.1.201 --orig_master_port=3306
Bareword "FIXME_xxx" not allowed while "strict subs" in use at /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover line 93.
Execution of /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover aborted due to compilation errors.
Tue Aug  4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln226]  Failed to get master_ip_failover_script status with return code 255:0.
Tue Aug  4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations.  at /usr/bin/masterha_check_repl line 48
Tue Aug  4 15:51:35 2015 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Tue Aug  4 15:51:35 2015 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

[root@swserver samples]# cat /etc/app1.cnf
[server default]
user=root
password=123456
manager_workdir=/var/log/masterha/app1
manager_log=/var/log/masterha/app1/manager.log
remote_workdir=/var/log/masterha/app1

[server1]
hostname=192.168.1.201
port=3306

[server2]
hostname=192.168.1.202
port=3310
check_repl_delay=0
candidate_master=1

[root@swserver samples]# cat /etc/masterha_default.cnf
[server default]
user=root
password=123456
ssh_user=root
master_binlog_dir= /var/lib/mysql/log,/home/mysql/slave01/log
remote_workdir=/database/mha/log/masterha
repl_password=repl
repl_user=repl
secondary_check_script= masterha_secondary_check -s 192.168.1.201 -s 192.168.1.202
ping_interval=3
master_ip_failover_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover
#shutdown_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/power_manager
report_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/send_report
master_ip_online_change_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_online_change

请问是什么问题呢

asdf2110

可以把底下那3行注掉，不是必须的

master_ip_failover_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_failover
#shutdown_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/power_manager
report_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/send_report
master_ip_online_change_script= /database/masterha/mha4mysql-manager-0.56/samples/scripts/master_ip_online_change

kylin3278

回复 2# asdf2110
是我脚本没写好

   

renxiao2003

楼主可以用了吗？

kylin3278

回复 4# renxiao2003

可以用了，但是脚本还在研究中
   

renxiao2003

慢慢研究，特定的脚本有特定的调用方式。