Detailed explanation of the implementation process of dual-master synchronization of partial tables in MySQL 5.7

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-server
# Install MySQL 5.7
systemctl start mysqld
# Start MySQL

[mysqld]
vim /etc/my.cnf
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip_name_resolve=ON
#Set simple password validate_password_policy=0
validate_password_length=1
###Main configuration log_bin=bin_log
server-id=1
binlog-do-db=ziyun
# Which library is allowed to be replicated from slave_parallel_type='logical_clock'
#Set the replication type to LOGICAL_CLOCK
slave_parallel_workers=4
#Set the number of parallel operations to 4
###From the configuration relay-log=relay-bin
relay-log-index=relay-bin.index
replicate-do-db=ziyun
# Allow replication of the main service library replicate-do-table=ziyun.test1
# Which table of the main service library is allowed to be replicated replicate-do-table=ziyun.test2

mysql> CREATE USER 'slave'@'192.168.1.100' IDENTIFIED BY '123.com'; 
mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'192.168.1.100';
# Authorized replication user and passwordmysql> show master status;
+-----------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-----------------+----------+--------------+------------------+-------------------+
| bin_log.000002 | 8384 | ziyun | | |
+-----------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

mysql> CHANGE MASTER TO
 -> MASTER_HOST='192.168.1.101',
 -> MASTER_USER='slave',
 -> MASTER_LOG_FILE='bin_log.000002',
 -> MASTER_LOG_POS=8384;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> start slave;
Query OK, 0 rows affected (0.01 sec)
mysql> show slave status\G
  Slave_IO_Running: Yes
  Slave_SQL_Running: Yes
# Make sure all the above are yes and there are no errors.