Introduction
On this page
Use this guide to install the singlestoredb-toolbox
and singlestoredb-server
packages and migrate from MemSQL Ops to the SingleStore management tools for cluster management.
SingleStore Tools allow you to perform cluster management operations for setup, configuration, and diagnostics.
Most of the tools are part of the singlestoredb-toolbox
package.memsqlctl
, is part of the singlestoredb-server
package (which includes the SingleStore engine).
Along with these packages, SingleStore also offers a client application through the singlestore-client
package to connect to your SingleStore cluster and run queries.
Prerequisites
Warning
This guide assumes that your cluster is running MemSQL v7.memsql-ops memsql-list
.
If your cluster is running an earlier version of MemSQL, it will be upgraded to MemSQL v7.
In addition, this guide assumes:
-
The SingleStore cluster components were installed via
rpm,
yum
,apt
, ordpkg
.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-toolboxDebian Distribution:
dpkg -s memsql-toolbox | grep Status --or--dpkg -s singlestoredb-toolbox | grep StatusIf 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
root
password has been set on all nodes in the cluster Learn how to set root password. -
The SingleStore cluster is managed by MemSQL Ops v7.
0 or later, which can be verified via memsql-ops agent-list
Learn how to upgrade. -
SingleStore 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 |
SingleStore (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 SingleStore database component of type aggregator or leaf.
Last modified: June 22, 2022