MariaDB

MariaDB as a source, MySQL-compatible.

MariaDB, the MySQL-compatible database, as a relational source or sink for BARRY.

Capabilities: Source · Sink

What it does

Reads tables and queries from MariaDB and can also write into it. It is wire-compatible with the MySQL connector and behaves the same way, with support for MariaDB's three-part GTIDs.

Configuration

• Host and port (3306 by default)
• Database
• User / password
• SSL mode

Load strategies

• Full load — reads the whole table or query each run.
• Incremental (watermark) — reads only rows past a high-water mark, such as an id or a modified-timestamp column.
• Binlog change data capture (experimental) — reads the binary log using MariaDB's GTIDs or file positions, streaming inserts, updates and deletes as small batches. Requires the binary log enabled in row format.

Notes

Everything that applies to MySQL applies here; the difference is MariaDB's GTID format, which the connector handles for you.

See also Connections, Transports.