两台服务器通过docker完成主从复制

1、前提

1.1、搭建两台服务器

1.2、关闭防火墙

查看防火墙状态

systemctl status firewalld

暂时关闭防火墙

systemctl stop firewalld

永久关闭防火墙

systemctl disable firewalld 

修改成静态ip、指定ip地址、设置ip可查

[root@localhost ~]# vi  /etc/sysconfig/network-scripts/ifcfg-ens33

1.3、下载docker

2、搭建主从集群

1、拉取镜像

docker pull mysql:latest

2、启动主库镜像

docker run \
        --restart=always \
        -p 3306:3306 --name mysql \
        -v /opt/mysql/log:/var/log/mysql \
        -v /opt/mysql/data:/var/lib/mysql \
        -v /opt/mysql/conf/my.cnf:/etc/mysql/my.cnf \
        -v /opt/mysql/conf.d:/etc/mysql/conf.d \
        -e MYSQL_ROOT_PASSWORD=123456 \
        -d mysql:latest --server-id=100 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --log-bin=mysql-bin --sync_binlog=1

3、主库操作

# docker 连接容器
docker exec -it mysql /bin/bash -c 'mysql -uroot -p123456'
# 修改mysql身份验证插件为mysql_native_password;
# 因为mysql 8.0+起;其默认的身份验证插件为caching_sha2_password;
# 如果不改会导致登录验证失败;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
# 创建从库数据同步用户slave;
CREATE USER slave IDENTIFIED WITH mysql_native_password BY '123456';
#  授权
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'slave'@'%' ;
# 生效
FLUSH PRIVILEGES;
# 查看主库状态
show master status;

4、记录主库状态信息

show master status

这两个结果很重要，从库要用

5.启动从库镜像

# 若主从在一台服务器;则需要修改镜像名称，mysql变更为mysql-slave1,mysql-slave2等
docker run \
        --restart=always \
        -p 3306:3306 --name mysql \
        -v /opt/mysql/log:/var/log/mysql \
        -v /opt/mysql/data:/var/lib/mysql \
        -v /opt/mysql/conf/my.cnf:/etc/mysql/my.cnf \
        -v /opt/mysql/conf.d:/etc/mysql/conf.d \
        -e MYSQL_ROOT_PASSWORD=123456 \
        -d mysql:latest --server-id=101 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

service-id是唯一标识，不能和主库一样，每个库都不一样

6.启动从库镜像

# docker 连接容器
docker exec -it mysql /bin/bash -c 'mysql -uroot -p123456'
# 如果主从在一台服务器,则需要通过[ docker inspect --format='{{.NetworkSettings.IPAddress}}' mysql] 查询主库容器IP
# 如果不在一台服务器,则直接使用外网ip即可 主库中两个结果添加进来
CHANGE MASTER TO MASTER_HOST='your master ip ',
MASTER_PORT=3306,
MASTER_USER='slave',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000004',
MASTER_LOG_POS=551;
# 开启主从复制
start slave;
# 查看从库状态
show slave status\G
# 当看到如下输出;Slave_IO_Running及Slave_SQL_Running为YES时;从库启动+主从复制成功;
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.146.138
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000004
          Read_Master_Log_Pos: 157
               Relay_Log_File: 10f6291c7b33-relay-bin.000002
                Relay_Log_Pos: 326
        Relay_Master_Log_File: mysql-bin.000004
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes