Skip to main content

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.

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.