docker run -p 3308:3306 --name mysql_slave2 --link mysql --net project_microservice -e MYSQL_ROOT_PASSWORD=1234 -d mysql:5.7.30
master主库:
[mysqld]
log-bin=mysql-bin
server-id=1
创建可访问主库的账户、密码:
CREATE USER 'slave'@'%' IDENTIFIED BY '123';
授权:
GRANT PEPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'slave'@'%';
使权限生效:
flush privileges;
slave从库:
[mysqld]
server-id=2
log-bin=mysql-slave-bin
relay_log=edu-mysql-relay-bin
从库配置连接主库:
change master to master_host='mysql',
master_user='slave',
master_password='123456',
master_log_file='mysql-bin.000004',
master_log_pos=154,
master_port=3306;