MariaDB
About
MariaDB is a relational database management system derived from MySQL. It implements the MySQL protocol and client libraries and supports modern SQL features with a focus on performance and reliability.
Note: MariaDB is supported using the MySQL source.
Available Tools
mysql-sqlExecute pre-defined prepared SQL queries in MariaDB.mysql-execute-sqlRun parameterized SQL queries in MariaDB.mysql-list-active-queriesList active queries in MariaDB.mysql-list-tablesList tables in a MariaDB database.mysql-list-tables-missing-unique-indexesList tables in a MariaDB database that do not have primary or unique indices.mysql-list-table-fragmentationList table fragmentation in MariaDB tables.
Requirements
Database User
This source only uses standard authentication. You will need to create a MariaDB user to log in to the database.
Example
sources:
my_mariadb_db:
kind: mysql
host: 127.0.0.1
port: 3306
database: my_db
user: ${MARIADB_USER}
password: ${MARIADB_PASS}
# Optional TLS and other driver parameters. For example, enable preferred TLS:
# queryParams:
# tls: preferred
queryTimeout: 30s # Optional: query timeout duration
Tip
Use environment variables instead of committing credentials to source files.
Reference
| field | type | required | description |
|---|---|---|---|
| kind | string | true | Must be mysql. |
| host | string | true | IP address to connect to (e.g. “127.0.0.1”). |
| port | string | true | Port to connect to (e.g. “3307”). |
| database | string | true | Name of the MariaDB database to connect to (e.g. “my_db”). |
| user | string | true | Name of the MariaDB user to connect as (e.g. “my-mysql-user”). |
| password | string | true | Password of the MariaDB user (e.g. “my-password”). |
| queryTimeout | string | false | Maximum time to wait for query execution (e.g. “30s”, “2m”). By default, no timeout is applied. |
| queryParams | map<string,string> | false | Arbitrary DSN parameters passed to the driver (e.g. tls: preferred, charset: utf8mb4). Useful for enabling TLS or other connection options. |