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:

FieldValue
Database typeMariaDB
Port3306, MariaDB's default.
Database nameThe 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.

Was this page helpful?