MGR——Mysql的组复制之多主模式

xuol001

mysql>SET GLOBAL group_replication_bootstrap_group=ON;　　#这句只有server33,在第一次执行引导组的时候执行.
　　mysql> CREATE USER repl@'%';
　　mysql> GRANT REPLICATION SLAVE ON *.* TO repl@'%' IDENTIFIED BY 'repl';
　　Query OK, 0 rows affected, 1 warning (0.00 sec)
　　mysql> CHANGE MASTER TO MASTER_USER='repl',MASTER_PASSWORD='repl' FOR CHANNEL 'group_replication_recovery';
　　Query OK, 0 rows affected, 2 warnings (0.27 sec)
　　mysql> set global group_replication_ip_whitelist="127.0.0.1/32,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16,172.25.88.0/24";
　　Query OK, 0 rows affected (0.00 sec)
　　mysql> START GROUP_REPLICATION;                                                 Query OK, 0 rows affected (1.32 sec)
　　mysql> SELECT * FROM performance_schema.replication_group_members;
　　+---------------------------+--------------------------------------+---------------------+-------------+--------------+
　　| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST         | MEMBER_PORT | MEMBER_STATE |
　　+---------------------------+--------------------------------------+---------------------+-------------+--------------+
　　| group_replication_applier | eb724b27-19b2-11e7-8c21-525400cef621 | server33.lalala.com |        3306 | ONLINE       |
　　+---------------------------+--------------------------------------+---------------------+-------------+--------------+
　　1 row in set (0.00 sec)