Skip to main content



Restart one or all nodes on the host.

The restart-node command runs stop-node followed by start-node on a node or set of nodes.

If neither --memsql-id nor --all is specified, memsqlctl will prompt the user to select a node from a table.


  memsqlctl restart-node [flags]

  -a, --all                    Restart all nodes on the host
      --disable-auto-restart   Disable automatic restarting of memsqld on error
  -h, --help                   Help for restart-node
      --memsql-id strings      The node ID of the node to restart

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


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

  • The memsqlctl restart-node command is equivalent to the sdb-admin restart-node command.


The following is the standard output for the restart-node command.

sudo memsqlctl restart-node
| Index |                MemSQL ID                 |  Role  | Port | Process State | Version |
|     1 | 2D0C05E1E459051FB0B2D34C9FF6B52967C58F93 | Master | 3306 | Running       | 6.5.10  |
|     2 | All Nodes                                |        |      |               |         |
Select an option: 1
memsqlctl will perform the following actions:
  · Set up runtime environment

  · Stop node with MemSQL ID 179062CAEEBCBDA755B75297BF6D9B2AE4C98FB7 on port 3306
  · Start node with MemSQL ID 179062CAEEBCBDA755B75297BF6D9B2AE4C98FB7 on port 3306

Would you like to continue? [y/N]: y
✓ Set up runtime environment
✓ Stopped node with MemSQL ID 179062CAEEBCBDA755B75297BF6D9B2AE4C98FB7
✓ Started node with MemSQL ID 179062CAEEBCBDA755B75297BF6D9B2AE4C98FB7