MHA高可用启动报错集合

最新推荐文章于 2024-10-26 09:56:17 发布

原创最新推荐文章于 2024-10-26 09:56:17 发布 · 1.1k 阅读

1 ·

CC 4.0 BY-SA版权

项目报错专栏收录该内容

10 篇文章

订阅专栏

本文记录了在配置MHA（MySQL High Availability）过程中遇到的两个主要错误：1) 主机权限问题导致无法连接MySQL服务器；2) 备用主服务器缺少REPLICATION SLAVE权限。解决方法包括在所有数据库节点上为管理用户和复制用户授权，并在主备服务器上添加复制权限。

错误1

[error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 20.0.0.23(20.0.0.23:3306) :1130:Host ‘20.0.0.21’ is not allowed to connect to this MySQL server, but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Sun Nov 1 15:09:09 2020 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln301] Got MySQL error when connecting 20.0.0.24(20.0.0.24:3306) :1130:Host ‘20.0.0.21’ is not allowed to connect to this MySQL server, but this is not a MySQL crash. Check MySQL server settings.
at /usr/local/share/perl5/MHA/ServerManager.pm line 297.
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/ServerManager.pm, ln309] Got fatal error, stopping operations
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/share/perl5/MHA/MasterMonitor.pm line 329.
Sun Nov 1 15:09:14 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Sun Nov 1 15:09:14 2020 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

修改：
在所有数据库节点上授权两个用户，一个是从库同步使用，另外一个是 manager 使用。

1 mysql> grant replication slave on *.* to 'myslave'@'20.0.0.%' identified by '123';
2 mysql> grant all privileges on *.* to 'mha'@'20.0.0.%' identified by 'manager';
3 mysql> flush privileges;

错误2

[error][/usr/local/share/perl5/MHA/Server.pm, ln398] 20.0.0.23(20.0.0.23:3306): User myslave does not exist or does not have REPLICATION SLAVE privilege! Other slaves can not start replication from this host.
Sun Nov 1 15:16:23 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln427] Error happened on checking configurations. at /usr/local/share/perl5/MHA/ServerManager.pm line 1403.
Sun Nov 1 15:16:23 2020 - [error][/usr/local/share/perl5/MHA/MasterMonitor.pm, ln525] Error happened on monitoring servers.
Sun Nov 1 15:16:23 2020 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

修改方法：
备用主服务器没有复制的权限
在主备服务器上加权限

grant all privileges on *.* to 'mha'@'20.0.0.%' identified by 'manager';