Documentation Index
Fetch the complete documentation index at: https://docs.summation.com/llms.txt
Use this file to discover all available pages before exploring further.
Summation connects to MySQL and compatible flavors (MariaDB, RDS for MySQL, Aurora MySQL, Cloud SQL for MySQL) using standard host/port credentials.
What you’ll need
- A reachable host and port (default
3306).
- A database name.
- A user with
SELECT on the tables you want exposed. See GRANT Statement in the MySQL docs.
Where to find host/port for your provider
| Provider | Where to look |
|---|
| Amazon RDS / Aurora | RDS console → your DB instance → Connectivity & security. See Connecting to a DB instance running MySQL. |
| Google Cloud SQL for MySQL | Cloud SQL console → your instance → Connections. See About connection options. |
| Azure Database for MySQL | Azure portal → your server → Overview. See Connect and query. |
| Field | Required | Stored as | Notes |
|---|
| Host | Yes | Config | DNS name or IP, e.g. db.example.com. |
| Port | Yes | Config | Default 3306. |
| Database | Yes | Config | The MySQL database (schema) name. |
| Username | Yes | Config | MySQL login. |
| Password | Yes | Secret | |
| SSL Mode | Optional | Config | disabled, preferred, required, verify_ca, or verify_identity. Default required. See --ssl-mode in the MySQL docs. |
| Root Certificate Path | Optional | Config | Path to a CA bundle for verify_ca / verify_identity. See Configuring MySQL to use encrypted connections. |
| Min Pool Size | Optional | Config | Minimum idle connections. Default 10. |
| Max Pool Size | Optional | Config | Maximum concurrent connections. Default 100. |
Setup SQL
CREATE USER 'summation'@'%' IDENTIFIED BY '<strong-password>';
GRANT SELECT ON analytics.* TO 'summation'@'%';
FLUSH PRIVILEGES;
ALTER USER 'summation'@'%' REQUIRE SSL;
Adding datasets
Source references use the form:
mysql:my_database.my_table
Common problems
| Error or symptom | Likely cause |
|---|
Access denied for user | Wrong user, password, or host pattern. Check 'summation'@'%' vs 'summation'@'10.%'. |
SSL connection error | SSL Mode doesn’t match the server. Most managed providers reject disabled. |
| Too many connections | Lower Max Pool Size if the server’s max_connections is low. |