Mysql Group Replication

主要安装方法在https://dev.mysql.com/doc/refman/5.7/en/group-replication-getting-started.html

参考网址:https://www.percona.com/blog/2015/10/29/mysql-5-7-first-impressions-group-replication/

安装时候的重要说明：

在START GROUP_REPLICATION;前把里面关于MGR的配置关了先(如下面的server_id=1153到otstrap_group= off之间)，这之后要把这些选项打开

演示配置如下:

Notice:其它节点只要改server_id和loose-group_replication_local_address

[mysqld]
datadir=/home/mysql/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/home/mysql/log/error.log
log_bin=/home/mysql/log/binlog

server_id=1153
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
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= "192.168.1.153:33061" #本机地址
loose-group_replication_group_seeds= "192.168.1.155:33061,192.168.1.152:33061,192.168.1.153:33061" #子地址
loose-group_replication_single_primary_mode=FALSE #不用single_primary_mode
loose-group_replication_bootstrap_group= off #开机不添加到集群

碰到的异常有:

Plugin group_replication reported: 'This member has more executed transactions than those present in the group

    解决办法如下:set global group_replication_allow_local_disjoint_gtids_join=ON;再start group_replication;

Plugin group_replication reported: 'The group name 'group-replication-test' is not a valid UUID'

    解决办法如下:loose-group_replication_group_name参数没有按照UUID格式指定，被认为设置该参数无效 格式如下:2faa74b8-66bb-11e7-ab7e-b8ca3a6a61ec