MemSQL Ops Command Mappings

When transitioning from a cluster managed by MemSQL Ops to one managed by the management tools in the memsql-toolbox and memsql-server packages, it is helpful to know which commands and functionality used in MemSQL Ops translate over to the newer tools.

In some cases, there is a direct 1:1 mapping between commands that perform similar functions. In other cases, more than one command may be required to achieve equivalent functionality, or there may not be an equivalent command or set of commands because that functionality is no longer needed when using the new management tools.

Each section below lists the Ops commands and their respective MemSQL tools commands. For cases where the Ops feature or command is no longer applicable, there will be a note in the table or section.

MemSQL Node Management

MemSQL Ops command Description MemSQL Tools command
memsql-deploy Deploy a node. memsql-admin create-node followed up by memsql-admin bootstrap-aggregator, memsql-admin add-leaf or memsql-admin add-aggregator
memsql-list List all nodes in the cluster. memsql-admin list-nodes
memsql-start Start a node. memsql-admin start-node
memsql-stop Stop a node. memsql-admin stop-node
memsql-restart Restart a node. memsql-admin restart-node
memsql-monitor Start monitoring a node in MemSQL Ops. memsql-admin register-node
memsql-unmonitor Stop monitoring a node in MemSQL Ops. n/a
memsql-update-config Change a config value for a node. memsql-admin update-config
memsql-update-root-password Update the root password for a node. memsql-admin change-root-password
memsql-upgrade Stop, upgrade, and restart all nodes in the cluster. memsql-deploy upgrade
memsql-optimize Optimize the cluster for maximum performance. memsql-admin optimize
memsql-enable-high-availability Enable high availability for the memsql cluster. memsql-admin enable-high-availability
memsql-path Get the directory where a given node is installed. memsql-admin describe-node
memsql-delete Delete a node and all of its data. memsql-admin delete-node

MemSQL License Management

MemSQL Ops command Description MemSQL Tools command
license-list List all registered MemSQL licenses. memsql-admin show-license
license-add Add a MemSQL license.
This license will be deployed to all memsql nodes.
memsql-admin set-license

MemSQL Ops Tools

MemSQL Ops command Description MemSQL Tools command
report Generate a report that contains diagnostic information
for MemSQL Ops.
memsql-report collect

Backup Management

The MemSQL management tools do not have equivalent commands to memsql-ops database-backup and memsql-ops database-restore. Instead, you must perform backup and restore operations when logged into a cluster through either the MemSQL client application (found in memsql-client package), MemSQL Studio, or another MySQL-compatible client. This approach allows you to take advantage of additional options such as backing up and restoring to AWS S3 or Azure Blob Storage.

See Backing up and Restoring Data for more details.

Ops Commands Without Equivalent Tools Commands

Because the new MemSQL tools do not use an agent, manage job tasks, perform file management tasks, or have the concept of a superuser, there are no mappings defined for any of the following commands:

Local MemSQL Ops Agent Management

Remote MemSQL Ops Agent Management

MemSQL Ops Job Management

MemSQL Ops File Management

MemSQL Ops Superuser Management

Was this article useful?