memsqlctl

The memsqlctl tool is the lower-level tool used to control and manage SingleStore nodes on a host. The memsqlctl tool is available in the singlestoredb-server package (along with the SingleStore database engine).

Several SQL commands that perform these management tasks are wrapped in memsqlctl commands, which allow popular configuration management tools to automate the deployment of a SingleStore cluster across a set of hosts. Also, many of the higher-level commands from sdb-admin, sdb-deploy, etc. call memsqlctl to perform their actions locally on a host and the report back the results.

The following is a complete list of operations you can do with memsqlctl:

• add-aggregator

• add-leaf

• bootstrap-aggregator

• change-root-password

• collect-garbage

• create-node

• delete-node

• describe-node

• enable-high-availability

• list-nodes

• optimize

• query

• register-node

• remove-aggregator

• remove-leaf

• restart-node

• set-license

• show-aggregators

• show-cluster

• show-leaves

• show-license

• start-node

• stop-node

• unregister-node

• update-config

• update-node-basedir