BhYPVm1z

1[mysqld]
2console
3datadir=e:/gr/n1/data
4basedir=e:/mysql-5.7.17-winx64
5tmpdir=e:/gr/n1
6port=3306
7server_id=1
8gtid_mode=ON
9enforce_gtid_consistency=ON
10master_info_repository=TABLE
11relay_log_info_repository=TABLE
12binlog_checksum=NONE
13log_slave_updates=ON
14log_bin=binlog
15binlog_format=ROW
16transaction_write_set_extraction=XXHASH64
17loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
18loose-group_replication_start_on_boot=OFF
19loose-group_replication_local_address="127.0.0.1:24901"
20loose-group_replication_group_seeds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
21loose-group_replication_bootstrap_group=OFF
22loose-group_replication_single_primary_mode=ON
23disabled_storage_engines=MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY,MRG_MYISAM,CSV
24
25
26[to setup the group..]
27SET SQL_LOG_BIN=0;
28FLUSH PRIVILEGES;
29CREATE USER rpl_user@'%';
30GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
31FLUSH PRIVILEGES;
32SET SQL_LOG_BIN=1;
33CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
34
35INSTALL PLUGIN group_replication SONAME 'group_replication.dll';
36SHOW PLUGINS;
37
38SET GLOBAL group_replication_bootstrap_group=ON;
39START GROUP_REPLICATION;
40SET GLOBAL group_replication_bootstrap_group=OFF;
41SELECT * FROM performance_schema.replication_group_members;
42drop database if exists test;
43CREATE DATABASE if not exists test;
44use test;
45drop table if exists t1;
46CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 blob)ENGINE=InnoDB;
47insert into t1 values(1,'hollow');
48SHOW BINLOG EVENTS;