db2(192.168.218.131) master/REPLICATION_FAIL. Roles:-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_43147497/article/details/82463615

本文记录了一次mysql-mmm高可用群集遇到的REPLICATION_FAIL错误处理过程。通过reset slave及更改master配置，成功解决了slave状态异常问题，恢复正常运行。

mysql-mmm高可用群集输入mmm_control show时出现以下报错：
db2(192.168.218.131) master/REPLICATION_FAIL. Roles:

切换db2至online状态时，出现以下报错
[root@yandada5 mysql-mmm]# mmm_control set_online db2
ERROR: Host ‘db2’ is ‘REPLICATION_FAIL’ at the moment. It can’t be switched to ONLINE.

切换至db2主机查看slave状态

mysql> show slave status \G;
Last_SQL_Errno: 1700
Last_SQL_Error: Error ‘GRANT with IDENTIFIED WITH is illegal because the user mmm_monitor already exists’ on query. Default database: ”. Query: ‘GRANT REPLICATION CLIENT ON . TO ‘mmm_monitor’@’192.168.218.%’ IDENTIFIED WITH ‘mysql_native_password’ AS ‘*6691484EA6B50DDDE1926A220DA01FA9E575C18A”

解决措施：reset slave;
mysql> change master to master_host=’192.168.218.130’,master_user=’replication’,master_password=’abc123’,master_log_file
-> =’mysql_bin.000009’,master_log_pos=7313;

再次查看状态：mysql> show slave status \G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
无异常
问题解决：
[root@yandada5 mysql-mmm]# mmm_control show
db1(192.168.218.130) master/ONLINE. Roles: writer(192.168.218.250)
db2(192.168.218.131) master/ONLINE. Roles:
db3(192.168.218.138) slave/ONLINE. Roles: reader(192.168.218.252)
db4(192.168.218.133) slave/ONLINE. Roles: reader(192.168.218.251)