MariaDB
MariaDB is its own database type in QueryDesk. It speaks the MySQL protocol, so the schema sync, the table structure view, data protection, transactions and peer reviews work as they do on MySQL. QueryDesk is tested against MariaDB 11.4.
Connect a server
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | MariaDB |
| Port | 3306, MariaDB's default. |
| Database name | The database to query. |
Choose MariaDB, not MySQL: MariaDB has no max_execution_time, so a connection made as MySQL is refused. A mysql:// or mariadb:// connection string pasted under Update with connection string on a MariaDB database keeps the MariaDB type, and ssl-mode=REQUIRED turns on Encryption.
Click Test Connection under the credential to check the connection.
What works differently
- The query timeout is MariaDB's
max_statement_time. A query that runs past the credential's timeout is stopped by MariaDB with "max_statement_time exceeded". - AI read-only runs an AI query in a read-only transaction that is always rolled back, as on MySQL. MariaDB refuses a write there, a function's write included.