Add a New Client Host
On this page
Overview
In the following example:
-
The default domain and realm are
S2.
LOCAL -
The Key Distribution Center (KDC) server is on
10.
1. 0. 5 -
The Kerberos admin server is on
10.
1. 0. 5
Install Kerberos Tools and Obtain a Ticket
-
Install the
krb5-user
tools.Red Hat
sudo yum install krb5-userDebian
sudo apt install krb5-user -
Enter the domain that will be connected to the default Kerberos realm.
-
Enter the Kerberos authentication server.
-
Enter the administrative server.
-
The
[realms]
section in the/etc/krb5.
file on this host will now resemble the following.conf [realms]S2.LOCAL = {kdc = 10.1.0.5admin_server = 10.1.0.5default_domain = s2.local} -
Obtain a ticket for a user that exists in the cluster.
kinit user1@S2.LOCALPassword for user1@S2.LOCAL:
klistTicket cache: FILE:/tmp/krb5cc_1000 Default principal: user1@S2.LOCAL Valid starting Expires Service principal 09/28/22 10:46:12 09/28/22 20:46:12 krbtgt/S2.LOCAL@S2.LOCAL renew until 09/29/22 10:46:08
Connect to SingleStoreDB
Install SingleStore Client
Red Hat Distribution
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.
-
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 -
Verify that the SingleStore repo information is listed under
repolist
.sudo yum repolist -
Verify that the
which
package installed.This is used during the install process to identify the correct package type for your installation. rpm -q whichIf
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.sudo yum install -y which -
Install the SingleStore client.
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.
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
Debian Distribution
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.
-
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
.wget -O - 'https://release.memsql.com/release-aug2018.gpg' 2>/dev/null | sudo apt-key add - && apt-key list -
Verify that
apt-transport-https
is installed.apt-cache policy apt-transport-httpsIf
apt-transport-https
is not installed, it must be installed before proceeding.user-shell sudo apt -y install apt-transport-https -
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 -
Install the SingleStore client.
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.
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
Tarball
Download the SingleStore Client
Download the SingleStore client tarball file onto a host that can access the main deployment host.
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.singlestore
command to be run from anywhere on the filesystem, even after an upgrade by updating the symlink.
-
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.ln -s singlestore-client-<version>-<commit-hash> singlestore-client -
Verify that the symlink has been created.
ls -lsinglestore-client -> singlestore-client-1.0.6-c3803db03b
-
Update the
PATH
environment variable with the path to the newsinglestore-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. export PATH=/home/<user>/singlestore/singlestore-client:$PATH -
You may now run the
singlestore
command from anywhere on the filesystem.singlestore
Connect using the SingleStore Client
-
For a package-based installation of the SingleStore client.
singlestore -h<hostname> --plugin-dir=/usr/lib/singlestore-client/plugin/ -u<username> -
For a tarball-based installation of the SingleStore client.
singlestore -h<hostname> --plugin-dir=/path/to/singlestore-client/plugin/ -u<username>
Last modified: January 9, 2023