MGR配置

MGR配置
2.3.4.1、mdmprddb01节点配置
1、/etc/hosts配置文件设置：
10.192.9.57 mdmprddb01
10.192.9.58 mdmprddb02
10.193.36.62 mdmprddb03

2、/etc/my.cf配置文件设置：
server-id=1
...
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE #将master.info元数据保存在系统表中
relay_log_info_repository = TABLE #将relay.info元数据保存在系统表中
binlog_checksum = NONE #禁用二进制日志事件校验
log_slave_updates = ON #级联复制A->B->C
transaction_write_set_extraction = XXHASH64 #使用哈希算法
loose-group_replication_group_name = '5a421130-2674-11ea-bbce-00505639ee45'
loose-group_replication_start_on_boot = off #不自动启用组复制集群
loose-group_replication_local_address = 'mdmprddb01:33061' #本机地址和端口
loose-group_replication_group_seeds = 'mdmprddb01:33061,mdmprddb02:33061,n7mdmprddb03:33061' #组中成员
loose-group_replication_bootstrap_group = off #不启用引导组，手动引导启动

3、执行：/data/mysql/mysql/bin/mysql -uroot -pMdm@2024@SQL4rfv -A 进入MySQL命令行
4、 在mysql命令行中按顺序执行下面sql语句
create user 'repl'@'%' identified with mysql_native_password by 'repl';
grant replication slave on . to 'repl'@'%';
flush privileges;
set sql_log_bin=1;
set global group_replication_bootstrap_group=on;
set global group_replication_ip_whitelist="10.192.9.57,10.192.9.58,10.193.36.62";
start group_replication;
set global group_replication_bootstrap_group=off;
set global group_replication_single_primary_mode=off;
set global group_replication_enforce_update_everywhere_checks=on;
set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;

2.3.4.2、mdmprddb02节点配置
1、/etc/hosts配置文件设置：
10.192.9.57 mdmprddb01
10.192.9.58 mdmprddb02
10.193.36.62 mdmprddb03
2、/etc/my.cf配置文件设置：
server-id=2
...
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE #将master.info元数据保存在系统表中
relay_log_info_repository = TABLE #将relay.info元数据保存在系统表中
binlog_checksum = NONE #禁用二进制日志事件校验
log_slave_updates = ON #级联复制A->B->C
transaction_write_set_extraction = XXHASH64 #使用哈希算法
loose-group_replication_group_name = '5a421130-2674-11ea-bbce-00505639ee45'
loose-group_replication_start_on_boot = off #不自动启用组复制集群
loose-group_replication_local_address = 'mdmprddb02:33061' #本机地址和端口
loose-group_replication_group_seeds = 'mdmprddb01:33061,mdmprddb02:33061,n7mdmprddb03:33061' #组中成员
loose-group_replication_bootstrap_group = off #不启用引导组，手动引导启动

3、执行：/data/mysql/mysql/bin/mysql -uroot -pxxx -A 进入MySQL命令行
4、 在mysql命令行中按顺序执行下面sql语句
create user 'repl'@'%' identified with mysql_native_password by 'repl';
grant replication slave on . to 'repl'@'%';
flush privileges;
set sql_log_bin=1;
set global group_replication_bootstrap_group=on;
set global group_replication_ip_whitelist="10.192.9.57,10.192.9.58,10.193.36.62";
start group_replication;
set global group_replication_bootstrap_group=off;
set global group_replication_single_primary_mode=off;
set global group_replication_enforce_update_everywhere_checks=on;
set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;

2.3.4.3、n7mdmprddb03节点配置
1、/etc/hosts配置文件设置：
10.192.9.57 mdmprddb01
10.192.9.58 mdmprddb02
10.193.36.62 mdmprddb03
2、/etc/my.cf配置文件设置：
server-id=3
...
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE #将master.info元数据保存在系统表中
relay_log_info_repository = TABLE #将relay.info元数据保存在系统表中
binlog_checksum = NONE #禁用二进制日志事件校验
log_slave_updates = ON #级联复制A->B->C
transaction_write_set_extraction = XXHASH64 #使用哈希算法
loose-group_replication_group_name = '5a421130-2674-11ea-bbce-00505639ee45'
loose-group_replication_start_on_boot = off #不自动启用组复制集群
loose-group_replication_local_address = 'n7mdmprddb03:33061' #本机地址和端口
loose-group_replication_group_seeds = 'mdmprddb01:33061,mdmprddb02:33061,n7mdmprddb03:33061' #组中成员
loose-group_replication_bootstrap_group = off #不启用引导组，手动引导启动

3、执行：/data/mysql/mysql/bin/mysql -uroot -pxxx -A 进入MySQL命令行
4、 在mysql命令行中按顺序执行下面sql语句
create user 'repl'@'%' identified with mysql_native_password by 'repl';
grant replication slave on . to 'repl'@'%';
flush privileges;
set sql_log_bin=1;
set global group_replication_bootstrap_group=on;
set global group_replication_ip_whitelist="10.192.9.57,10.192.9.58,10.193.36.62";
start group_replication;
set global group_replication_bootstrap_group=off;
set global group_replication_single_primary_mode=off;
set global group_replication_enforce_update_everywhere_checks=on;
set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;

2.3.4.4、检查MGR集群
在各节点执行/data/mysql/mysql/bin/mysql -uroot -pxxx -A 进入MySQL命令行后执行下面的SQL语句检查：
select * from performance_schema.replication_group_members;
检查结果如下：