Install MemSQL Tools min read


The following instructions can be used to install MemSQL tools.

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 that the which package is installed. This is used 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
    
  4. Install MemSQL Toolbox and client application.

    sudo yum install -y memsql-toolbox memsql-client
    

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 each host in the cluster.


memsql-server memsql-toolbox memsql-client

Transfer then install the memsql-toolbox and memsql-client packages on the Master Aggregator using rpm.

sudo rpm -ivh /tmp/memsql-toolbox-<version>.x86_64.rpm
sudo rpm -ivh /tmp/memsql-client-<version>.x86_64.rpm

Transfer then install the memsql-server package on each host using rpm.

sudo rpm -ivh /tmp/memsql-server-<version>.x86_64.rpm

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 host. 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 that apt-transport-https is 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, install MemSQL Toolbox and client application.

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

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 each host in the cluster.


memsql-server memsql-toolbox memsql-client

Transfer then install the memsql-toolbox and memsql-client packages on the Master Aggregator using dpkg.

sudo dpkg -i memsql-toolbox_<version>_amd64.deb
sudo dpkg -i memsql-client_<version>_amd64.deb

Transfer then install the memsql-server package on each host using dpkg.

sudo dpkg -i memsql-server_<version>_amd64.deb