Install SingleStore Tools min read


The first step in deploying your cluster is to download and install the SingleStore Tools on one of the hosts in your cluster. This host will be designated as the main deployment host for deploying SingleStore DB across your other hosts and setting up your cluster.

These tools perform all major cluster operations including downloading the latest version of SingleStore DB onto your hosts, assigning and configuring nodes in your cluster, and other management operations.

For the purpose of this guide, the main deployment host is the same as the designated Master Aggregator of the cluster

Note: If SingleStore DB is installed as a sudo user via packages, systemd will automatically start the associated SingleStore DB processes when a host is rebooted. Tarball-based installs will not restart services when a host is rebooted unless manually configured by the user.

Online Deployment

For an online deployment, where the main deployment host can access the SingleStore YUM repository, run the following commands to install SingleStore Tools.

sudo yum-config-manager --add-repo https://release.memsql.com/production/rpm/x86_64/repodata/memsql.repo && \
sudo yum install -y singlestore-client singlestoredb-toolbox singlestoredb-studio

Troubleshooting

If SingleStore Tools cannot be installed using the steps above, verify that the SingleStore repo information is listed under repolist.

sudo yum repolist
****
repo id            repo name            status
memsql             MemSQL               125

Verify that the which package is installed. This is used during the install process to identify the correct package type for your installation.

rpm -q which

If which is not installed, you must install it before proceeding.

sudo yum install -y which

If you cannot install which, you will need to specify the correct package type (either rpm or deb) during the deployment phase.

After verifying the above, re-run the commands to install SingleStore Tools.

Offline Deployment

For an offline deployment, where the main deployment host cannot access the SingleStore YUM repository, download the following SingleStore packages onto a device with access to the main deployment host.

singlestore-client singlestoredb-toolbox singlestoredb-studio memsql-server

Copy the singlestore-client, singlestoredb-toolbox, and singlestoredb-studio packages onto the main deployment host and install them using rpm.

sudo rpm -ivh /tmp/singlestore-client-<version>.x86_64.rpm && \
sudo rpm -ivh /tmp/singlestoredb-toolbox-<version>.x86_64.rpm && \
sudo rpm -ivh /tmp/singlestoredb-studio-<version>.x86_64.rpm

You do not need to install the memsql-server package in this step. It will be installed as part of deployment, which is shown in the next step.

Online Deployment

For an online deployment, where the main deployment host can access the SingleStore APT repository, run the following commands to install SingleStore Tools.

wget -O - 'https://release.memsql.com/release-aug2018.gpg'  2>/dev/null | sudo apt-key add - && apt-key list && \
apt-cache policy apt-transport-https && \
sudo apt -y install apt-transport-https && \
echo "deb [arch=amd64] https://release.memsql.com/production/debian memsql main" | sudo tee /etc/apt/sources.list.d/memsql.list && \
sudo apt update && sudo apt -y install singlestore-client singlestoredb-toolbox singlestoredb-studio

Offline Deployment

For an offline deployment, where the main deployment host cannot access the SingleStore YUM repository, download the following SingleStore packages onto a device with access to the main deployment host.

singlestore-client singlestoredb-toolbox singlestoredb-studio memsql-server

Then copy the singlestore-client, singlestoredb-toolbox, and singlestoredb-studio packages onto the main deployment host and install them using dpkg.

sudo dpkg -i singlestore-client_<version>_amd64.deb && \
sudo dpkg -i singlestoredb-toolbox_<version>_amd64.deb && \
sudo dpkg -i singlestoredb-studio_<version>_amd64.deb

You do not need to install the memsql-server package in this step. It will be installed as part of deployment, which is shown in the next step.

Download SingleStore DB Files

Download the following SingleStore DB tarball files onto a device with access to the main deployment host.

singlestore-client singlestoredb-toolbox singlestoredb-studio memsql-server

Transfer SingleStore DB Files

Transfer the singlestore-client, singlestoredb-toolbox, singlestoredb-studio, and memsql-server tarball files into a dedicated memsql directory that has been configured so that non-sudo users can access on the main deployment host, such as /home/<user>/memsql or /opt/memsql.

Unpack SingleStore DB Files

Note: For the remainder of this document, <version>-<commit-hash> will be written simply as <version>.

Unpack singlestore-client, singlestoredb-toolbox, and singlestoredb-studio into the memsql directory.

tar xzvf singlestore-client-<version>.tar.gz && \
tar xzvf singlestoredb-toolbox-<version>.tar.gz && \
tar xzvf singlestoredb-studio-<version>.tar.gz

You do not need to unpack the memsql-server file in this step. It will be installed as part of deployment, which is shown in the next step.