MySQL5.7.17 Group Replication初始详细说明

[摘要]+----------------------------+----------+--------------------+----------------------+---------+45 r...

+----------------------------+----------+--------------------+----------------------+---------+ 45 rows in set (0.00 sec)

配置参数，db1（master）上：

mysql> set @@global.transaction_write_set_extraction =  XXHASH64
mysql> set @@global.group_replication_start_on_boot = OFF
mysql> set @@global.group_replication_bootstrap_group = OFF
mysql> set @@global.group_replication_group_name = 0c6d3e5f-90e2-11e6-802e-842b2b5909d6
mysql> set @@global.group_replication_local_address = 'db1:6606'
mysql> set @@global.group_replication_group_seeds = 'db2:6607,db3:6608'

配置参数，db2（slave1）上：

mysql> set @@global.transaction_write_set_extraction =  XXHASH64
mysql> set @@global.group_replication_start_on_boot = OFF
mysql> set @@global.group_replication_bootstrap_group = OFF
mysql> set @@global.group_replication_group_name = 0c6d3e5f-90e2-11e6-802e-842b2b5909d6
mysql> set @@global.group_replication_local_address = 'db2:6607'
mysql> set @@global.group_replication_group_seeds = 'db111:6606,127.0.0.1:db3'

配置参数，db3（slave2）上：

mysql> set @@global.transaction_write_set_extraction =  XXHASH64
mysql> set @@global.group_replication_start_on_boot = OFF
mysql> set @@global.group_replication_bootstrap_group = OFF
mysql> set @@global.group_replication_group_name = 0c6d3e5f-90e2-11e6-802e-842b2b5909d6
mysql> set @@global.group_replication_local_address = 'db3:6608'
mysql> set @@global.group_replication_group_seeds = 'db1:6607,db2:6606'

BTY：如果之前没有配置transaction_write_set_extraction=XXHASH64，这里修改之后之前创建的数据库是没有办法执行插入操作的。所有如果想在线完成Group Replication的改造需要保证之前已经设置了transaction_write_set_extraction=XXHASH64。

开始构建集群，在db1（master）上执行：

# 构建集群

CHANGE MASTER TO MASTER_USER='repl', MASTER_PASSWORD='rlpbright_1927@ys'FORCHANNEL'group_replication_recovery';

#开启group_replication

SETGLOBAL  group_replication_bootstrap_group=ON;
START  GROUP_REPLICATION;
SETGLOBAL  group_replication_bootstrap_group=OFF;

db2、db3上加入

stop slave;
START GROUP_REPLICATION;

在db1上查看集群信息：

mysql>  SELECT * FROM performance_schema.replication_group_members;

以上就是MySQL5.7.17 Group Replication初始详解的详细内容，更多请关注php中文网其它相关文章！

学习教程快速掌握从入门到精通的SQL知识。

关键词：MySQL5.7.17 Group Replication初始详细说明