Use this guide to install the memsql-toolbox and memsql-server packages and migrate from MemSQL Ops to the MemSQL management tools for cluster management. The migration tool automates most of the migration process.

MemSQL tools allow you to perform cluster management operations for setup, configuration, and diagnostics. Operations are done through CLI commands which can be easily scripted for use in a variety of deployment environments and scenarios.

Most of the tools are part of the memsql-toolbox package. However, the lower-level management tool, memsqlctl, is part of the memsql-server package (which includes the MemSQL engine).

Along with these packages, MemSQL also offers a client application through the memsql-client package to connect to your MemSQL cluster and run queries.

Prerequisites

This guide assumes that:

• The MemSQL cluster components were installed via rpm, yum, apt, or dpkg. To verify that the cluster was created via package install, run the following commands on the Linux command line.

  Red Hat Distribution:

  sudo yum list --installed | grep memsql-toolbox --or--
  sudo yum list --installed | grep singlestoredb-toolbox --or--
  rpm -qa | grep memsql-toolbox --or--
  rpm -qa | grep singlestoredb-toolbo
  

  Debian Distribution:

  dpkg -s memsql-toolbox | grep Status --or--
  dpkg -s singlestoredb-toolbox | grep Status
  

  If none of these packages are installed, the cluster was likely deployed via tarball, and so the non-sudo version of the Ops to Tools migration guide should be followed instead.

• The user that created the cluster has sudo privileges.

• The user performing the migration has sudo privileges.

• A MemSQL root password has been set on all nodes in the cluster (Learn how to set root password).

• The MemSQL cluster is managed by MemSQL Ops v6.8 or later, which can be verified via memsql-ops agent-list (Learn how to upgrade).

• The MemSQL cluster is running MemSQL 6.8, which can be verified via memsql-ops memsql-list (Learn how to upgrade).

• MemSQL Toolbox v1.3.0 or later, which can be verified via memsql-toolbox-config version (Learn how to upgrade).

Ports

Ensure that the following ports are open for use:

Secure-Shell Access

The installing user must be able to log into each host via ssh.

Terminology

Host

A host is a physical or virtual machine.

Node

In MemSQL parlance, a node is a MemSQL database component of type aggregator or leaf.

Was this Article Helpful?

Thanks For Your Feedback!