两台服务器用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