Dedicated Admin Connections
To log in to a dedicated admin connection, you should first log in to the machine where the master aggregator is running.
Then execute:
singlestore -u root --socket '/<installationpath>/data/memsql.sock' -p
Note
You can use either the SingleStore command-line tool or the MySQL command line tool.
This uses a Unix domain socket to designate that this is a dedicated admin connection.
Once you log in, if commands do not run, you can kill connections and queries to free resources to allow others to connect to the system.
A similar approach will also allow you to log on to a leaf node directly, if necessary.
Here is an example of how to setup a dedicated admin connection:
sh-4.4# cd /var/lib/memsqlsh-4.4# ls5871bce2-e2fa-4934-ad92-5fb842c74fef a36fb148-c8e2-4132-a7cd-c7694e43336d nodes.hcl nodes.hcl.locksh-4.4# cd a36fb148-c8e2-4132-a7cd-c7694e43336d/sh-4.4# lsauditlogs data memsql.cnf plancache tracelogssh-4.4# cd datash-4.4# lsblobs ingest_staging memsql_id memsqld.pid roots staging_bottomlessdatetime_to_version logs memsql_proxy.sock memsqld_safe.pid snapshots tempblobsephemeral_errors memsql.sock memsql_role persisted_errors spill temprestoreblobssh-4.4# ls -tla memsql_proxy.socksrwxrwxrwx 1 memsql memsql 0 Nov 4 22:03 memsql_proxy.socksh-4.4# pwd/var/lib/memsql/a36fb148-c8e2-4132-a7cd-c7694e43336d/datash-4.4# singlestore -u root --socket '/var/lib/memsql/a36fb148-c8e2-4132-a7cd-c7694e43336d/data/memsql.sock' -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 58Server version: 5.7.32 MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.singlestore>
The engine variable, max_
Last modified: April 27, 2023