docker版MySQL主从复制配置

• 事先准备好MySQL
• 主库挂载配置文件（log-bin参数为数字）

image.png

/mnt/mysql/master/conf:/etc/mysql/conf.d/
/mnt/mysql/master/data:/var/lib/mysql/

[mysqld]
lower_case_table_names=1
log-bin=mysql-bin
server-id=123
binlog_format=mixed

• 从库挂载配置文件

image.png

/mnt/mysql/salve/conf:/etc/mysql/conf.d/
/mnt/mysql/salve/data:/var/lib/mysql/

[mysqld]
lower_case_table_names=1
log-bin=mysql-bin
server-id=1
binlog_format=mixed

• 主库执行命令

GRANT REPLICATION SLAVE ON *.* to 'root'@'%' identified by 'mysqlmaster';

• 查询主库bin-log位置

show master status;

• 从库开启复制

change master to master_host='mysql-master',master_user='root',master_password='mysqlmaster',master_log_file='mysql-bin.000001',master_log_pos=154;(master_log_pos为主库binlog位置)
start slave;启动复制

• 主库随便操作一下，检查从库

image.png

• 完成