Docker部署MySQL8集群(一主二從)的實現(xiàn)步驟

yum install -y yum-utils

yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo

yum -y install docker-ce

docker -v
docker version

yum list installed | grep docker

docker pull mysql:8

docker images

# 創(chuàng)建主服務的配置目錄和數(shù)據(jù)目錄
mkdir -p /usr/local/mysqlData/master/cnf
mkdir -p /usr/local/mysqlData/master/data

# 創(chuàng)建1號從服務器的配置目錄和數(shù)據(jù)目錄
mkdir -p /usr/local/mysqlData/slave/cnf
mkdir -p /usr/local/mysqlData/slave/data

# 創(chuàng)建2號從服務器的配置目錄和數(shù)據(jù)目錄
mkdir -p /usr/local/mysqlData/slave2/cnf
mkdir -p /usr/local/mysqlData/slave2/data

vim /usr/local/mysqlData/master/cnf/mysql.cnf

[mysqld]
## 設置server_id,注意要唯一
server-id=1
## 開啟binlog
log-bin=mysql-bin
## binlog緩存
binlog_cache_size=1M
## binlog格式(mixed、statement、row,默認格式是statement)
binlog_format=mixed
##設置字符編碼為utf8mb4
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4

# 1號從服務器
vim /usr/local/mysqlData/slave/cnf/mysql.cnf
# 2號從服務器
vim /usr/local/mysqlData/slave2/cnf/mysql.cnf

[mysqld]
## 設置server_id,注意要唯一
server-id=2
## 開啟binlog
log-bin=mysql-slave-bin
## relay_log配置中繼日志
relay_log=edu-mysql-relay-bin
## 如果需要同步函數(shù)或者存儲過程
log_bin_trust_function_creators=true
## binlog緩存
binlog_cache_size=1M
## binlog格式(mixed、statement、row,默認格式是statement)
binlog_format=mixed
##設置字符編碼為utf8mb4
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
slave_skip_errors=1062
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4

# 主服務器實例化
docker run -itd -p 3307:3306 --name master -v /usr/local/mysqlData/master/cnf:/etc/mysql/conf.d -v /usr/local/mysqlData/master/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:8 

# 1號從服務器實例化
docker run -itd -p 3308:3306 --name slaver -v /usr/local/mysqlData/slave/cnf:/etc/mysql/conf.d -v /usr/local/mysqlData/slave/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:8 

# 2號從服務器實例化
docker run -itd -p 3309:3306 --name slaver2 -v /usr/local/mysqlData/slave2/cnf:/etc/mysql/conf.d -v /usr/local/mysqlData/slave2/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:8

docker ps -a

# 創(chuàng)建用戶 reader設置密碼為reader
CREATE USER reader IDENTIFIED BY 'reader';
# 給予reader同步權限
GRANT REPLICATION SLAVE ON *.* to 'reader'@'%';
FLUSH PRIVILEGES;

# MySQL的連接信息
SHOW MASTER STATUS;

#新開連接 獲取master實例的在docker的地址
docker inspect --format='{{.NetworkSettings.IPAddress}}' master

# 配置連接的參數(shù)
change master to master_host='172.17.0.2',master_user='reader',master_password='reader',master_log_file='mysql-bin.000003',master_log_pos=2259;
# 啟動同步
start slave;
# 查看是否成功
show slave status\G

# 兩項都為Yes時代表成功。
# Slave_IO_Running: Yes
# Slave_SQL_Running: Yes

# 失敗需要使用停止連接后檢查其他賬號密碼，地址，pos等參數(shù)

# 停止連接，如果一次成功無需使用該命令
stop slave;

SHOW SLAVE HOSTS;