MySQL 8.0 Replication主从集群Docker-compose搭建

最新推荐文章于 2024-09-06 16:52:40 发布

梵莫

最新推荐文章于 2024-09-06 16:52:40 发布

阅读量834

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库 MySQL高可用

本文链接：https://blog.youkuaiyun.com/weixin_43981099/article/details/106267634

本文详细介绍了如何使用Docker-compose搭建MySQL 8.0的主从复制集群，包括所需软件版本、配置文件制作、容器创建与运行、同步用户的创建与授权、从库的主库信息配置、同步启动与状态检查。特别提醒，主库必须使用有权限的用户进行操作，且在手动对齐同步点前需确保数据一致。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.需要的软件及版本

MySQL镜像版本 8.0

Docker版本 19.03.9

Docker-compose版本 1.25.5

2.准备配置文件

2.1 docker-compose.yml文件

稍后的命令

docker-compose  up -d

会根据此文件创建docker网络，并根据其中的参数创建名为mysql_master和mysql_slave的两个容器

version: '2'
services:
  mysql-master:
   image: docker.io/mysql
   networks:
       jznet:
         ipv4_address: 172.18.4.24
   volumes:
     - /root/data/mysql-master:/var/lib/mysql
     - /home/xinyue/master.cnf:/etc/mysql/my.cnf
   ports:
     - "3306:3306"
   environment:
     - MYSQL_DATABASE=root
     - MYSQL_ROOT_PASSWORD=123456
  mysql-slave:
   image: docker.io/mysql
   networks:
       jznet:
         ipv4_address: 172.18.4.25
   volumes:
     - /root/data/mysql-slave:/var/lib/mysql
     - /home/xinyue/slave.cnf:/etc/mysql/my.cnf
   ports:
     - "3307:3306"
   environment:
     - MYSQL_DATABASE=root
     - MYSQL_ROOT_PASSWORD=123456
networks:
  jznet:
    driver: bridge
    ipam:
      driver: default
      config:
      - subnet: 172.18.4.0/26

2.2 Master主库配置文件

Master的配置文件,保存在/home/xinyue/目录下，名称为master.cnf

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
server-id=1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Custom config should go here
!includedir /etc/mysql/conf.d/

2.3 Slave主库配置文件

Slave的配置文件,保存在/home/xinyue/目录下，名称为slave.cnf

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation,