一、部署MySQL8.0
二、编辑my.cnf
主库配置文件:
server_id=218
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name=“03f43914-7f38-4a00-919f-f748794c04ac“
loose-group_replication_start_on_boot=off
loose-group_replication_local_address=“10.30.1.218:33061“
loose-group_replication_group_seeds=“10.30.1.218:33061,10.30.1.219:33061,10.30.1.220:33061“
loose-group_replication_bootstrap_group=off
loose-group_replication_single_primary_mode=on
loose-group_replication_enforce_update_everywhere_checks= off
从库的loose-group_replication_local_address改成对应的即可
三、MGR启动
安装mgr插件:INSTALL PLUGIN group_replication SONAME ‘group_replication.so’;
查看插件:show plugins;
创建复制用户
三个节点都执行
mysql> create user mgr@'%' identified by 'mgr';
Query OK, 0 rows affected (0.36 sec)
mysql> grant replication slave on *.* to mgr@'%';
Query OK, 0 rows affected (0.18 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
配置复制通道
mysql> change master to master_user='mgr',master_password='mgr' for channel 'group_replication_recovery';
Query OK, 0 rows affected, 5 warnings (0.01 sec)
启动组复制
在主节点上执行(192.168.101.11)
mysql> SET GLOBAL group_replication_bootstrap_group=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (3.66 sec)
mysql> SET GLOBAL group_replication_bootstrap_group=OFF;
Query OK, 0 rows affected (0.00 sec)
在其他节点上执行(192.168.101.12,192.168.101.13)
mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (5.88 sec)
查看mgr状态
mysql> SELECT * FROM performance_schema.replication_group_members;