Mac 通过docker 配置mysql的主从库实现数据同步

Mac 通过docker 配置mysql的主从库实现数据同步

1、安装docker
2、pull mysql
3、准备mysql的配置文件

my-master.cnf
[mysqld]
server-id=100
log-bin=mysql-bin

my-slave1
[mysqld]
server-id=101
log-bin=mysql-slave-bin
relay_log=mysql-relay-bin

my-slave2
[mysqld]
server-id=102  
log-bin=mysql-slave-bin   
relay_log=mysql-relay-bin 

4、启动master，创建slave用户并授权

docker run -d -e MYSQL_ROOT_PASSWORD=root \
 --name mysql-master \
  -v /Users/rubin/docker/mysql/my-master.cnf:/etc/mysql/my.cnf \
  -p 3307:3306 -v /Users/rubin/docker/mysql/mysql-files:/var/lib/mysql-files/ mysql:5.7

master 创建用户并授权

CREATE USER 'user_slave'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* to 'user_slave'@'%' identified by '123456';
commit;
show master status;

5、启动slave1&#