Outdated Version
You are viewing an older version of this section. View current production version.
show-leaves
Info
SingleStore Managed Service does not support this command.
A convenience wrapper for running SELECT * FROM INFORMATION_SCHEMA.LEAVES on the Master Aggregator on this host.
Usage
A convenience wrapper for running `SELECT * FROM INFORMATION_SCHEMA.LEAVES` on the Master Aggregator on this host
Usage:
memsqlctl show-leaves [flags]
Flags:
-h, --help Help for show-leaves
Global Flags:
-c, --config FILE_PATH Path to the memsqctl config file
--default-install-dir DIRECTORY_PATH Path to the default install directory
--insecure-ssl Fall back to insecure SSL connections to local SingleStoreDB nodes if memsqlctl is unable to otherwise establish a connection (ADVANCED)
-j, --json Print output in JSON format
--node-metadata-file FILE_PATH Path to the node metadata file
--parallelism POSITIVE_INTEGER Maximum amount of operations to be run in parallel
--ssl-ca FILE_PATH The path to the CA certificate file (in PEM format) to authenticate the database certificate
--timeout duration Maximum time for operation to complete (e.g., 30s, 10m, 1.5h)
--verbose-json Print output in JSON format, include some warnings and user messages
-v, --verbosity count Increase logging verbosity
-y, --yes Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default
Remarks
Returns a list of leaves in the cluster. This command must be run from the same host that the Master Aggregator is on.
This command is interactive unless you use either the --yes or --json flags to override interactive behavior.
The memsqlctl show-leaves command is equivalent to the sdb-admin show-leaves command.
Output
The following is the standard output for the show-leaves command.
$ sudo memsqlctl show-leaves
+------------+------+--------------------+-----------+-----------+--------+--------------------+------------------------------+
| Host | Port | Availability Group | Pair Host | Pair Port | State | Opened Connections | Average Roundtrip Latency ms |
+------------+------+--------------------+-----------+-----------+--------+--------------------+------------------------------+
| 172.17.0.5 | 3306 | 1 | null | null | online | 2 | 0.453 |
| 172.17.0.6 | 3306 | 1 | null | null | online | 2 | 0.453 |
| 172.17.0.7 | 3306 | 1 | null | null | online | 2 | 0.453 |
+------------+------+--------------------+-----------+-----------+--------+--------------------+------------------------------+
