MGR 完全重启流程

1.停止集群所有节点

STOP GROUP_REPLICATION;

2.检查每个节点的事务应用状态

SELECT @@GLOBAL.GTID_EXECUTED;

-- 查询2：已接收认证但可能未应用的事务

SELECT received_transaction_set

FROM performance_schema.replication_connection_status

WHERE channel_name = "group_replication_applier";

3.找一个事务最完整的节点作为首节点

SET GLOBAL group_replication_bootstrap_group = ON;

START GROUP_REPLICATION;

SET GLOBAL group_replication_bootstrap_group = OFF;

4.验证引导成功

SELECT * FROM performance_schema.replication_group_members;

SELECT * FROM performance_schema.replication_group_member_stats\G

5.加入其他事务完整节点

START GROUP_REPLICATION;

6.加入其他事务不完整节点

START GROUP_REPLICATION;

7.监控节点1的恢复过程

-- 查看成员状态

SELECT MEMBER_ID, MEMBER_HOST, MEMBER_STATE FROM performance_schema.replication_group_members;

-- 查看applier状态

SELECT * FROM performance_schema.replication_applier_status\G

ITPub博客

MGR完全重启流程