Configuring SingleStore Tools for Secure Connections
SingleStore Tools support SSL secure connections to protect communications with the SingleStoreDB server.
memsqlctl.configuration file to add the path to the CA certificate file on each host.
hcl The path can be absolute or relative to the node’s base directory. For example:sslCaFile = path/to/ca-file
Note that this setting is especially required when a host contains one or more nodes with the
rootuser set to
In newer versions of SingleStoreDB (7.
1. 17+ and 7. 3. 4+),
memsqlctland therefore SingleStore Tools establish SSL connections by default unless the connection fails because of misconfiguration or invalid credentials.
In these versions, set the
ssl_engine variable to the path to the CA certificate file on each node.
ca The file path can be absolute or relative to the node’s base directory. If
ssl_is not set, publicly trusted system certificates will be used.
Last modified: June 22, 2022