关于mysql组复制从5.7.17就有了。本文主要是记录一下操作步骤,以及相应的坑点。
mysql 单主模式的组复制配置
三台机器 10.50.31.7,10.50.31.8,10.50.31.18
31.7上配置
my.cnf配置
server_id=1
log-bin=mysql-bin
log-bin-index=mysql-bin.index
relay-log=relay-log
#expire-logs-days=7
binlog_expire_logs_seconds=159200
port=3306
report-host='10.50.31.7'
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
loose-group_replication_group_name='12345678-1234-1234-1234-1234567890ab'
loose-group_replication_start_on_boot=off
loose-group_replication_bootstrap_group=off
loose-group_replication_local_address='10.50.31.7:24901'
#slave-parallel-type='LOGICAL_CLOCK'
#slave-parallel-