MySQL Group Replication (MGR) 安装
发布时间:2020-03-25 00:41:38
来源:51CTO
阅读:5592
作者:hui90877
MySQL Group Replication 安装
192.168.10.65
192.168.10.66
192.168.10.67
OS : CentOS 7.4
mysql soft : 8.0.12
一、安装MySQL,并创建实例
此处参考 mysql8.0.12源码安装
二、mgr几个指定参数,添加到配置文件中,重启生效
-- 配置文件
binlog_format = ROW
gtid_mode = ON
enforce_gtid_consistency = ON
log_slave_updates = ON
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_checksum = NONE
transaction_write_set_extraction =XXHASH64 ###开启主键信息采集功能,8.0.2开始默认值为XXHASH64
loose-group_replication_group_name ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" ###设置组名,随便起,但是不能与UUID重复
loose-group_replicat