Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- console
- datadir=e:/gr/n1/data
- basedir=e:/mysql-5.7.17-winx64
- tmpdir=e:/gr/n1
- port=3306
- server_id=1
- gtid_mode=ON
- enforce_gtid_consistency=ON
- master_info_repository=TABLE
- relay_log_info_repository=TABLE
- transaction_isolation=READ-COMMITTED
- binlog_checksum=NONE
- log_slave_updates=ON
- log_bin=binlog
- binlog_format=ROW
- transaction_write_set_extraction=XXHASH64
- loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
- loose-group_replication_start_on_boot=OFF
- loose-group_replication_local_address="127.0.0.1:24901"
- loose-group_replication_group_seeds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
- loose-group_replication_bootstrap_group=OFF
- loose-group_replication_single_primary_mode=ON
- disabled_storage_engines=MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY,MRG_MYISAM,CSV
- [to setup the group..]
- SET SQL_LOG_BIN=0;
- FLUSH PRIVILEGES;
- CREATE USER rpl_user@'%';
- GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
- FLUSH PRIVILEGES;
- SET SQL_LOG_BIN=1;
- CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
- INSTALL PLUGIN group_replication SONAME 'group_replication.dll';
- SHOW PLUGINS;
- SET GLOBAL group_replication_bootstrap_group=ON;
- START GROUP_REPLICATION;
- SET GLOBAL group_replication_bootstrap_group=OFF;
- SELECT * FROM performance_schema.replication_group_members;
- drop database if exists test;
- CREATE DATABASE if not exists test;
- use test;
- drop table if exists t1;
- CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 blob)ENGINE=InnoDB;
- insert into t1 values(1,'hollow');
- SHOW BINLOG EVENTS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement