F0PU7Yza

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
12transaction_isolation=READ-COMMITTED
13binlog_checksum=NONE
14log_slave_updates=ON
15log_bin=binlog
16binlog_format=ROW
17transaction_write_set_extraction=XXHASH64
18loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
19loose-group_replication_start_on_boot=OFF
20loose-group_replication_local_address="127.0.0.1:24901"
21loose-group_replication_group_seeds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
22loose-group_replication_bootstrap_group=OFF
23loose-group_replication_single_primary_mode=ON
24disabled_storage_engines=MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY,MRG_MYISAM,CSV
25
26
27[to setup the group..]
28SET SQL_LOG_BIN=0;
29FLUSH PRIVILEGES;
30CREATE USER rpl_user@'%';
31GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
32FLUSH PRIVILEGES;
33SET SQL_LOG_BIN=1;
34CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
35
36INSTALL PLUGIN group_replication SONAME 'group_replication.dll';
37SHOW PLUGINS;
38
39SET GLOBAL group_replication_bootstrap_group=ON;
40START GROUP_REPLICATION;
41SET GLOBAL group_replication_bootstrap_group=OFF;
42SELECT * FROM performance_schema.replication_group_members;
43drop database if exists test;
44CREATE DATABASE if not exists test;
45use test;
46drop table if exists t1;
47CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 blob)ENGINE=InnoDB;
48insert into t1 values(1,'hollow');
49SHOW BINLOG EVENTS;