show-leaves

A convenience wrapper for running SHOW LEAVES on the Master Aggregator on this host.

Usage

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
  -j, --json                                 Print output in JSON format
      --node-metadata-file FILE_PATH         Path to the node metadata file
      --parallelism int                      Maximum amount of operations to be run in parallel
      --ssl-ca FILE_PATH                     Path to the CA certificate file in PEM format to authenticate the MemSQL server certificate
      --timeout duration                     Maximum time for operation to complete (e.g., 30s, 10m, 1.5h)
  -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.

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 |
+------------+------+--------------------+-----------+-----------+--------+--------------------+------------------------------+
Was this article useful?