mysql mgr group replication

1. /etc/my.cnf

[client]
socket=/usr/local/mydb/mysql.sock
user=root
password=tiger
#skip-binary-as-hex

[mysqld]
datadir=/usr/local/mydb
basedir=/usr/local/mysql
log-error=log.err

port=3306
socket=mysql.sock
key_buffer_size=16M
max_allowed_packet=128M
transaction-isolation = READ-COMMITTED
transaction-read-only = OFF
server_id=1
gtid_mode=on
enforce_gtid_consistency=on
binlog_checksum=NONE
log_bin=binlog
log_slave_updates=ON
binlog_format=ROW
master_info_repository=TABLE
relay_log_info_repository=TABLE
transaction_write_set_extraction=XXHASH64
plugin_load_add='group_replication.so'
loose-group_replication_group_name="111dd191-53df-11ec-a368-8cec4ba3dd80"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "mgr1:3901"
loose-group_replication_group_seeds= "mgr1:3901,mgr3:3901"
loose-group_replication_bootstrap_group=off
loose-group_replication_recovery_get_public_key=on

loose-group_replication_ip_allowlist='192.168.0.0/16'

 

 

 

2. vim /etc/sysconfig/network      vim /etc/hosts

 

3.create grant

 

 

 

4.change master to master_user,master_password for channel 'group_replication_recovery'

start group_replication;