利用docker-compose实现mysql主从复制

1.首先创建挂载的目录以及配置信息

1.1 主

mkdir -p /opt/mysql/master/data
mkdir -p /opt/mysql/master/config
# 编写配置文件
vim /opt/mysql/master/config/my.cnf

my.cnf配置信息

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
secure_file_priv=/var/lib/mysql
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

2.2 从

mkdir -p /opt/mysql/slave/data
mkdir -p /opt/mysql/slave/config
# 编写配置文件
vim /opt/mysql/slave/config/my.cnf

my.cnf配置信息

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
secure_file_priv=/var/lib/mysql
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

2.编写docker-compose.yaml文件

version: '3'
services:mysql:image: mysql:8.0.20restart: alwayscontainer_name: mysqlenvironment:MYSQL_ROOT_PASSWORD: 123456TZ: Asia/Shanghaiports:- 3306:3306# 挂载信息 volumes:- /opt/mysql/master/data:/var/lib/mysql- /opt/mysql/master/config/my.cnf:/etc/mysql/my.cnfcommand:--max_connections=1000--character-set-server=utf8mb4--collation-server=utf8mb4_general_ci--default-authentication-plugin=mysql_native_password--server-id=1 --log-bin=master-binlog --innodb-flush-log-at-trx-commit=1 --sync-binlog=1 --innodb-file-per-table=1 --innodb-buffer-pool-size=2Gnetworks:- lphmysql-slave:image: mysql:8.0.20restart: alwayscontainer_name: mysql-slaveenvironment:# 设置密码 MYSQL_ROOT_PASSWORD: 123456TZ: Asia/Shanghaiports:- 3305:3306volumes:# 挂载信息 - /opt/mysql/slave/data:/var/lib/mysql- /opt/mysql/slave/config/my.cnf:/etc/mysql/my.cnfcommand: --max_connections=1000--character-set-server=utf8mb4--collation-server=utf8mb4_general_ci--default-authentication-plugin=mysql_native_password--server-id=2 --log-bin=slave-binlog --skip-log-bin --skip-slave-start --innodb-flush-log-at-trx-commit=1 --sync-binlog=1 --innodb-file-per-table=1 --innodb-buffer-pool-size=2Gnetworks:- lph
networks:lph:driver: bridge

3.启动服务

docker-compose -f docker-compose.yaml up -d

4.设置主从

4.1 主

# 进入容器
docker exec -it mysql bash
# 登录mysql
mysql -u root -p 
# 输入密码.... 在docker-compose.yaml里面已经配置了 123456# 创建用户
CREATE USER 'lph'@'%' IDENTIFIED BY '123456'; 
GRANT REPLICATION SLAVE ON *.* TO 'lph'@'%';
FLUSH PRIVILEGES;
# 查看主状态
SHOW MASTER STATUS;
reset master;
# 记录下 master-binlog.000001 以及位置 2659
mysql> SHOW MASTER STATUS;
+----------------------+----------+--------------+------------------+-------------------+
| File                 | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+----------------------+----------+--------------+------------------+-------------------+
| master-binlog.000001 |     2659 |              |                  |                   |
+----------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

4.2 从

# 进入容器
docker exec -it mysql-slave bash# 登录mysql
mysql -u root -p 
# 输入密码.... 在docker-compose.yaml里面已经配置了 123456
# 连接主数据库
CHANGE MASTER TO MASTER_HOST='mysql', MASTER_PORT=3306, MASTER_USER='lph', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-binlog.000001', MASTER_LOG_POS=1009;# 配置生效
start slave;
# 查看从服务器状态
SHOW slave STATUS\G

结束！