mysqlbinlog can not parse row based events

Terminating script for safety reasons. at /usr/bin/apply_diff_relay_logs line 493Mon Feb 16 20:46:16 2015 – [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln412] Slaves settings check failed!Mon Feb 16 20:46:16 2015 – [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln275] Slave configuration failed.Mon Feb 16 20:46:16 2015 – [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln520] Error happened on checking configurations. at /usr/bin/masterha_check_repl line 48Mon Feb 16 20:46:16 2015 – [error][/usr/lib/perl5/site_perl/5.8.8/MHA/MasterMonitor.pm, ln691] Error happened on monitoring servers.Mon Feb 16 20:46:16 2015 – [info] Got exit code 1 (Not master dead).

3、故障解决###直接使用软链的方式来使得MHA调用的mysqlbinlog版本为3.4版# mv /usr/bin/mysqlbinlog /usr/bin/mysqlbinlog.bk# ln -s /app/soft/mysql/bin/mysqlbinlog /usr/bin/mysqlbinlog# /usr/bin/mysqlbinlog –version/usr/bin/mysqlbinlog Ver 3.4 for Linux at x86_64

###也可以卸载系统当前的mysql rpm包,如果缺省路径下无mysql实例的话,,如下方式# rpm -qa|grep mysqlmysql-5.0.95-5.el5_9# rpm -e –nodeps mysql-5.0.95-5.el5_9warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave# more /etc/my.cnf/etc/my.cnf: No such file or directory

###注意,卸载缺省的rpm包之后,缺省的my.cnf被复制为/etc/my.cnf.rpmsave,需要复制回去。# cp /etc/my.cnf.rpmsave /etc/my.cnf

4、延伸参考 使用mysqlbinlog提取二进制日志 MySQL抑制binlog日志中的BINLOG部分

做事不怕难,自无难人事。

mysqlbinlog can not parse row based events

相关文章:

你感兴趣的文章:

标签云: