基于MySQL 8.0安装部署MGR集群（单组模式）

一、环境介绍

虚拟机：Oracle VM VirtualBox 5.0.24
操作系统：CentOS Linux release 7.7.1908 (Core)
MySQL服务器：8.0.11 MySQL Community Server - GPL
软件下载地址
master_ip：192.168.56.101
slave1_ip:192.168.56.103
slave2_ip:192.168.56.105
master主机名：mysql-101
slave1主机名：mysql-103
slave2主机名：mysql-105
master配置文件：/etc/my.cnf

[client]
default-character-set=utf8
socket=/tmp/mysql.sock

[mysqld]
user = mysql 
port = 3306
basedir=/usr/local/mysql/mysql-8.0.11/
datadir=/data/mysql/
socket=/tmp/mysql.sock
#pid-file/tmp/mysqld.pid
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names = 1

server-id = 183306 
log-bin = mysql-bin
log-bin-index = binlogs.index
binlog_format = row
binlog_rows_query_log_events = on
binlog_checksum = none

slave-parallel-type = LOGICAL_CLOCK
slave-parallel-workers = 4
slave_preserve_commit_order = 1

#GITD
gtid_mode = on
enforce_gtid_consistency = 1
log-slave-updates = 1
binlog_gtid_simple_recovery = 1

relay_log = /data/mysql/relay.log
relay-log-index = /data/mysql/relay.index
master_info_repository = table
relay_log_info_repository = table

#MGR
#GR配置项 基中loose前缀表示若group Replication plugin未加载 mysql server仍明治维新启动
plugin_load="group_replication=group_replication.so"
transaction_write_set_extraction = XXHASH64 #对每个事务获取write set，并且用XXHASH64算法获取hash值
loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" #组名，此处可拿select.uuid()生成
loose-group_replication_start_on_boot = off #在mysqld启动时不自动启动组复制
loose-group_replication_local_address = "192.168.56.101:33006" #本节点的IP地址和端口，注意该端口是组内成员之间通信的端口，而不是MySQL对外提供服务的端口
#种子节点的IP和端口号，新成员加入到集群的时候需要联系种子节点，启动集群的节点不使用下面该选项
#loose-group_replication_group_seeds = "192.168.56.101:33006,192.168.56.103:33006,192.168.56.105:33006" 
loose-group_replication_bootstrap_group = off #关闭，如果打开会造成脑裂 #是否启动集群，注意，该选项任何时候只能用于一个节点，通常情况下启动集群的时候使用，启动之后需要关闭该选项
loose-group_replication_member_weight = 50 #权重选择

skip-host-cache
skip-name-resolve
skip-external-locking
character-set-server=utf8
lower_case_table_names=1
event_scheduler=on
log_bin_trust_function_creators=on
#max_connections = 3000  
external-locking = FALSE  
#max_allowed_packet = 32M  
#sort_buffer_size = 8M  
#join_buffer_size = 2M   
thread_cache_size = 300 
#query_cache_size = 64M 
#query_cache_limit