Product Solutions Support
Try MemSQL

SHOW LEAVES

Shows the leaves in a cluster.

SHOW LEAVES;

Output

Column Description
Host Host name or IP address
Port Port number
Availability_Group Availability group to which this leaf belongs
Pair_Host Pair host
Pair_Port Pair port
State Leaf state (see Leaf States)
Opened_Connections Number of opened connections
Average_Roundtrip_Latency Average round-trip latency

Example

memsql> SHOW LEAVES;
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
| Host          | Port  | Availability_Group | Pair_Host     | Pair_Port | State  | Opened_Connections | Average_Roundtrip_Latency |
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
| 192.168.1.110 |  3306 |                  1 | 192.168.1.112 |      3306 | online |                  5 |                     0.299 |
| 192.168.1.111 |  3306 |                  1 | 192.168.1.113 |      3306 | online |                  5 |                     0.293 |
| 192.168.1.112 |  3306 |                  2 | 192.168.1.110 |      3306 | online |                  1 |                     0.271 |
| 192.168.1.113 |  3306 |                  2 | 192.168.1.111 |      3306 | online |                  1 |                     0.264 |
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+---------------------------+
4 rows in set (0.00 sec)
Was this article useful?