docker exec -it node1 mysql -uroot -pmypass \
-e "SET @@GLOBAL.group_replication_bootstrap_group=1;" \
-e "create user 'repl'@'%' identified by 'P@ssword1!';" \
-e "GRANT REPLICATION SLAVE ON *.* TO repl@'%';" \
-e "flush privileges;" \
-e "change master to master_user='repl', master_password='P@ssword1!' for channel 'group_replication_recovery';" \
-e "START GROUP_REPLICATION;" \
-e "SET @@GLOBAL.group_replication_bootstrap_group=0;" \
-e "SELECT * FROM performance_schema.replication_group_members;"
新增其他节点
for N in 2 3
do docker exec -it node$N mysql -uroot -pmypass \
-e "change master to master_user='repl', master_password='P@ssword1!' for channel 'group_replication_recovery';" \
-e "START GROUP_REPLICATION;"
done
验证集群是否正常
docker exec -it node1 mysql -uroot -pmypass \
-e "SELECT * FROM performance_schema.replication_group_members;"