docker network create net-mysql

docker pull mysql

docker images

docker run -d -p 3310:3306 -v D:/ProgramData/docker_config/mysql/master/config:/etc/mysql/conf.d -v D:/ProgramData/docker_config/mysql/master/data:/var/lib/mysql  -e MYSQL_ROOT_PASSWORD=123456 --network net-mysql --name mysql-master mysql:latest

docker run -d -p 3311:3306 -v D:/ProgramData/docker_config/mysql/slave-1/config:/etc/mysql/conf.d -v D:/ProgramData/docker_config/mysql/slave-1/data:/var/lib/mysql  -e MYSQL_ROOT_PASSWORD=123456 --network net-mysql --name mysql-slave-1 mysql:latest

docker ps

[mysqld]
#主服務(wù)器唯一ID
server-id=1
#啟用二進(jìn)制日志
log-bin=mysql-bin
#設(shè)置不要復(fù)制的數(shù)據(jù)庫(kù)(可設(shè)置多個(gè))
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
#設(shè)置需要復(fù)制的數(shù)據(jù)庫(kù) 需要復(fù)制的主數(shù)據(jù)庫(kù)名字
binlog-do-db=db_test
#設(shè)置logbin格式
binlog_format=STATEMENT

[mysqld]
#從服務(wù)器唯一ID
server-id=2
#啟用中繼日志
relay-log=mysql-relay

docker exec -it mysql-master bash

cd /etc/mysql/conf.d

# 查看當(dāng)前目錄下的文件
ls

# 修改文件名
mv my.cnf.txt my.cnf

# 復(fù)制到/etc/mysql目錄下
cp my.cnf /etc/mysql/my.cnf

docker restart mysql-master mysql-slave-1

docker exec -it mysql-master bash

mysql -uroot -p

GRANT REPLICATION SLAVE ON *.* TO 'dev'@'%' IDENTIFIED BY '123456';

show master status;

docker exec -it mysql-slave-1 bash

mysql -uroot -p123456

CHANGE MASTER TO MASTER_HOST='172.19.0.2',
MASTER_USER='dev',
MASTER_PASSWORD='123456',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=1325;

docker network inspect net-mysql

start slave;

show slave status\G;

create database db_test;
use db_test;
CREATE TABLE user ( id int UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(20) NOT NULL, age int NOT NULL, PRIMARY KEY (id) );
insert into user(name, age) values('Jack', 20);

show databases;

use db_test;
show tables;

select * from user;