Outdated Version

You are viewing an older version of this section. View current production version.

Deploy SingleStore DB Offline

Download MemSQL Files

Download the singlestore-client, singlestoredb-toolbox, memsql-server, and singlestoredb-studio files onto the main deployment machine.

To obtain the latest version of each file, use the following:

curl https://release.memsql.com/production/index/<singlestore-file>/latest.json

Replace <singlestore-file> with memsqlclient, memsqltoolbox, memsqlserver, and memsqlstudio to download the list of available file types.

The JSON you receive contains relative file paths in the following format.

Red Hat Distribution

"Path": "production/rpm/x86_64/<singlestore-file>-<version>-<commit-hash>.x86_64.rpm"

Debian Distribution

"Path": "production/debian/pool/<singlestore-file>_<version>_<commit-hash>_amd64.deb"

Tarball Files

"Path": "production/tar/x86_64/<singlestore-file>-<version>-<commit-hash>.x86_64.tar.gz"

Use wget to download the file by copying, pasting, and appending the path (minus the quotes) to https://release.memsql.com/. Examples are shown below.

Red Hat Distribution

wget https://release.memsql.com/production/rpm/x86_64/<singlestore-file>-<version>-<commit-hash>.x86_64.rpm

Debian Distribution

wget https://release.memsql.com/production/debian/pool/<singlestore-file>_<version>_<commit-hash>_amd64.deb

Tarball Files

wget https://release.memsql.com/production/tar/x86_64/<singlestore-file>-<version>-<commit-hash>.x86_64.tar.gz

Alternatively, click on the desired file type below and click each button to download these files to your computer.

singlestore-client singlestoredb-toolbox memsql-server singlestoredb-studio
singlestore-client singlestoredb-toolbox memsql-server singlestoredb-studio
singlestore-client singlestoredb-toolbox memsql-server singlestoredb-studio

Transfer MemSQL Files

Transfer the singlestore-client, singlestoredb-toolbox, memsql-server, and singlestoredb-studio files onto the main deployment machine to a dedicated singlestore directory that sudo users (.rpm and .deb files) and non-sudo users (.tar.gz files) can access.

Install MemSQL

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

For .rpm and .deb files, install singlestore-client, singlestoredb-toolbox, and singlestoredb-studio.

Red Hat Distribution

sudo rpm -ivh singlestore-client-<version>.x86_64.rpm
sudo rpm -ivh singlestoredb-toolbox-<version>.x86_64.rpm
sudo rpm -ivh singlestoredb-studio-<version>.x86_64.rpm

Debian Distribution

sudo dpkg -i singlestore-client<singlestore-file>_<version>_amd64.deb
sudo dpkg -i singlestoredb-toolbox<singlestore-file>_<version>_amd64.deb
sudo dpkg -i singlestoredb-studio<singlestore-file>_<version>_amd64.deb

Tarball Files

For .tar.gz files, unpack singlestore-client, singlestoredb-toolbox, and singlestoredb-studio into the singlestore directory.

tar xzvf singlestore-client-<version>.tar.gz
tar xzvf singlestoredb-toolbox-<version>.tar.gz
tar xzvf singlestoredb-studio-<version>.tar.gz

Note: You do not need to install or unpack memsql-server as it will be installed during deployment.

Deploy SingleStore DB

Run the following command on the main deployment machine.

Red Hat and Debian Distributions

sdb-deploy setup-cluster -i <id_rsa-file-including-path> \
--license <memsql-license-from-portal.memsql.com> \
--master-host <master-aggregator-ip-or-hostname> \
--aggregator-hosts <child-aggregator-ip-or-hostname>\
--leaf-hosts <leaf-1-ip-or-hostname>,<leaf-2-ip-or-hostname> \
--password <desired-memsql-password,blank-if-none> \
--file-path <memsql-server-file-including-path>

Note the inclusion of the --file-path option.

Tarball Files

  1. Change to the singlestoredb-toolbox- directory.

    cd singlestoredb-toolbox-<version>
    
  2. Deploy SingleStore DB.

    ./sdb-deploy setup-cluster -i <id_rsa-file-including-path> \
    --license <memsql-license-from-portal.memsql.com> \
    --master-host <master-aggregator-ip-or-hostname> \
    --aggregator-hosts <child-aggregator-ip-or-hostname> \
    --leaf-hosts <leaf-1-ip-or-hostname>,<leaf-2-ip-or-hostname> \
    --password <desired-memsql-password,blank-if-none> \
    --file-path <memsql-server-file-including-path> \
    --force-package-format tar
    

    Note the inclusion of both the --file-path and --force-package-format tar options.

Interact with Your Cluster

On your main deployment machine, run the following command to use SingleStore DB Studio to monitor and interact with your cluster.

Red Hat and Debian Distributions

  1. Recommended: Enable the SingleStore DB Studio service to start SingleStore DB Studio at system boot.

    sudo systemctl enable singlestoredb-studio.service
    ****
    Created symlink from /etc/systemd/system/multi-user.target.wants/memsql-studio.service to /usr/lib/systemd/system/memsql-studio.service.
    
  2. Start SingleStore DB Studio.

    sudo systemctl start singlestoredb-studio
    

Tarball Files

  1. Change to the singlestoredb-studio-<version> directory.

    cd singlestoredb-studio-<version>
    
  2. Start SingleStore DB Studio from the command line. Use nohup to prevent singlestoredb-studio from terminating when you close your terminal session.

    nohup ./singlestoredb-studio > studio.stdout 2> studio.stderr < /dev/null &