Docker-Compose实现Mysql主从的示例代码

# docker-compose.yml
version: '3'
services:
  mysql:
    restart: "no"
    image: mysql:5.7.16
    container_name: mysql-master
    volumes:
      - ./datadir:/var/lib/mysql
      - ./conf/mysql:/etc/mysql
    environment:
      - "MYSQL_ROOT_PASSWord=123456"
      - "TZ=Asia/Shanghai"
    ports:
      - 3306:3306
    networks:
      - mysql-net
networks:
  mysql-net:
    driver: bridge

$ docker run --name mysql-temp -e MYSQL_ROOT_PASSWORD=root --rm -d  mysql:5.7.16

$ docker cp mysql-temp:/etc/mysql conf

$ mv my.cnf.fallback my.cnf

[mysqld]
log-bin=mysql-bin # 开启 binlog
server-id=1 # 当前server在cluster中的id，必须保证在cluster中唯一
#只保留7天的二进制日志，以防磁盘被日志占满(可选)
expire-logs-days = 7
#不备份的数据库 （可选）
binlog-ignore-db=infORMation_schema  
binlog-ignore-db=performation_schema
binlog-ignore-db=sys

CREATE USER 'slave' @'%' IDENTIFIED BY '123456';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave' @'%';
#刷新权限
FLUSH PRIVILEGES;

SHOW MASTER STATUS;
#查看Mater数据有哪些slave
select * from information_schema.processlist as p where p.command = 'Binlog Dump'; 

version: '3'
services:
  mysql:
    restart: "no"
    image: mysql:5.7.16
    container_name: mysql-slave
    volumes:
      - ./datadir:/var/lib/mysql
      - ./conf:/etc/mysql
    environment:
      - "MYSQL_ROOT_PASSWORD=123456"
      - "TZ=Asia/Shanghai"
    ports:
      - 3307:3306
    networks:
      - mysql_mysql-net
networks:
  mysql_mysql-net:
    external: true # 来自外部

[mysqld]
server-id=2
relay_log=relay-log
#开启只读 意味着当前的数据库用作读，当然这也只会影响到非root的用户，如果使用root用户操作本库是不会有影响的
read_only=ON

CHANGE MASTER TO
MASTER_HOST='mysql-master',
MASTER_USER='slave',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=154;

START SLAVE;

SHOW SLAVE STATUS;

#需要同步的数据库名 有多个库添加多行即可
binlog-do-db=test
binlog-do-db=test1
#排除的数据库
binlog-ignore-db=sys

#如果salve库名称与master库名相同，使用本配置 
replicate-do-db=test
#如果master库名[test]与salve库名[test001]不同，使用以下配置[需要做映射] 
#replicate-rewrite-db = test -> test001
#如果不是要全部同步[默认全部同步]，则指定需要同步的表 
#replicate-wild-do-table=test.user
#replicate-wild-do-table=test.role