MariaDB Agent for Gluesync: Key Features & Support

MariaDB CDC logo

Core principles

This agent establishes a connection to MariaDB via a built-in JDBC driver.

Change data capture

This agent implements the scraping of Bin log’s transaction logs by connecting to your master, slave or MaxScale instances depending on the desired configuration.

Supported version

With this agent, you can target any version of MariaDB.

Platform supported features

Feature Support Notes

Target role

✅

Streams data to MariaDB via the built-in JDBC driver with TLS, pooling and DBaaS compatibility.

Source role

✅

Scrapes Binlog events from master, replica or MaxScale nodes over TCP sockets.

Snapshots

✅

Works with Core Hub snapshot tasks for initial loads and ad-hoc refreshes.

CDC

✅

Continuously captures Binlog changes for near real-time replication.

CDC type

Transaction logs (Binlog)

Uses MariaDB/MySQL binary log streaming semantics.

Bulk load

✅

Supports staging-table Bulk load workflows for high-volume mirroring into MariaDB.

Database pooling

✅

Supports connection pooling for efficient resource utilization across multiple pipelines.

Source persisted internal cache

✅

Local ArenaCache (from 2.2.11.2). See Source-side cache.

Target persisted internal cache

N/A

Writes are flushed directly to MariaDB without additional local caching.

Driver / connector

Built-in JDBC driver

Vendor-certified JDBC driver bundled with Gluesync, MariaDB official driver.

Chains

N/A

Not yet supported.

Truncate operation support (reading)

✅

Source agent can capture and forward TRUNCATE operations to the target.

Truncate operation support (writing)

✅

Target agent honors the Core Hub “TRUNCATE before snapshot” option when enabled.

Change data capture

Works with MariaDB starting from 10.11+

Q&A

I am connecting towards an AWS RDS instance, is it supported? Yes, it is. MariaDB RDS instances are supported as well as AWS Aurora MySQL-compatible instances. Remember to enable SSL connection during agent’s setup phase.

I have got MariaDB running under a managed DBaaS offered from AWS | CGP | Azure | OCI | …​, is it supported? Yes, they are. Just make sure you have enabled transaction logs - Bin log - redaction support.

Video Tutorial

Real time data integration between MariaDB 10.11 to Snowflake 9.15