SingleStore DB

list-nodes
Description

List MemSQL Nodes on the local machine.

Usage
List MemSQL Nodes on the local machine

Usage:
  memsqlctl list-nodes [flags]

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 MemSQL 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 SingleStore DB 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                     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)
      --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

Important

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

  • Nodes can optionally be filtered by process state and role.

  • 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.