SingleStore Source

About

SingleStore is a distributed SQL database built to power intelligent applications. It is both relational and multi-model, enabling developers to easily build and scale applications and workloads.

SingleStore is built around Universal Storage which combines in-memory rowstore and on-disk columnstore data formats to deliver a single table type that is optimized to handle both transactional and analytical workloads.

Available Tools

{{< list-tools >}}

Requirements

Database User

This source only uses standard authentication. You will need to create a database user to login to the database with.

Example

Basic

By default, connections use tls=preferred, which enables SSL/TLS if the server supports it and falls back to unencrypted otherwise.

kind: source
name: my-singlestore-source
type: singlestore
host: 127.0.0.1
port: 3306
database: my_db
user: ${USER_NAME}
password: ${PASSWORD}
queryTimeout: 30s # Optional: query timeout duration

With SSL required

kind: sources
name: my-singlestore-source
type: singlestore
host: svc-abc123.svc.singlestore.com
port: 3306
database: my_db
user: ${USER_NAME}
password: ${PASSWORD}
connectionParams:
  tls: "true" # Require TLS and verify the server certificate

With SSL verification disabled

kind: sources
name: my-singlestore-source
type: singlestore
host: svc-abc123.svc.singlestore.com
port: 3306
database: my_db
user: ${USER_NAME}
password: ${PASSWORD}
connectionParams:
  tls: "skip-verify" # Require TLS but skip server certificate verification

Without SSL

kind: sources
name: my-singlestore-source
type: singlestore
host: 127.0.0.1
port: 3306
database: my_db
user: ${USER_NAME}
password: ${PASSWORD}
connectionParams:
  tls: "false" # Disable TLS

{{< notice tip >}} Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file. {{< /notice >}}

Reference