docker-compose一键部署mysql8.0主从

推荐文章

Kubernetes部署本地有状态mysql主从服务
为什么Docker不适合部署数据库？

目录结构

准备以下三个文件

[root@webapi4-app-22-151 mysql]# tree
.
├── create_sync_user.sql
├── docker-compose.yaml
└── start_slave.sql
0 directories, 3 files

create_sync_user.sql

create user 'repl'@'%' identified with 'mysql_native_password' by '000000';
grant replication slave,replication client on *.* to 'repl'@'%';
flush privileges;

start_slave.sql

change master to master_host='master',master_user='repl',master_password='000000';
start slave;

docker-compose.yaml

version: '2'
services:
  master:
    image: mysql:latest
    environment:
    - MYSQL_ROOT_PASSWORD=000000
    volumes:
    - ./create_sync_user.sql:/docker-entrypoint-initdb.d/create_sync_user.sql
    container_name: master
    restart: always
    command:
    - "--server-id=1"
    - "--log-bin=mysql-bin"
  slaver1:
    image: mysql:latest
    environment:
    - MYSQL_ROOT_PASSWORD=000000
    volumes:
    - ./start_slave.sql:/docker-entrypoint-initdb.d/start_slave.sql
    restart: always
    container_name: slaver1
    command:
    - "--server-id=2"
    - "--log-bin=mysql-bin"

1.容器内/docker-entrypoint-initdb.d目录下的文件会在数据库初始化时执行一次，只执行一次。
2.这次配置主从，没有另外修改配置文件并挂载，而是直接通过Command以参数的形式传递给Entrypoint来实现，核心配置是server-id和log-bin，其他可选配置没有配。
3.目前，mysql:latest镜像中mysql的版本是8.0.25。

启动

[root@webapi4-app-22-151 mysql]# docker-compose  up -d
Creating slaver1 ... done
Creating slaver1 ... 
[root@webapi4-app-22-151 mysql]# docker ps -a
CONTAINER ID   IMAGE          COMMAND                  CREATED         STATUS         PORTS                 NAMES
c7084eaebad2   mysql:latest   "docker-entrypoint.s…"   9 seconds ago   Up 8 seconds   3306/tcp, 33060/tcp   slaver1
97608bf7896a   mysql:latest   "docker-entrypoint.s…"   9 seconds ago   Up 8 seconds   3306/tcp, 33060/tcp   master

进入容器查看状态

[root@webapi4-app-22-151 mysql]# docker exec -it slaver1 bash
root@c7084eaebad2:/# mysql -uroot -p000000 -e "show slave status\G"