List nodes on the host.

Nodes can optionally be filtered by process state and role.

To view nodes across the cluster, run show-leaves or show-aggregators from the host with a running Master Aggregator node.


memsqlctl list-nodes [flags]
--availability-group int Filter for online leaf nodes in the provided availability group
-h, --help Help for list-nodes
-p, --process-state {running, stopped, unknown} Show only nodes with the given process state (default Unspecified)
-q, --quiet Only output matching node IDs
-r, --role {master, aggregator, leaf, unknown} Show only nodes with the given role (default Unspecified)
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 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


  • This command is interactive unless you use either --yes or --json flag to override interactive behavior.

  • The memsqlctl list-nodes command is equivalent to the sdb-admin list-nodes command.

Last modified: April 22, 2024

Was this article helpful?