Install MemSQL Tools min read


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

These tools perform all major cluster operations including downloading the latest version of MemSQL 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 MemSQL cluster

Note: If MemSQL is installed as a sudo user via packages, systemd will automatically start the associated MemSQL 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 MemSQL YUM repository, run the following commands to install MemSQL tools.

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

Troubleshooting

If MemSQL tools cannot be installed using the steps above, verify that the MemSQL 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 MemSQL tools.

Offline Deployment

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

memsql-client memsql-toolbox memsql-studio memsql-server

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

sudo rpm -ivh /tmp/memsql-client-<version>.x86_64.rpm && \
sudo rpm -ivh /tmp/memsql-toolbox-<version>.x86_64.rpm && \
sudo rpm -ivh /tmp/memsql-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 MemSQL APT repository, run the following commands to install MemSQL 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 memsql-client memsql-toolbox memsql-studio

Offline Deployment

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

memsql-client memsql-toolbox memsql-studio memsql-server

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

sudo dpkg -i memsql-client_<version>_amd64.deb && \
sudo dpkg -i memsql-toolbox_<version>_amd64.deb && \
sudo dpkg -i memsql-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 MemSQL Files

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

memsql-client memsql-toolbox memsql-studio memsql-server

Transfer MemSQL Files

Transfer the memsql-client, memsql-toolbox, memsql-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 MemSQL Files

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

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

tar xzvf memsql-client-<version>.tar.gz && \
tar xzvf memsql-toolbox-<version>.tar.gz && \
tar xzvf memsql-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.