default-character-set参数导致MHA启动失败

启动MHA的时候，进程报错退出：
[root@test11g ~]# masterha_check_status --conf=/etc/masterha/mha.cnf 
mha is stopped(2:NOT_RUNNING).
[root@test11g ~]# nohup masterha_manager --conf=/etc/masterha/mha.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /tol/mha/log/manager.log 2>&1 &
[1] 2355
[root@test11g ~]# masterha_check_status --conf=/etc/masterha/mha.cnf                                                             mha monitoring program is now on initialization phase(10:INITIALIZING_MONITOR). Wait for a while and try checking again.
[root@test11g ~]# masterha_check_status --conf=/etc/masterha/mha.cnf 
mha is stopped(2:NOT_RUNNING).
[1]+  Exit 1                  nohup masterha_manager --conf=/etc/masterha/mha.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /tol/mha/log/manager.log 2>&1

查看MHA日志：
Thu Nov 27 12:58:07 2014 - [info] Binlog setting check done.
Thu Nov 27 12:58:07 2014 - [info] Checking SSH publickey authentication and checking recovery script configurations on all alive slave servers..
Thu Nov 27 12:58:07 2014 - [info]   Executing command : apply_diff_relay_logs --command=test --slave_user='root' --slave_host=192.168.100.48 --slave_ip=192.168.100.48 --slave_port=3306 --workdir=/tmp --target_version=5.5.18-log --manager_version=0.56 --relay_log_info=/tol/mysql/data/relay-log.info  --relay_dir=/tol/mysql/data/  --slave_pass=xxx
Thu Nov 27 12:58:07 2014 - [info]   Connecting to root@192.168.100.48(192.168.100.48:22).. 
mysqlbinlog: unknown variable 'default-character-set=utf8'
mysqlbinlog version command failed with rc 7:0, please verify PATH, LD_LIBRARY_PATH, and client options
 at /usr/bin/apply_diff_relay_logs line 493
Thu Nov 27 12:58:08 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln205] Slaves settings check failed!
Thu Nov 27 12:58:08 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln413] Slave configuration failed.
Thu Nov 27 12:58:08 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations.  at /usr/bin/masterha_manager line 50
Thu Nov 27 12:58:08 2014 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Thu Nov 27 12:58:08 2014 - [info] Got exit code 1 (Not master dead).

从日志可以看出，是由于设置了 default-character-set=utf8参数导致mysqlbinlog命令无法正常运行

这个问题确实很蛋疼，解决办法：
给mysqlbinlog增加一个别名
alias mysqlbinlog='mysqlbinlog --no-defaults'

重新启动：
[root@test11g log]# nohup masterha_manager --conf=/etc/masterha/mha.cnf --remove_dead_master_conf --ignore_last_failover < /dev/null > /tol/mha/log/manager.log 2>&1 &
[1] 5341
[root@test11g log]# masterha_check_status --conf=/etc/masterha/mha.cnf                                                          
mha monitoring program is now on initialization phase(10:INITIALIZING_MONITOR). Wait for a while and try checking again.
[root@test11g log]# masterha_check_status --conf=/etc/masterha/mha.cnf 
mha (pid:5341) is running(0:PING_OK), master:192.168.100.50

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23249684/viewspace-1348730/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23249684/viewspace-1348730/