Install MemSQL Tools min read


Download and install the MemSQL tools onto your host machine. This machine will be designated as the main deployment machine for deploying MemSQL across your other host machines and setting up your cluster.

Online Installation

For online installations where you can access the MemSQL YUM repository, run the following steps.

  1. Add the MemSQL repository to your repository list.

    sudo yum-config-manager --add-repo https://release.memsql.com/production/rpm/x86_64/repodata/memsql.repo
    
  2. Verify that the MemSQL repo information is listed under repolist.

    sudo yum repolist
    
  3. Verify you have the which package 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. If you cannot install which, you will have to specify the correct package during the deployment phase covered in Deploy MemSQL.

    sudo yum install -y which
    
  4. Install MemSQL’s management tools, client application, and MemSQL Studio.

    sudo yum install -y memsql-toolbox memsql-client memsql-studio
    

Offline Installation

For clusters that must be deployed in an environment without Internet access, download the following MemSQL packages onto a device with access to the main deployment machine.


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

Install the memsql-client, memsql-studio, and memsql-toolbox packages using rpm.

sudo rpm -ivh /tmp/memsql-toolbox-<version>.x86_64.rpm
sudo rpm -ivh /tmp/memsql-client-<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 Installation

For online installations where you can access the MemSQL APT repository, run the following steps.

  1. MemSQL packages are signed to ensure integrity, so the GPG key needs to be added to this machine. When done, verify that the MemSQL signing key has been added using apt-key list.

    wget -O - 'https://release.memsql.com/release-aug2018.gpg'  2>/dev/null | sudo apt-key add - && apt-key list
    
  2. Verify you have apt-transport-https installed. The apt-transport-https package is used to download packages from the MemSQL package repository.

    apt-cache policy apt-transport-https
    

    If apt-transport-https is not installed, you must install it before proceeding.

    sudo apt -y install apt-transport-https
    
  3. Add the MemSQL repository to retrieve its packages.

    echo "deb [arch=amd64] https://release.memsql.com/production/debian memsql main" | sudo tee /etc/apt/sources.list.d/memsql.list
    
  4. After verifying the MemSQL repo information is listed in the output, MemSQL’s management tools, client application, and MemSQL Studio will be installed.

    sudo apt update && sudo apt -y install memsql-toolbox memsql-client memsql-studio
    

Offline Installation

For clusters that must be deployed in an environment without Internet access, download the following MemSQL packages onto a device with access to the main deployment machine.


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

Install the memsql-client, memsql-studio, and memsql-toolbox packages using dpkg.

sudo dpkg -i memsql-client_<version>_amd64.deb
sudo dpkg -i memsql-studio_<version>_amd64.deb
sudo dpkg -i memsql-toolbox_<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.

Was this article useful?