SingleStore (formerly MemSQL) is a distributed, relational SQL database management system known for its speed in data ingest, transaction processing, and query processing.

They have introduced SingleStore KAI, an API that offers compatibility and enhanced performance for applications built on MongoDB.

Using SingleStore with Countly

To use SingleStore in Countly, register in SingleStore Helios Cloud and create your deployment for Countly.

After your deployment is created, click on Connect and select MongoDB client. Then copy the MongoDB connection string and add the password you used when creating deployment in the <password> placeholder.

You can provide this connection string to the Countly server config.js files or as a docker environment variable.

Migrating Data to SingleStore

To migrate data to SingleStore, in the SingleStore portal, go to Data Ingest -> Load Data ->Select MongoDB.

Then, create a new connection for a specific database and provide your connection string.

You need to repeat the same process for all Countly databases that you want to move to SingleStore:

• countly
• countly_drill
• countly_fs
• countly_out

If you want to transfer a large amount of data (more than 1 Tb), please contact support for more help with data transfer.