- A+
所属分类：linux问题解决
错误如下：
|
1 2 3 4 5 6 7 8 9 10 11 |
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修改了如下
|
1 2 3 4 5 6 7 8 9 10 11 12 |
[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
|
1 2 3 |
[client] #default-character-set=utf8mb4 |
再次启动MHA，发现正常
- 我的微信
- 这是我的微信扫一扫
-
- 我的微信公众号
- 我的微信公众号扫一扫
-
