mysql mgr 8.0_7.mysql8.0版本MGR搭建

搭建MGR

1、配置文件

loose-group_replication_ip_whitelist = 192.168.124.0/24

loose-group_replication_start_on_boot = OFF

loose-group_replication_bootstrap_group = OFF

loose-group_replication_group_name = 0b773c1c-a24c-11ea-8520-5144005e8630

loose-group_replication_local_address = 192.168.124.101:33061

loose-group_replication_group_seeds = 192.168.124.101:33061,192.168.124.102:33061,192.168.124.103:33061

loose-group_replication_single_primary_mode = ON

loose-group_replication_member_weight = 8

loose-group_replication_unreachable_majority_timeout = 10

2、安装插件

在各个mgr节点执行

mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';

Query OK, 0 rows affected (0.13 sec)

mysql> SET SQL_LOG_BIN=0;

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER