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

-p 3307:3306
-d mysql --default-authentication-plugin=mysql_native_password

3、配置 master & slave

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; "

4、重启 master & slave

docker restart mysql-master mysql-slave

5、连接 master & 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;"

6、验证 slave 状态

docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "show slave statusG"

如下状态为正常：

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

> 验证数据同步

在 master 创建数据库 anoyi

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;"

在 slave 查看数据库列表

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        |
+--------------------+

相关资料：

mysql 5.7： https://dev.mysql.com/doc/refman/5.7/en/replication.html
mysql 8.0： https://dev.mysql.com/doc/refman/8.0/en/replication.html

您可能感兴趣的文章:docker搭建php+nginx+swoole+mysql+redis环境的方法Dockerfile指令与基本结构的讲解Docker 容器日志分析使用docker快速部署Elasticsearch集群的方法使用dockercompose搭建springboot-mysql-nginx应用使用Docker部署Spring Boot的方法示例使用Docker部署Nginx+Flask+Mongo的应用详细记一次Docker部署服务的爬坑历程docker中的环境变量使用与常见问题解决方案docker打包node项目的过程讲解