1. 拉取镜像，创建独立网络
docker pull mysql/mysql-server:8.0.16
docker network create mysql_mgr
docker network ls
2. 创建三节点容器
for N in 1 2 3
do docker run -d --name=node$N --net=mysql_mgr --hostname=node$N \
-v $PWD/d$N:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mypass \
mysql/mysql-server:8.0.16 \
--server-id=$N \
--log-bin='mysql-bin-1.log' \
--enforce-gtid-consistency='ON' \
--log-slave-updates='ON' \
--gtid-mode='ON' \
--transaction-write-set-extraction='XXHASH64' \
--binlog-checksum='NONE' \
--master-info-repository='TABLE' \
--relay-log-info-repository='TABLE' \
--plugin-load='group_replication.so' \
--relay-log-recovery='ON' \
--group-replication-start-on-boot='OFF' \
--group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
--group-replication-local-address="node$N:33061" \
--group-replication-group-seeds='node1:33061,node2:33061,node3:33061' \
--loose-group-replication-single-primary-mode='OFF' \
--loose-group-replication-enforce-update-everywhere-checks='ON'
done
其中
--loose-group-replication-single-primary-mode='OFF' # 如果单主模式，则设置为ON
--loose-group-replication-enforce-update-everywhere-checks='ON' # 如果单主模式，则设置为OFF
3. 主节点启动组复制
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;"
4. 从节点启动组复制
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
5. 查看组复制状态
docker exec -it node1 mysql -uroot -pmypass \
-e "SELECT * FROM performance_schema.replication_group_members;"
实际运行一段时间后报错
2023-07-25T07:47:07.860997Z 22 [ERROR] [MY-011582] [Repl] Plugin group_replication reported: 'There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.'
2023-07-25T07:47:07.861030Z 22 [ERROR] [MY-011583] [Repl] Plugin group_replication reported: 'For details please check performance_schema.replication_connection_status table and error log messages of Slave I/O for channel group_replication_recovery.'
2023-07-25T07:48:07.873180Z 22 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='node1', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='node1', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-07-25T07:48:07.881110Z 60 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2023-07-25T07:48:07.882531Z 60 [ERROR] [MY-010584] [Repl] Slave I/O for channel 'group_replication_recovery': error connecting to master 'test@node1:3306' - retry-time: 60 retries: 1, Error_code: MY-001045