SingleStore Managed Service

Managed Service Endpoints

To use a stand-alone SQL client or to integrate your application with SingleStore Managed Service, download the TLS/SSL public certificate via the link provided in SingleStore Managed Service. This CA certificate can be used to both verify the identity of each cluster host and establish an encrypted connection. Install the certificate via the instructions provided at How Do I Install a Certificate?.

The Managed Service endpoints are available on the SingleStore Customer Portal. Once logged in, select your cluster, and click on the Connect button for additional connection information.

Then, access SingleStore Managed Service at the available endpoints with SQL clients and/or development tools.

For example, using the MySQL command line (CLI) client, you can connect to the SingleStore Managed Service endpoints using the singlestore_bundle.pem certificate file. Include the --ssl-mode=VERIFY_CA option to verify the certificate. Note: Include the --ssl-mode=REQUIRED option to establish a secure connection in older versions of the MySQL client, even when the --ssl-ca option is specified.

  1. Use the Admin endpoint to run Data Definition Language (DDL)-related operations and work with database schemas, such as ALTER, CREATE, DROP, COMMENT, and SHOW. For example, using the MySQL client: mysql -u admin -p -h <admin-endpoint-host> -P 3306 --default-auth=mysql_native_password -ssl-ca=./singlestore_bundle.pem --ssl-mode=VERIFY_CA

  2. Use the Client endpoint to run Data Manipulation Language (DML)-related operations and work with database data, such as INSERT, SELECT, UPDATE, DELETE, and MERGE. For example, using the MySQL client: mysql -u admin -p -h <client-endpoint-host> -P 3306 --default-auth=mysql_native_password --ssl-ca=./singlestore_bundle.pem --ssl-mode=VERIFY_CA