链接：https://pan.baidu.com/s/1BBkMia0ZWrvs1N2zL1Kn5Q 

提取码：pcq9

1.体系

dble+mysql+keeplived

2.机器与软件描述

mysql01(172.28.8.65)

mysql02(172.28.8.61)

dble01(172.28.8.62)

dble02(172.28.8.63)

keeplived01(172.28.8.62)

keeplived02(172.28.8.63)

3.架构图

二、主主同步

1.拉取镜像

2.主从机创建文件docker.cnf

创建文件夹（两个容器不要共用文件夹） 在conf下创建docker.cnf

添加

3.关闭防火墙

docker pull mysql:5.7 mkdir /usr/local/mysql cd mysql/ mkdir conf data vim /usr/local/mysql/conf/docker.cnf [mysqld] server-id=1 log-bin=master-bin #只是读写,就只要主库配置即可.如果要做主从切换，那么主库和从库都需要开 启. skip-host-cache skip-name-resolve collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 [mysqld] server-id=2 log-bin=master-bin skip-host-cache skip-name-resolve collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 systemctl disable firewalld

4.启动Mysql主机和从机

5.开启主从复制

mysql主机

进入mysql容器

启动mysql

创建slave用户

授权

刷新权限

查看状态

docker run --name mysqlmastertwo -p 3306:3306 -p 33060:33060 -v /usr/local/mysql/conf:/etc/mysql/conf.d -v /usr/local/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root --privileged=true -d mysql:5.7 docker run --name mysqlslave -p 3307:3306 -p 33070:33060 -v /usr/local/mysql2/conf:/etc/mysql/conf.d -v /usr/local/mysql2/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -- privileged=true -d mysql:5.7 docker run --name mysqlpart1 -p 3308:3306 -p 33080:33060 -v /data/db_group/part_data/conf:/etc/mysql/conf.d -v /data/db_group/part_data/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -- privileged=true -d mysql:5.7 docker run --name mysqlpart1 -p 3309:3306 -p 33090:33060 -v /data/db_group/part2_data/conf:/etc/mysql/conf.d -v /data/db_group/part2_data/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -- privileged=true -d mysql:5.7 docker exec -it mysqlmaster /bin/bash mysql -uroot -proot create user 'hzero'@'%' identified by 'hzero'; grant replication slave on *.* to 'hzero'@'%'; flush privileges; show master status;