How to run MySQL in Docker environment and enable Binlog to configure master-slave synchronization

#Pull the image docker pull mysql:5.7
#yRun the master and slave containersdocker run -p 13306:3306 --name slavemysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
docker run -p 13307:3306 --name mastermysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

#View the IP address of the main database
docker inspect --format='{{.NetworkSettings.IPAddress}}' masterMySQL
#172.18.0.2

docker exec -it masterMysql bash #masterMysql is the name of the running container.

cd /etc/mysql&&ls

vim ./my.cnf

But here you will get an error:
bash: vi: command not found

apt-get update
#After success, run apt-get install vim

Copy the host into the container.
Syntax: docker cp [host address] [container ID or container name]:[container file address]
docker cp /home/mysql/my.cnf mysql:/etc/mysql/my.cnf

character_set_server=utf8
init_connect='SET NAMES utf8'
#These two are to set the UTF-8 character format, the two hosts have the same configuration## Pay attention to be unique within the same LAN (if there is a two-way master and slave database, rely on this to distinguish the SQL statements that execute Binlog)
#You can take the last IP. The master database is 2 and the slave database is 3.
server-id=2  
## Enable binary log function, you can take any log (key)
#Demonstration setting: The master library is set to master-bin and the slave library is set to slave-bin
log-bin=master-bin
log_bin_index = master-bin.index

#Here are the configurable contents. Due to testing, they are commented out first.
#The library to be synchronized with the slave (if not written, all will be synchronized by default)
#binlog-do-db=test

#Do not synchronize the library with the slave (write multiple lines for multiple)
#binlog-ignore-db=mysql #Set the replicated database #binlog-ignore-db=information_schema #Set to ignore the replicated database #Automatically clean up log files from 15 days ago expire_logs_days=15
#binlog_format=row #Set the SQL for the actual operation recorded in Binlog.
#max_binlog_size=100m #Set the file size#replicate_do_table=test #Data table to be replicated#replicate_ignore_table=igoreTest #Ignore the data table to be replicated#replicate_wild_ignore_db=test #Same as Replicate_Do_DB, can have wildcards#replicate_wild_ignore_db=igoreTest #Same as Replicate_Ignore_DB, can have wildcards

#Set to avoid master-slave replication errors caused by untimely updates or restarts.
read_only = 1
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay-log = slave-relay-bin

#Log storage of the main library.
relay-log-index = slave-relay-bin.index

docker restart masterMysql
docker restart slaveMysql

docker logs masterMySQL

#Enter the container docker exec -it masterMysql bash
#Enter MySQL
mysql -uroot -p123456 
#Check the Binlog status.
show variables like '%log_bin%';
#You can see that log_bin is turned on and bin_log is located in /var/lib/mysql/master-bin

![file](https://p3-juejin.byteimg.com/tos-cn-i-k3u1fbpfcp/61e52585e4aa4200a8c27204ef690234~tplv-k3u1fbpfcp-zoom-1.image)

show master status;

#Generate new Binlog log file flush logs; 
#Reset and clear Binlog log file reset master;

CREATE USER 'slaveMysql'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slaveMysql'@'%';

change master to master_host='172.18.0.2',
 master_user='slaveMysql',
 master_password='123456',
 master_port=3306, 
 master_log_file='mysql-bin.000001',
 master_log_pos= 334,
 master_connect_retry=30;

change master to master_host=${IP used by the container} This needs to be in the same LAN, obtained in step 2.
master_port The port number of the Master refers to the port number of the container's running database, not the port number mapped to the host, obtained in the first step.
master_user sets the account used for synchronization. master_password in the 4th column sets the account password used for synchronization. master_log_file in the 4th column specifies which configuration file of the master database to read the Binlog log from. master_log_pos in the 3rd (6th column) specifies the position from which to start reading, that is, the value of the Position field mentioned above. master_connect_retry in the 3rd (6th column) specifies the retry interval in seconds if the connection fails. The default value is 60 seconds.

start slave;
#Stop slave.
#stop slave;

show slave status ;