SingleStore DB

restart-node

Restart one or all MemSQL nodes on the local machine.

Usage

You can retrieve help for the command by typing <application> [command] --help in the command line.

Remarks

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 list of nodes.

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.

Output

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