The SHOW COMPUTE NODES syntax is used to query proxy instance information.
ShowComputeNodes ::=
'SHOW' 'COMPUTE' 'NODES'
| Columns | Description |
|---|---|
| instance_id | proxy instance id |
| host | host address |
| port | port number |
| status | proxy instance status |
| mode_type | proxy instance mode |
| worker_id | worker id |
| labels | labels |
| version | version |
SHOW COMPUTE NODES;
mysql> SHOW COMPUTE NODES;
+--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
| instance_id | host | port | status | mode_type | worker_id | labels | version |
+--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
| 734bb036-b15d-4af0-be87-2372d8b6a0cd | 192.168.5.163 | 3307 | OK | Cluster | -1 | | 5.3.0 |
+--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
1 row in set (0.01 sec)
SHOW, COMPUTE, NODES