Add a New Client Host

Online Installation

For online installations where the target host can access the SingleStore YUM repository, perform the following steps.

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

1. Add the SingleStore repository to your repository list.

   Shell

   Copy

   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.

   Shell

   Copy

   sudo yum repolist

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

   Shell

   Copy

   rpm -q which

   If which is not installed, it must be installed before proceeding.

   If you cannot install which, you will have to specify the correct package during the deployment phase covered in the respective deployment guide.

   Shell

   Copy

   sudo yum install -y which

4. Install the SingleStore client.

   Shell

   Copy

   sudo yum install -y singlestore-client

Offline Installation

For clusters that must be deployed in an environment without Internet access, download the SingleStore client package onto a host that can access the main deployment host.

singlestore-client

Copy the SingleStore client package onto the target host (typically the main deployment host when deploying SingleStoreDB) and install the SingleStore client.

sudo rpm -ivh /tmp/singlestore-client-<version>-<commit-hash>.x86_64.rpm

Online Installation

For online installations where the target host can access the SingleStore APT repository, perform the following steps.

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

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

   Shell

   Copy

   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.

   Shell

   Copy

   apt-cache policy apt-transport-https

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

   Shell

   Copy

   user-shell sudo apt -y install apt-transport-https

3. Add the SingleStore repository to retrieve its packages.

   Shell

   Copy

   echo "deb [arch=amd64] https://release.memsql.com/production/debian memsql main" | sudo tee /etc/apt/sources.list.d/memsql.list

4. Install the SingleStore client.

   Shell

   Copy

   sudo apt update && sudo apt -y install singlestore-client

Offline Installation

For clusters that must be deployed in an environment without Internet access, download the SingleStore client package onto a host that can access the main deployment host.

singlestore-client

Copy the SingleStore client package onto the target host (typically the main deployment host when deploying SingleStoreDB) and install the SingleStore client.

sudo dpkg -i /tmp/singlestore-client_<version>_<commit-hash>_amd64.deb

Download the SingleStore Client

Download the SingleStore client tarball file onto a host that can access the main deployment host.

singlestore-client

Transfer the SingleStore Client

Transfer the SingleStore client tarball file into a dedicated singlestore directory on the target host (typically the main deployment host when deploying SingleStoreDB) that has been configured so that non-sudo users can access it, such as /home/<user>/singlestore or /opt/singlestore.

Unpack the SingleStore Client

Unpack the SingleStore client tarball file into the singlestore directory.

tar xzvf singlestore-client-<version>-<commit-hash>.x86_64.tar.gz

Using symbolic links (or "symlinks") can make using and upgrading the SingleStore client easier. Performing the following steps will allow the singlestore command to be run from anywhere on the filesystem, even after an upgrade by updating the symlink.

1. Navigate to the directory that contains the unpacked SingleStore client tarball file and create a singlestore-client symlink that points to the SingleStore client directory.

   Shell

   Copy

   ln -s singlestore-client-<version>-<commit-hash> singlestore-client

2. Verify that the symlink has been created.

   Shell

   Copy

   ls -l

   singlestore-client -> singlestore-client-1.0.6-c3803db03b

3. Update the PATH environment variable with the path to the new singlestore-client directory. This path can also be added to your shell startup file so you won't have to run this command each time you log in.

   Shell

   Copy

   export PATH=/home/<user>/singlestore/singlestore-client:$PATH

4. You may now run the singlestore command from anywhere on the filesystem.

   Shell

   Copy

   singlestore