使用Docker部署MySQL 5.7&8.0主从集群的方法步骤

docker network create --driver overlay common-network --attachable

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[mysqld]
log-bin=mysql-bin
server-id=1
gtid-mode=ON
enforce-gtid-consistency=ON

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[mysqld]
server-id=2
gtid-mode=ON
enforce-gtid-consistency=ON

docker run -d --name mysql-master --network common-network -e MYSQL_ROOT_PASSWORD=Passw0rd -v `pwd`/master.cnf:/etc/mysql/my.cnf -p 3306:3306 -d mysql:5.7

docker run -d --name mysql-slave --network common-network -e MYSQL_ROOT_PASSWORD=Passw0rd -v `pwd`/slave.cnf:/etc/mysql/my.cnf -p 3307:3306 -d mysql:5.7

docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd -e "CREATE USER 'repl'@'%' IDENTIFIED BY 'password' REQUIRE SSL; " -e "GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';"

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_AUTO_POSITION=1, MASTER_SSL=1;" -e "START SLAVE;"

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "show slave status\G"

docker network create --driver overlay common-network --attachable

docker run -d --name mysql-master --network common-network -e MYSQL_ROOT_PASSWORD=Passw0rd -p 3306:3306 -d mysql --default-authentication-plugin=mysql_native_password

docker run -d --name mysql-slave --network common-network -e MYSQL_ROOT_PASSWORD=Passw0rd -p 3307:3306 -d mysql --default-authentication-plugin=mysql_native_password

docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd -e "SET PERSIST server_id=1;" -e "SET PERSIST_ONLY gtid_mode=ON;" -e "SET PERSIST_ONLY enforce_gtid_consistency=true; " -e "CREATE USER 'repl'@'%' IDENTIFIED BY 'password' REQUIRE SSL; " -e "GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';"

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "SET PERSIST server_id=2;" -e "SET PERSIST_ONLY gtid_mode=ON;" -e "SET PERSIST_ONLY enforce_gtid_consistency=true; "

docker restart mysql-master mysql-slave

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_AUTO_POSITION=1, MASTER_SSL=1;" -e "START SLAVE;"

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "show slave status\G"

docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd  -e "create database anoyi default character set utf8mb4 collate utf8mb4_general_ci;"

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd  -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database      |
+--------------------+
| anoyi       |
| information_schema |
| mysql       |
| performance_schema |
| sys        |
+--------------------+