Singlestore
Summary
This document covers the information to gather from Singlestore in order to configure a Qarbine data service. The data service will use the Qarbine MongoDB API driver. You can define multiple data services that access the same Singlestore endpoint though with varying credentials. Once a data service is defined, you can manage which Qarbine principals have access to it and its associated Singlestore data. A Qarbine administrator has visibility to all data services.
Several example catalog components use a data service named “Singlestore Kai”.
Overview
Qarbine currently supports the MongoDB personality of Singlestore. SingleStore Kai™ is an API that offers compatibility and a performance alternative for applications built on MongoDB®. It provides a fast, easy, and powerful API that enables analytics on MongoDB data applications without any query changes, application migration, or data transformations. For detailed compatibility information and functional differences, it’s recommended to consult the Singlestore’s Kai page at https://www.singlestore.com/kai.
Singlestore Configuration
Qarbine requires the SingleStore Kai connection string and optionally a database to configure a data service using the MongoDB API driver. The connection string for a SingleStore Kai-enabled workspace can be accessed from the SingleStore Cloud Portal.
Navigate to the Cloud Portal at https://portal.singlestore.com/
Select your workspace of interest.
Under Action heading click
Next, choose Connect Directly. If the API is enabled for your workspace, you will find the connection string under the MongoDB Client tab.
The connection string will be in the following format:
mongodb://<user>:<password>@svc-XXX-mongo.YYY.svc.singlestore.com:27017/
?authMechanism=PLAIN&tls=true&loadBalanced=true
Adjust the user and password values in the connection string. Ensure that the loadBalanced=true parameter is included in the connection string, as it is critical for authentication and connectivity.
For more detailed information, you can refer to the SingleStore documentation on Getting Started with SingleStore Kai at
https://docs.singlestore.com/cloud/reference/singlestore-kai/getting-started-with-singlestore-kai/#access-the-api
General information can be found at
https://docs.singlestore.com/cloud/reference/singlestore-kai/getting-started-with-singlestore-kai/
Once you have the connection string then refer to the MongoDB API Access document for further steps.