配置MYSQL组复制
mysql> set SQL_LOG_BIN=0;Query OK, 0 rows affected (0.00 sec)
mysql> create user repl@'%' identified by "123456";
Query OK, 0 rows affected (0.01 sec)
mysql> grant replication slave on *.* to repl@'%';
Query OK, 0 rows affected (0.00 sec)
mysql>flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>set SQL_LOG_BIN=1;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_user='repl',master_password='123456' for channel 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0.05 sec)
mysql>install PLUGIN group_replication SONAME 'group_replication.so';
Query OK, 0 rows affected (0.38 sec)
mysql>set global group_replication_allow_local_disjoint_gtids_join=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> start group_replication;
Query OK, 0 rows affected (7.89 sec)
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
| group_replication_applier | 33025907-6d2d-11e7-8ce6-000c29e07281 | vm2 | 3306 | ONLINE |
| group_replication_applier | 35678d62-6d2d-11e7-80a7-000c2909332c | vm3 | 3306 | ONLINE |
| group_replication_applier | 8b643791-6d30-11e7-986a-000c29d53b31 | vm1 | 3306 | ONLINE |
+---------------------------+--------------------------------------+-------------+-------------+--------------+
3 rows in set (0.00 sec)
页:
[1]