docker-compose部署MySQL

• 主编写docker-compose文件

version: '3.0'
services:
  mysql:
    container_name: mysql57
    image: mysql:5.7.44
    restart: always
    ports:
      - 3306:3306
    privileged: true
    volumes:
      - /u01/mysql/conf/my.cnf:/etc/mysql/my.cnf
      - /u01/mysql/data:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: "123"
      TZ: Asia/Shanghai

• 配置主节点

CREATE USER 'slave'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%';
FLUSH PRIVILEGES;
SHOW MASTER STATUS;

• 从节点启动后配置从节点

CHANGE MASTER TO MASTER_HOST='192.168.10.123',MASTER_USER='slave',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000005',MASTER_LOG_POS=7534;
START SLAVE;