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