SingleStore Source
2 minute read
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
SingleStore Source Tools
| Tool Name | Description |
|---|---|
| singlestore-execute-sql | A "singlestore-execute-sql" tool executes a SQL statement against a SingleStore database. |
| singlestore-sql | A "singlestore-sql" tool executes a pre-defined SQL statement against a SingleStore database. |
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
Tip
Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “singlestore”. |
| host | string | true | IP address or hostname to connect to (e.g. “127.0.0.1”). |
| port | string | true | Port to connect to (e.g. “3306”). |
| database | string | true | Name of the SingleStore database to connect to (e.g. “my_db”). |
| user | string | true | Name of the SingleStore database user to connect as (e.g. “admin”). |
| password | string | true | Password of the SingleStore database user. |
| queryTimeout | string | false | Maximum time to wait for query execution (e.g. “30s”, “2m”). By default, no timeout is applied. |
| connectionParams | map[string]string | false | Additional driver parameters appended to the DSN. Supports any go-sql-driver/mysql DSN parameter. Commonly used for SSL configuration (see tls values below). |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.