MySQL Shell如何接管手动搭建(含仲裁节点)MGR集群

本文源自GreatSQL社区用户的一次提问:

Q:一个包含仲裁节点(ARBITRATOR)的GreatSQL MGR集群,一开始是用手动方式构建,后来想用MySQL Shell接管,可以吗?

A:是可以的,不过也有一定局限性

具体的操作如下

检查当前MGR集群情况

greatsql> select * from performance_schema.replication_group_members;<br>+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+<br>| CHANNEL_NAME              | MEMBER_ID                   | MEMBER_HOST   | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |<br>+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+<br>| group_replication_applier | 04b57be0-73a0-11ee-a450-00155d064000 | 192.168.5.170 |     3307  | ONLINE     | SECONDARY   | 8.0.32       | XCom               |<br>| group_replication_applier | 0b157081-73a7-11ee-899b-00155d064000 | 192.168.5.170 |     3308  | ONLINE     | ARBITRATOR  | 8.0.32       | XCom               |<br>| group_replication_applier | d4b877cf-16f0-11ee-9e98-00155d064000 | 192.168.5.170 |     3306  | ONLINE     | PRIMARY    | 8.0.32       | XCom               |<br>+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+<br>3 rows in set (0.00 sec)<br>