1. 三台机器都需要做

1.1 配置文件重写，自行补全后面两台

hostnamectl set-hostname master
vim /etc/hosts
192.168.71.142 master
192.168.71.145 slave1
192.168.71.146 slave2
# 配置mysql源
cat > /etc/yum.repos.d/mysql-community.repo <<-EOF
[mysql57-community]
name=MySQL 5.7 Community Server 
baseurl=https://mirrors.cloud.tencent.com/mysql/yum/mysql-5.7-community-el7-x86_64/
enabled=1
gpgcheck=0
EOF
# 生成源缓存
yum makecache fast
yum install -y deltarpm 
# 部署mysql
yum install mysql-community-server -y

# 启动mysql
systemctl enable --now mysqld.service

# 初始化mysql密码
grep "temporary password is generated" /var/log/mysqld.log|awk '{print $11}'

# 使用mysql客户端与mysql交互
mysql -uroot -p` grep "temporary password is generated" /var/log/mysqld.log|awk '{print $11}'`

# 修改初始化密码，否则无法使用，而且修改的密码必须符合密码复杂度要求，弱口令不被允许，以下为mysql命令
mysql> set password=password('Pyuchen123!');
mysql> flush privileges;

# 退出重新登录，测试登录是否成功
mysql -uroot -p'Pyuchen123!'

vim /etc/my.cnf
symbolic-links=0

Log-errorr=/var/log/mysqld.Log
pid-file=/var/run/mysqld/mysqld.pid

max_connections = 1500
innodb_buffer_ pool_size = 4G
innodb_io_capacity = 500
innodb_io_capacity_max = 3000
innodb_log_file_size = 2G
binlog_format = row 

innodb_flush_log_at_trx_commit = 1
sync_binlog = 1

server_id=142
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW
innodb_buffer_pool_size=3G
transaction_write_set_extraction=XXHASH64
plugin_load_add='group_replication.so'
loose-group_replication_ip_whitelist='192.168.71.0/24'
loose-group_replication_group_name="8d3cebd8-b132-11eb-8529-0242ac130003"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address="192.168.71.142:3309"
loose-group_replication_group_seeds="192.168.71.142:3309,192.168.71.145:3309,192.168.71.146:3309"
loose-group_replication_bootstrap_group=off
loose-group_replication_single_primary_mode=true
loose-group_replication_enforce_update_everywhere_checks=false

1.2 组复制用户的创建与配置

SET SQL_LOG_BIN=0;
grant replication slave on *.* to 'rpl'@'192.168.71.%' identified by 'Pyuchen123!';
flush privileges;
set SQL_LOG_BIN=1;

1.3 创建同步规则认证信息

change master to master_user='rpl',master_password='Pyuchen123!' for channel 'group_replication_recovery';

2. 主节点需要做的

set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;

3. 其他节点需要后续做

start group_replication;

4. 验证组复制配置成功

Group_replication监控项是放在performance_schema这个库下面的几个表中：

select * from performance_schema.replication_group_members;