tnb0/ha/mysql80/mgr_bootstrap.sh

#!/bin/bash

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

# 根据 GTID 判断数据新旧
docker exec -i mysql80-1 mysql -uroot -pRoot_123456  -e"
SELECT @@global.gtid_executed;
"

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

docker exec -i mysql80-3 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 "
START GROUP_REPLICATION USER='repl', PASSWORD='Repl_123456';
"

docker exec -i mysql80-3 mysql -uroot -pRoot_123456 -e "
START GROUP_REPLICATION USER='repl', PASSWORD='Repl_123456';
"