mysql8.0 docker 搭建基于GTID主从复制并设置从库只读模块

最新推荐文章于 2025-02-18 21:43:14 发布

原创

最新推荐文章于 2025-02-18 21:43:14 发布 · 734 阅读

0 ·

CC 4.0 BY-SA版权

本教程详细介绍了如何在MySQL8.0中利用Docker搭建基于GTID的主从复制，并设置从库为只读模式。步骤包括配置my.cnf，创建复制用户，查看主库状态，设置主从同步以及在主库上创建不同权限的用户以确保从库只读。

1、创建 docker 容器

######主库#####
docker run -dit \
--net hadoop-master-net \
--ip 192.168.0.202 \
--restart always \
--privileged=true \
--hostname hadoop-master-mysql_13311 \
--name hadoop-master-mysql_13311 \
-v /home/docker/software/mysql-13311/conf/:/etc/mysql/conf.d \
-v /home/docker/software/mysql-13311/data/:/var/lib/mysql \
-v /home/docker/software/mysql-13311/logs/:/logs \
-v /elasticsearch/data/mysql/:/home/ \
-v /etc/localtime:/etc/localtime \
-e TZ='Asia/Shanghai' \
-e LANG="en_US.UTF-8" \
-e MYSQL_ROOT_PASSWORD=seowen123456 \
-p 13311:3306 \
-p 23311:33060 \
mysql:latest \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_general_ci

######从库1#####
docker run -dit \
--net hadoop-slave1-net \
--ip 192.168.0.203 \
--restart always \
--privileged=true \
--hostname hadoop-slave1-mysql_13311 \
--name hadoop-slave1-mysql_13311 \
-v /home/docker/software/mysql-13311/conf/:/etc/mysql/conf.d \
-v /home/docker/software/mysql-13311/data/:/var/lib/mysql \
-v /home/docker/software/mysql-13311/logs/:/logs \
-v /elasticsearch/data/mysql/:/home/ \
-v /etc/localtime:/etc/localtime \
-e TZ='Asia/Shanghai' \
-e LANG="en_US.UTF-8" \
-e MYSQL_ROOT_PASSWORD=seowen@123456 \
-p 13311:3306 \
-p 23311:33060 \
mysql:latest \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_general_ci


######从库2#####
docker run -dit \
--net hadoop-slave2-net \
--ip 192.168.0.203 \
--restart always \
--privileged=true \
--hostname hadoop-slave2-mysql_13311 \
--name hadoop-slave2-mysql_13311 \
-v /home/docker/software/mysql-13311/conf/:/etc/mysql/conf.d \
-v /home/docker/software/mysql-13311/data/:/var/lib/mysql \
-v /home/docker/software/mysql-13311/logs/:/logs \
-v /elasticsearch/data/mysql/:/home/ \
-v /etc/localtime:/etc/localtime \
-e TZ='Asia/Shanghai' \
-e LANG="en_US.UTF-8" \
-e MYSQL_ROOT_PASSWORD=seowen@123456 \
-p 13311:3306