tnb0/ha/mysql80/init_mgr3.sh

#!/bin/bash

CONTAINER_NAME="mysql80-3"
ROOT_PASS="Root_123456"
MGR_USER="repl"
MGR_PASS="Repl_123456"

echo "正在准备节点 ${CONTAINER_NAME}..."
docker exec -i ${CONTAINER_NAME} 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

# 作为从节点加入集群
echo ">>> 加入从节点 ${CONTAINER_NAME}..."
docker exec -i ${CONTAINER_NAME} mysql -uroot -pRoot_123456 -e "
  START GROUP_REPLICATION USER='${MGR_USER}', PASSWORD='${MGR_PASS}';
"

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