使用docker-compose搭建MySQL主从

原创已于 2024-05-14 21:31:00 修改 · 1.6k 阅读

9 ·

CC 4.0 BY-SA版权

文章标签：

#docker #mysql #容器

于 2024-05-14 15:42:25 首次发布

docker+k8s 专栏收录该内容

2 篇文章

订阅专栏

1.确保docker环境已经安装完毕

2.确认docker-compose已经安装完毕

3.编写docker-compose.yml文件

8.slave副本用户连接master配置

9.测试主从数据是否一致

1.确保docker环境已经安装完毕

docker version

2.确认docker-compose已经安装完毕

docker-compose version

3.编写docker-compose.yml文件

version: '3.2'
services:
  mysql-master:
    image: "mysql:5.7"
    container_name: master
    restart: always
    privileged: true
    environment:
      MYSQL_ROOT_PASSWORD: 123456  #主库root用户的密码
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M;
    ports:
      - 13306:3306  #映射宿主机端口：容器端口
    volumes:  #宿主机配置目录或文件挂载到容器
      - /home/mysql/master/my.cnf:/etc/mysql/my.cnf
      - /home/mysql/master/mysql-files:/var/lib/mysql-files
      - /home/mysql/master/data:/var/lib/mysql
      - /home/mysql/master/log:/var/log/
    networks:
      mysql-canal-network:
        aliases:
          - mysql-master
  mysql-slave:
    image: "mysql:5.7"
    container_name: slave01
    restart: always
    privileged: true
    environment:
      MYSQL_ROOT_PASSWORD: 123456  #从库root用户的密码
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M;
    ports:
      - 13307:3306  #映射宿主机端口：容器端口
    volumes:  #宿主机配置目录或文件挂载到容器
      - /home/mysql/slave/my.cnf:/etc/mysql/my.cnf
      - /home/mysql/slave/mysql-files:/var/lib/mysql-files
      - /home/mysql/slave/data:/var/lib/mysql
      - /home/mysql/slave/log:/var/log/
    networks:
      mysql-canal-network:
        aliases:
          - mysql-slave
networks:  #定义容器连接网络
  mysql-canal-network:
    driver: bridge

4.master节点my.cnf配置

根据docker-compose.yml中的挂载配置，创建/home/mysql/master/my.conf文件

[client]
port        = 13306
socket      = /var/run/mysqld/mysqld.sock
 
[mysqld_safe]
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
nice        = 0
 
[mysqld]
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
secure-file-priv=/var/lib/mysql-files
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
 
log-bin = mysql-bin
server-id = 1

5.slave节点my.conf配置

根据docker-compose.yml中的挂载配置，创建/home/mysql/slave/my.conf文件

[client]
port        = 13307
socket      = /var/run/mysqld/mysqld.sock
 
[mysqld_safe]
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
nice        = 0
 
[mysqld]
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
secure-file-priv=/var/lib/mysql-files
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
 
log-bin = mysql-bin
server-id = 2

说明：

主从节点my.conf配置的server-id不能一样；另外，挂载目录如果宿主机没有需要提前创建好

6.启动容器

docker-compose -f docker-compose.yml up -d

-f 指定启动配置文件

-d 后台启动

查看启动日志：docker-compose logs -f

7.master给副本用户授权

mysql>GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' identified by '123456';

>flush privileges;

>show master status \G;

8.slave副本用户连接master配置

mysql>CHANGE MASTER TO

>MASTER_HOST='172.21.0.2', -- 配置主节点的IP

>MASTER_USER='repl', -- 连接主节点的副本账户

>MASTER_PASSWORD='123456', --连接主节点的副本账户密码

>MASTER_LOG_FILE='mysql-bin.000004', -- 监听主节点的bin-log文件

>MASTER_LOG_POS=368; --监听主节点bin-log文件的起始位置

如果执行不成功，先> stop slave，然后>start slave;

如果还不行>reset slave，然后重复8步骤。

查看从节点状态：>show slave status \G;