本文介绍了在MySQL Group Replication (MGR) 多主模式下，如何处理主节点和从节点宕机并进行重启。当主节点宕机时，通过停止和启动group_replication服务恢复。若所有节点宕机，需选择新主节点，设置group_replication_bootstrap_group为ON，然后依次启动服务。从节点宕机只需直接启动group_replication。
1，初始主节点宕机
当mysql服务进程还在:
执行如下命名
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | efce3b94-e7ba-11e8-b99c-005056237187 | ndb01 | 3306 | ERROR |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
发现集群状态已经为ERROR
停止同步服务进程执行
stop group_replication;
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+----------
最低0.47元/天 解锁文章
扫一扫
495
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
