docker mysql 主从

1.首先拉取做好的主从

docker pull xiaochunping/mysql-master;
docker pull xiaochunping/mysql-slave;

2.创建两个文件夹

mkdir -p /home/mysql/master-data
mkdir -p /home/mysql/slave-data

3.运行master

docker run \
--name mysql-master \
--privileged=true \
-v /home/mysql/etc/master:/etc/mysql/conf.d \
-v /home/mysql/master-data:/var/lib/mysql \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=root \
-d xiaochunping/mysql-master

4.运行slave 

docker run \
--name mysql-slave \
--privileged=true \
-v /home/mysql/etc/slave:/etc/mysql/conf.d \
-v /home/mysql/slave-data:/var/lib/mysql \
-p 3307:3306 --link mysql-master:master \
-e MYSQL_ROOT_PASSWORD=root \
-d xiaochunping/mysql-slave

 

5.进去容器  mysql 这个例子用的root  可以用其它用户 不要对数据库做任何操作以免master_log_pos变化

docker exec -it mysql-master /bin/bash
mysql -uroot -proot

flush privileges;
// 查看主的状态
show master status;

6.进入从数据库

docker exec -it mysql-slave /bin/bash
mysql -uroot -proot

7.和主库关联

change master to master_host='master', master_user='root', master_password='root', \
master_port=3306, master_log_file='mysql-bin.000003', master_log_pos=589, master_connect_retry=30;

start slave;
// 查看从的状态
show slave status\G