tnb0/ha/mysql80/mgr.md

重新引导 MGR 集群, 这是集群重启后的典型状态

根据 GTID 判断数据新旧

docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e" SELECT @@global.gtid_executed; "

假设 mysql80-1 节点的数据最新, 将其作为引导节点

docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e " SET GLOBAL group_replication_bootstrap_group=ON; START GROUP_REPLICATION USER='repl', PASSWORD='Repl_123456'; SET GLOBAL group_replication_bootstrap_group=OFF; "

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e"

SELECT @@global.gtid_executed;

"

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "

START GROUP_REPLICATION USER='repl', PASSWORD='Repl_123456';

"

docker exec -i mysql80-3 mysql -uroot -pRoot_123456 -e"

SELECT @@global.gtid_executed;

"

docker exec -i mysql80-3 mysql -uroot -pRoot_123456 -e "

START GROUP_REPLICATION USER='repl', PASSWORD='Repl_123456';

"

所有节点

CONTAINER_NAME="mysql80-1" docker exec -i ${CONTAINER_NAME} mysql -uroot -pRoot_123456 -e " STOP GROUP_REPLICATION; "

docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e " STOP GROUP_REPLICATION; "

master 节点

docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e "
# RESET MASTER;  -- 这会情况所有数据
RESET REPLICA ALL;
"

docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e "
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;
"

slave 节点

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "
STOP GROUP_REPLICATION;
RESET MASTER;
RESET REPLICA ALL;

START GROUP_REPLICATION;
"

查看从节点恢复状态

检查连接错误：在从节点上运行以下命令，查看恢复通道的报错信息

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "
SELECT * FROM performance_schema.replication_connection_status 
WHERE CHANNEL_NAME = 'group_replication_recovery'\G
"

查看具体报错：同样检查 replication_applier_status_by_worker 看看有没有拉取日志的报错

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "
SELECT * FROM performance_schema.replication_applier_status_by_worker 
WHERE CHANNEL_NAME = 'group_replication_recovery'\G
"

docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "
CHANGE REPLICATION SOURCE TO SOURCE_USER='repl', SOURCE_PASSWORD='Repl_123456' FOR CHANNEL 'group_replication_recovery';
"