MariaDB

Artie writes to MariaDB with its MySQL destination. Select MySQL as the destination in the Artie dashboard and enter your MariaDB connection details. There is nothing MariaDB-specific to configure.

Required settings

Host name
Port (default is 3306)
Service account

Creating a service account

CREATE USER 'artie' IDENTIFIED BY 'password';

-- Allows Artie to merge data, create and alter destination tables, and clean up
-- its temporary tables.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO 'artie';

Destination database routing

Like MySQL, MariaDB treats schemas and databases as the same thing. Routing to one database or to multiple databases works exactly as described in MySQL destination database routing, including the database-scoped grants.

MariaDB differences

JSON columns are stored as `LONGTEXT`

Artie creates JSON columns for source JSON, struct, and array values. In MariaDB, JSON is an alias for LONGTEXT with a json_valid check constraint, so SHOW CREATE TABLE and INFORMATION_SCHEMA.COLUMNS show these columns as longtext. Artie still recognizes them as JSON columns, and MariaDB’s JSON functions such as JSON_EXTRACT work on them as usual.

FAQ

Which MariaDB versions are supported?

Artie supports MariaDB 10.6, 10.11, and 11 or higher.

Getting Started

Pipelines

Connectors

Monitoring

Artie Dashboard

Required settings

Creating a service account

Destination database routing

MariaDB differences

JSON columns are stored as `LONGTEXT`

FAQ

Which MariaDB versions are supported?

​Required settings

​Creating a service account

​Destination database routing

​MariaDB differences

​JSON columns are stored as LONGTEXT

​FAQ

​Which MariaDB versions are supported?

Required settings

Creating a service account

Destination database routing

MariaDB differences

JSON columns are stored as `LONGTEXT`

FAQ

Which MariaDB versions are supported?