mysql 主从复制

docker run --name mysql-master -v /home/hadoop/wusu/docker/local_caceh/mysql/master/conf:/etc/mysql/conf.d -v /home/hadoop/wusu/docker/local_caceh/mysql/master/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=wusu1314 -d -p 3036:3306 mysql:5.7

docker run --name mysql-slave -v /home/hadoop/wusu/docker/local_caceh/config/slave.cnf:/etc/mysql/conf.d/slave.cnf -v -/home/hadoop/wusu/docker/local_caceh/mysql2:/var/lib/mysql  -e MYSQL_ROOT_PASSWORD=wusu1314 -d -p 3037:3306 mysql:5.7

docker 运行二个不同端口的数据库

CREATE USER 'wusu_slave'@'%';
ALTER USER 'wusu_slave'@'%' IDENTIFIED WITH mysql_native_password BY 'wusu1314';
GRANT REPLICATION SLAVE ON *.* TO 'wusu_slave'@'%';

创建主从复制用户

FLUSH PRIVILEGES;

SHOW MASTER STATUS;  查看主数据库状态
mysql-bin.000003   946


从机 
CHANGE MASTER TO MASTER_HOST='192.168.1.103', 
MASTER_USER='wusu_slave',MASTER_PASSWORD='wusu1314', MASTER_PORT=3036,
MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=946; 

START SLAVE;  启动复制