错误如下:
Wed May 9 14:40:03 2018 - [info] Connecting to root@192.168.10.120(db1:22).. mysqlbinlog: unknown variable 'default-character-set=utf8mb4' 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 Wed May 9 14:40:03 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln205] Slaves settings check failed! Wed May 9 14:40:03 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln413] Slave configuration failed. Wed May 9 14:40:03 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/bin/masterha_manager line 50 Wed May 9 14:40:03 2018 - [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers. Wed May 9 14:40:03 2018 - [info] Got exit code 1 (Not master dead).
原因:
由于开发需要更改默认字符集UTF8到utf8mb4来支持表情,故my.cnf修改了如下
[client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4'修改后启动等都没有错,但是启动mha报错
解决办法:
在所有从服务器上注释掉clinet段default-character-set=utf8mb4
[client] #default-character-set=utf8mb4再次启动MHA,发现正常
评论区