MGR搭建

单主模式MGR搭建

欢迎来到IT那活儿，本篇文章教你如何在Linux环境下进行单主模式MGR搭建。我们需要配置参数项，每个节点都需要填写，确保配置生效后重启Mysql节点。以下为配置列表：

MGR搭建

server_id=1001
gtid_mode=ON
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW
binlog_checksum=NONE
transaction_write_set_extraction=XXHASH64
loose-group_replication_group_name=”aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa”
loose-group_replication_start_on_boot=off
loose-group_replication_local_address=”192.168.77.11:13306″
loose-group_replication_group_seeds=”192.168.77.11:13306,192.168.77.12:13306,192.168.77.13:13306″
loose-group_replication_ip_whitelist=192.168.77.11,192.168.77.12,192.168.77.13
loose-group_replication_bootstrap_group=off

每个节点的server_id和loose-group_replication_local_address的值不能重复。同时，loose-group_replication_group_seeds的值即为MGR节点的IP地址列表。

启动MGR所有节点，执行以下命令：

若之前的配置参数生效，以上命令不会报错。接着在192.168.77.11节点执行以下命令：

SET SQL_LOG_BIN=0;
CREATE USER sync@192.168.% identified by sync;
GRANT REPLICATION SLAVE ON *.* TO sync@192.168.%;
flush privileges;
SET SQL_LOG_BIN=1;
SET GLOBAL group_replication_bootstrap_group=ON;
CHANGE MASTER TO MASTER_USER=sync,MASTER_PASSWORD=sync FOR CHANNEL group_replication_recovery;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group=OFF;

接着在192.168.77.12和192.168.77.13节点执行以下命令：

SET SQL_LOG_BIN=0;
CREATE USER sync@192.168.% identified by sync;
GRANT REPLICATION SLAVE ON *.* TO sync@192.168.%;
flush privileges;
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER=sync,MASTER_PASSWORD=sync FOR CHANNEL group_replication_recovery;
START GROUP_REPLICATION;

在任意一个节点运行以下命令，查看MGR集群状态是否正常：

SELECT * FROM performance_schema.replication_group_members;
SELECT MEMBER_ID, MEMBER_HOST, MEMBER_PORT, MEMBER_STATE, IF(global_status.VARIABLE_NAME IS NOT NULL, PRIMARY, SECONDARY) AS MEMBER_ROLE FROM performance_schema.replication_group_members LEFT JOIN performance_schema.global_status ON global_status.VARIABLE_NAME=group_replication_primary_member AND global_status.VARIABLE_VALUE=replication_group_members.MEMBER_ID;

以上命令可以查看集群所有节点状态，确保状态都为ONLINE。

至此，单主模式MGR搭建完成，可以在任意一个节点进行数据插入测试，数据会同步到其他节点。

原创文章，作者：小编小本本，如若转载，请注明出处：https://www.benjiyun.com/yunzhujiyunwei/vps-yunwei/6248.html