SingleStore DB

SingleStore DB Toolbox Installation
Install SingleStore DB Toolbox

Select a distribution type or method of installation from the options below.

Online Installation

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

Note: These steps are also provided in the self-managed SingleStore Tools deployment guides.

  1. Add the SingleStore 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 SingleStore 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 SingleStore DB.

    sudo yum install -y which
    
  4. To install Toolbox, run the following:

    sudo yum install -y singlestoredb-toolbox 
    
Offline Installation

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

singlestoredb-toolbox

singlestoredb-server

For offline installations, you only need to copy and install singlestoredb-toolbox onto the main deployment machine as the sdb-deploy tool in singlestoredb-toolbox will be used to install the singlestoredb-server package onto each host machine in your cluster.

sudo rpm -ivh /tmp/singlestoredb-toolbox-<version>.x86_64.rpm
Online Installation

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

Note: These steps are also provided in the self-managed SingleStore Tools deployment guides.

  1. SingleStore packages are signed to ensure integrity, so the GPG key needs to be added to this machine. When done, verify that the SingleStore 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.

    apt-cache policy apt-transport-https
    

    If apt-transport-https is not installed, you must install it before proceding. user-shell sudo apt -y install apt-transport-https

  3. Add the SingleStore 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. To install Toolbox, run the following:

    sudo apt update && sudo apt -y install singlestoredb-toolbox 
    
Offline Installation

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

singlestoredb-toolbox

singlestoredb-server

sudo dpkg -i /tmp/singlestoredb-toolbox_<version>_amd64.deb
Download SingleStore DB Files

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

singlestoredb-toolbox

singlestoredb-server

Transfer SingleStore DB Files

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

Unpack SingleStore DB Files

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

Unpack singlestoredb-toolbox into the singlestore directory.

tar xzvf singlestoredb-toolbox-<version>.tar.gz 

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

Upgrade SingleStore DB Toolbox

To upgrade the tools in the singlestoredb-toolbox package, follow the same basic steps that you would perform to update any RPM package.

Important

The singlestoredb-server package should be updated through the sdb-deploy upgrade command. This command will install, update, and then restart nodes in your cluster (or rollback the installation process, if necessary).

Online

sudo yum update -y singlestoredb-toolbox

Offline

sudo rpm -Uvh /tmp/singlestoredb-toolbox-<version>.x86_64.rpm

To upgrade the tools in the singlestoredb-toolbox package, follow the same basic steps that you would perform to update any Debian package.

Important

The singlestoredb-server package should be updated through the sdb-deploy upgrade command. This command will install, update, and then restart nodes in your cluster (or rollback the installation process, if necessary).

Online

sudo apt update && sudo apt install -y singlestoredb-toolbox

Offline

sudo dpkg -i /tmp/singlestoredb-toolbox_<version>_amd64.deb
Uninstall SingleStore DB Toolbox

You can either uninstall Toolbox as a standalone task or remove it while uninstalling SingleStore DB. If you want to completely uninstall SingleStore DB and its related tools packages, first uninstall SingleStore DB from your nodes by using the sdb-deploy uninstall command. This will remove the singlestoredb-server package for that version of SingleStore DB (all versions of SingleStore DB can be uninstalled using the --all-versions flag).

Important

The remove command and -e flag will only remove the binaries in the package and not remove any configuration files.

As part of the removal process, or to simply remove Toolbox, perform the following operation:

Online

sudo yum remove singlestoredb-toolbox

Offline

sudo rpm -e singlestoredb-toolbox

You can either uninstall Toolbox as a standalone task or remove it while uninstalling SingleStore DB. If you want to completely uninstall SingleStore DB and its related tools packages, first uninstall SingleStore DB from your nodes by using the sdb-deploy uninstall command. This will remove the singlestoredb-server package for that version of SingleStore DB (all versions of SingleStore DB can be uninstalled using the --all-versions flag).

As part of the removal process, or to simply remove Toolbox, perform the following operation:

Important

The purge command and -P flag will remove the binaries in the package as well as any configuration files. If you want to keep the configuration files, use the remove command or -r flag instead.

Online

sudo apt purge singlestoredb-toolbox

Offline

sudo dpkg -P /tmp/singlestoredb-toolbox_<version>_amd64.deb