记MySql-8.0的MY-011495错误

最新推荐文章于 2023-09-28 14:28:05 发布

Azrael、

最新推荐文章于 2023-09-28 14:28:05 发布

阅读量970

点赞数

分类专栏： mysql dba 数据库文章标签： MGR Mysql 脑裂

本文链接：https://blog.youkuaiyun.com/qq_18913471/article/details/103067515

版权

本文详细记录了在MySQL 8.0中遇到的组复制（MGR）错误MY-011495，即由于多数成员不可达导致的脑裂问题。通过分析错误信息和代码，提出了解决方案，包括使用`group_replication_force_members`恢复集群和调整相关配置参数以防止异常退出，如`group_replication_unreachable_majority_timeout`、`group_replication_recovery_retry_count`和`group_replication_recovery_reconnect_interval`。同时，还介绍了如何通过设置组复制压缩和分段传输来避免大事务导致的异常退出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一：报错信息：

[Warning] [MY-011493] [Repl] Plugin group_replication reported: 'Member with address 172.29.12.79:24803 has become unreachable.'

[Warning] [MY-011493] [Repl] Plugin group_replication reported: 'Member with address 172.29.12.80:24805 has become unreachable.'

Plugin group_replication reported: 'This server is not able to reach a majority of members in the group. This server will now block all updates. The server will remain blocked until contact with the majority is restored. It is possible to use group_replication_force_members to force a new group membership.'

二：报错编码对照信息

Error number: MY-011495; Symbol: ER_GRP_RPL_SRV_BLOCKED; SQLSTATE: HY000

Message: This server is not able to reach a majority of members in the group. This server will now block all updates. The server will remain blocked until contact with the majority is restored. It is possible to use group_replication_force_membe

最低0.47元/天解锁文章