[mysqld]
# 通用配置
server_id = [唯一ID]
gtid_mode = ON
enforce_gtid_consistency = ON
binlog_format = ROW

# Group Replication配置
plugin_load_add = 'group_replication.so'
transaction_write_set_extraction = XXHASH64
group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" # 唯一UUID
group_replication_start_on_boot = OFF
group_replication_local_address = "節(jié)點IP:33061"
group_replication_group_seeds = "節(jié)點1IP:33061,節(jié)點2IP:33061,節(jié)點3IP:33061"
group_replication_bootstrap_group = OFF
group_replication_consistency = BEFORE_AND_AFTER  # 完全同步關(guān)鍵參數(shù)

-- 在第一個節(jié)點執(zhí)行
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;

-- 在其他節(jié)點執(zhí)行
START GROUP_REPLICATION;

[mysqld]
wsrep_on = ON
wsrep_provider = /usr/lib/galera/libgalera_smm.so
wsrep_cluster_name = "my_cluster"
wsrep_cluster_address = "gcomm://node1_ip,node2_ip,node3_ip"
wsrep_node_name = "node1"
wsrep_node_address = "當(dāng)前節(jié)點IP"
wsrep_sst_method = rsync
binlog_format = ROW
default_storage_engine = InnoDB

# 第一個節(jié)點
systemctl start mysql --wsrep-new-cluster

# 其他節(jié)點
systemctl start mysql

[mysqld]
# 主庫配置
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_master_wait_for_slave_count = [從庫數(shù)量]
rpl_semi_sync_master_wait_point = AFTER_SYNC
rpl_semi_sync_master_timeout = 18446744073709551615  # 最大可能值，幾乎不超時

# 從庫配置
rpl_semi_sync_slave_enabled = 1

SET GLOBAL group_replication_consistency = BEFORE;

SELECT * FROM performance_schema.replication_group_members;
SELECT * FROM performance_schema.replication_group_member_stats;