tnb0/ha/mysql80/init_mgr1.sh

#!/bin/bash

ROOT_PASS="Root_123456"
MGR_USER="repl"
MGR_PASS="Repl_123456"

echo "正在准备节点 mysql80-1..."
docker exec -i mysql80-1 mysql -uroot -p${ROOT_PASS} <<EOF
STOP GROUP_REPLICATION;
RESET MASTER;

SET SQL_LOG_BIN=0;
CREATE USER IF NOT EXISTS '${MGR_USER}'@'%' IDENTIFIED WITH mysql_native_password BY '${MGR_PASS}';
GRANT REPLICATION SLAVE ON *.* TO '${MGR_USER}'@'%';
GRANT BACKUP_ADMIN ON *.* TO '${MGR_USER}'@'%';
FLUSH PRIVILEGES;
SET SQL_LOG_BIN=1;
EOF

# 2. 引导主节点 (在 START 时直接传入凭证)
echo ">>> 引导主节点 mysql80-1..."
docker exec -i mysql80-1 mysql -uroot -p${ROOT_PASS} <<EOF
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION USER='${MGR_USER}', PASSWORD='${MGR_PASS}';
SET GLOBAL group_replication_bootstrap_group=OFF;
EOF

# 查看集群状态
echo "----------------------------------------"
docker exec -i mysql80-1 mysql -uroot -pRoot_123456 -e "
SELECT * FROM performance_schema.replication_group_members;
"