Mysql 组复制
GTID
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (master). This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication setup. There is a 1-to-1 mapping between all transactions and all GTIDs.
GTID同步流程
搭建GTID Replication
1. 主从服务器同步
2.停止各服务器
3. 配置GTID并启动服务器
4. 切换master,并start slave
5. 取消只读
配置Group Replication Server
配置my.cnf:
server_id=x
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=mysql-bin
binlog_format=ROW
配置Group Replication
配置my.cnf:
创建复制用户
安装Group Replication插件
启动Group Replication
添加组成员
同一组内的成员服务器 start group_replication之后,自动加入。
查找Primary服务器
SELECT VARIABLE_VALUE
FROM performance_schema.global_status
WHERE VARIABLE_NAME= ‘group_replication_primary_member’;
SELECT * FROM performance_schema.replication_group_members;