orchestrator icon indicating copy to clipboard operation
orchestrator copied to clipboard

Group replication topology is not recognized by Orchestrator

Open KernelPryanic opened this issue 3 years ago • 1 comments

Orchestrator doesn't rocognize the group replication with a single primary.

  • orchestrator.conf.json
  • orchestrator -c topology -i mysql_master returns mysql_master:3306 [0s,ok,8.0.28,rw,ROW,>>,GTID,P-GTID]
  • orchestrator -c topology -i mysql_slave returns mysql_slave:3306 [0s,ok,8.0.28,ro,ROW,>>,GTID]
  • SELECT * FROM performance_schema.replication_group_members; executed on one of the members returns:
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+----------------------------+
| CHANNEL_NAME              | MEMBER_ID                            | MEMBER_HOST  | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+----------------------------+
| group_replication_applier | 96f27822-b03b-11ec-b60c-02420a011202 | mysql_master |        3306 | ONLINE       | PRIMARY     | 8.0.28         | XCom                       |
| group_replication_applier | a10d4411-b03b-11ec-9040-02420a01120c | mysql_slave  |        3306 | ONLINE       | SECONDARY   | 8.0.28         | XCom                       |
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+----------------+----------------------------+

Web UI reports that there's no connection between these servers.

image

Orchestrator version: 3.1.4 MySQL version: 8.0.28

KernelPryanic avatar Mar 30 '22 15:03 KernelPryanic

Okay, after searching through commits I've found out that the group replication support was added in the 3.2.3 version. But the latest available version in the repository is 3.1.4, can you please update the packages up there?) As I was going through the installation document and this repo is mentioned there.

KernelPryanic avatar Mar 31 '22 17:03 KernelPryanic