Docker deployment MySQL8 cluster (one master and two slaves) implementation steps

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 

# Create the configuration directory and data directory of the master service mkdir -p /usr/local/mysqlData/master/cnf
mkdir -p /usr/local/mysqlData/master/data

# Create the configuration directory and data directory of slave server 1 mkdir -p /usr/local/mysqlData/slave/cnf
mkdir -p /usr/local/mysqlData/slave/data

# Create the configuration directory and data directory of slave server 2 mkdir -p /usr/local/mysqlData/slave2/cnf
mkdir -p /usr/local/mysqlData/slave2/data

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

[mysqld]
## Set server_id, note that it must be unique server-id=1
## Enable binlog
log-bin=mysql-bin
## binlog cache binlog_cache_size=1M
## binlog format (mixed, statement, row, the default format is statement)
binlog_format=mixed
##Set character encoding to 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

# No. 1 slave server vim /usr/local/mysqlData/slave/cnf/mysql.cnf
# No. 2 slave server vim /usr/local/mysqlData/slave2/cnf/mysql.cnf

[mysqld]
## Set server_id, note that it must be unique server-id=2
## Enable binlog
log-bin=mysql-slave-bin
## relay_log configuration relay log relay_log=edu-mysql-relay-bin
## If you need to synchronize functions or stored procedures log_bin_trust_function_creators=true
## binlog cache binlog_cache_size=1M
## binlog format (mixed, statement, row, the default format is statement)
binlog_format=mixed
##Set character encoding to 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

# Master server instantiation 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 

# Instantiate slave server 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 

# Instantiate slave server 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 

# Create user reader and set password to reader
CREATE USER reader IDENTIFIED BY 'reader';
# Grant reader synchronization permissions GRANT REPLICATION SLAVE ON *.* to 'reader'@'%';
FLUSH PRIVILEGES;

#MySQL connection information SHOW MASTER STATUS;

#Open a new connection to get the address of the master instance in docker inspect --format='{{.NetworkSettings.IPAddress}}' master

# Configure the connection parameters 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 synchronization start slave;
# Check if it is successful show slave status\G

# If both are Yes, it means success.
# Slave_IO_Running: Yes
# Slave_SQL_Running: Yes

# If it fails, you need to stop the connection and check other account passwords, addresses, POS and other parameters # Stop the connection. If it succeeds once, you don't need to use the stop slave command;

SHOW SLAVE HOSTS;