tnb0/ha/mysql80/init_mgr2.sh

#!/bin/bash

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

echo "正在准备节点 mysql80-2..."
docker exec -i mysql80-2 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

# 3. 加入从节点 (同样在 START 时传入凭证)
echo ">>> 加入从节点 mysql80-2..."
docker exec -i mysql80-2 mysql -uroot -pRoot_123456 -e "
  START GROUP_REPLICATION USER='${MGR_USER}', PASSWORD='${MGR_PASS}';
"