SingleStore Node Management

MemSQL Ops Command

Description

SingleStore Toolbox Command

memsql-deploy

Deploy a node.

sdb-admin create-node followed up by sdb-admin bootstrap-aggregator, sdb-admin add-leaf or sdb-admin add-aggregator

memsql-list

List all online nodes in the cluster.

sdb-admin list-nodes

As this command lists only online nodes, it does not always present a complete state of the cluster and therefore should not be used to verify the cluster state.

To list all nodes in the cluster use sdb-admin show-leaves and sdb-admin show-aggregators

memsql-start

Start a node.

sdb-admin start-node

memsql-stop

Stop a node.

sdb-admin stop-node

memsql-restart

Restart a node.

sdb-admin restart-node

memsql-monitor

Start monitoring a node in MemSQL Ops.

sdb-admin register-node

memsql-unmonitor

Stop monitoring a node in MemSQL Ops.

sdb-admin unregister-node

memsql-update-config

Change a config value for a node.

sdb-admin update-config

memsql-update-root-password

Update the root password for a node.

sdb-admin change-root-password

memsql-upgrade

Stop, upgrade, and restart all nodes in the cluster.

sdb-deploy upgrade

memsql-optimize

Optimize the cluster for maximum performance.

sdb-admin optimize

memsql-enable-high-availability

Enable high availability for the memsql cluster.

sdb-admin enable-high-availability

memsql-path

Get the directory where a given node is installed.

sdb-admin describe-node

memsql-delete

Delete a node and all of its data.

sdb-admin delete-node

Last modified: October 31, 2023

Was this article helpful?