侧边栏壁纸
博主头像
爱运维 博主等级

行动起来,活在当下

  • 累计撰写 197 篇文章
  • 累计创建 143 个标签
  • 累计收到 21 条评论

目 录CONTENT

文章目录

MHA无法启动报错unknown variable 'default-character-set=utf8mb4'

Administrator
2018-05-09 / 0 评论 / 0 点赞 / 2 阅读 / 0 字

错误如下:

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,发现正常




0
mha

评论区