MySQL8.0.18 configuration of multiple masters and one slave

[mysqld]
# Server identifier, make sure each server identifier is different server-id = 1000

# The master machine must have log_bin enabled
# mysql-bin is a custom name, and files such as mysql-bin.index, mysql-bin.000001, etc. will be generated log_bin=mysql-bin

# Binary log expiration time (unit: day), the default value is 0, that is, it does not expire expire_logs_days = 0

# Error log log-error=/var/lib/mysql/mysql-error.log

# The maximum value of a single log_bin file. When the maximum value is reached, the suffix of the newly created file will be automatically increased, such as mysql-bin.000002
max_binlog_size = 100M

#mysql installation path basedir=/var/lib/mysql

#mysql data path datadir=/var/lib/mysql

# The database where the master records the operation is binlog_do_db=replication

# Database ignored by master binlog_ignore_db=information_schema
binlog_ignore_db=performance_schema
binlog_ignore_db=sys
binlog_ignore_db=mysql

# Binary log storage mode binlog_format=MIXED

# Maximum storage value of blob type (unit: bytes, B)
# 1048576 B = 1MB
max_allowed_packet=1048576


# Password complexity configuration, requires plugin # Password length must be at least 0
# validate_password_length=8

# Minimum number of uppercase and lowercase characters # validate_password_mixed_case_count=1

# The minimum number of numbers in the password# validate_password_number_count=1

# The minimum number of special characters in the password # validate_password_special_char_count=1

innodb_flush_log_at_trx_commit=0

[mysql]
default-character-set=utf8mb4

[client]
default-character-set=utf8mb4

create user 'replication'@'%' identified with mysql_native_password by 'JINGhuaSHUIyue123,.';

drop user 'replication'@'%';

alter user 'replication'@'%' identified with mysql_native_password by 'JINGhuaSHUIyue123,.';

grant replication slave on *.* to 'replication'@'%';

flush privileges;

[mysqld]
# Server identifier, make sure each server identifier is different server-id = 2000

#mysql installation path basedir=D:\mysql

#mysql data path datadir=D:\mysql\data

# slave replicated database replicate_do_db=test

# The database ignored by the slave replicate_ignore_db=information_schema
replicate_ignore_db=performance_schema
replicate_ignore_db=mysql
replicate_ignore_db=sys

# Slave network timeout reconnection interval (unit: seconds)
slave_net_timeout=60

[mysql]

default-character-set=utf8

[client]

default-character-set=utf8

show master status;

+------------------+----------+--------------+-------------------------------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+-------------------------------------------------+-------------------+
| mysql-bin.000006 | 155 | test | information_schema,performance_schema,sys,mysql | |
+------------------+----------+--------------+-------------------------------------------------+-------------------+

show master status;

+------------------+----------+--------------+-------------------------------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+-------------------------------------------------+-------------------+
| mysql-bin.000005 | 155 | test | information_schema,performance_schema,sys,mysql | |
+------------------+----------+--------------+-------------------------------------------------+-------------------+

show slave status\G;

stop slave;

reset slave all;

change master to
master_host = '112.124.1.100',
master_user = 'replication',
master_port = 3306,
master_password = 'replication',
master_log_file = 'mysql-bin.000006',
master_log_pos = 155,
master_connect_retry = 15,
master_retry_count = 0
for channel 'master1';

change master to
master_host = '192.168.1.139',
master_user = 'replication',
master_port = 3306,
master_password = 'JINGhuaSHUIyue123,.',
master_log_file = 'mysql-bin.000005',
master_log_pos = 155,
master_connect_retry = 15,
master_retry_count = 0
for channel 'master2';

start slave for channel 'master1';
start slave for channel 'master2';

show slave status\G;