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>