Introduction
Use this guide to install the singlestoredb-toolbox
and singlestoredb-server
packages and migrate from MemSQL Ops to the SingleStoreDB management tools for cluster management. The migration tool automates most of the migration process.
SingleStore 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 singlestoredb-toolbox
package. However, the lower-level management tool, memsqlctl
, is part of the singlestoredb-server
package (which includes the SingleStoreDB engine).
Along with these packages, SingleStore also offers a client application through the singlestore-client
package to connect to your SingleStoreDB cluster and run queries.
Note
While the /home/<user>/singlestore
directory is used through this guide to hold the necessary migration files and demonstrate the associated migration commands, this directory can be substituted with any directory that a non-sudo
user has access to.
Prerequisites
Warning
This guide assumes that your cluster is running MemSQL v7.0 or later, which can be verified via memsql-ops memsql-list
.
If your cluster is running an earlier version of MemSQL, it will be upgraded to MemSQL v7.0 as part of this migration.
In addition, this guide assumes:
The SingleStoreDB cluster components were installed via tarball
The user that created the cluster does not have
sudo
privilegesThe user performing the migration does not have
sudo
privilegesA
root
password has been set on all nodes in the cluster Learn how to set root password.The SingleStoreDB cluster is managed by MemSQL Ops v7.0 or later, which can be verified via
memsql-ops agent-list
Learn how to upgrade.SingleStoreDB Toolbox v1.3.0 or later, which can be verified via
sdb-toolbox-config version
Learn how to upgrade.
Ports
Ensure that the following ports are open for use:
Port | Type | For |
---|---|---|
22 | Inbound/Outbound | SSH / SFTP |
80 | Inbound/Outbound | MemSQL Ops |
443 | Inbound/Outbound | SingleStore repository connection |
3306 | Inbound/Outbound | SingleStoreDB (default) |
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 SingleStore parlance, a node is a SingleStoreDB database component of type aggregator or leaf.