MariaDB
MariaDB is an open source relational database that was forked from MySQL. MariaDB is a single instance database, while MariaDB XPand is a distributed database. SkySQL is MariaDB’s fully-managed database-as-a-service cloud offering.
You can read from MariaDB, MariaDB XPand and SkySQL as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from MariaDB in two phases—initial load, followed by continuous replication—as explained in this concept article on Pipelines.
For initial load, you can use Database Reader to create a point-in-time copy of the existing source MariaDB dataset at the target.
After the initial load has completed, you can start continuous replication by continuously reading the new data created in the same MariaDB dataset after the initial load was started, and then writing this new source data to the target.
For real-time continuous replication of new source data using CDC, you can use MariaDB Reader or MariaDB XPand Reader.
If you choose not to enable CDC on the source database, you can use Incremental Batch Reader to read the new source data at regular intervals, allowing for continuous updates in near real-time. Incremental Batch Reader differs from the CDC readers in several ways, including not capturing DELETE operations at the source (see the discussion in Incremental Batch Reader about INSERT, UPDATE, and DELETE operations).
Supported versions and services
Striim supports reading from the following MariaDB database services:
MariaDB service | initial load using Database Reader | Continuous replication using MySQL CDC Reader | Continuous replication using MariaDB CDC Reader | Continuous replication using MariaDB XPand CDC Reader | Continuous replication using Incremental Batch Reader |
|---|---|---|---|---|---|
MariaDBv5.5 to v10.0.1 | ✔ | ✔ | ✔ | ||
MariaDBv10.02 and later | ✔ | ✔ | ✔ | ||
MariaDB Galera Clusterv10.0.2 and later | ✔ | ✔ | ✔ | ||
MariaDB XPandv5.3.x and v6.0.x | ✔ | ✔ | ✔ | ||
SkySQLv5.3.x and v6.0.x | ✔ | ✔ | ✔ | ||
Amazon RDS for MariaDB | ✔ | ✔ | ✔ |
Striim UI wizards
You can read from MariaDB using the wizards on the Striim UI:
Automated data pipelines
Initial Load only
CDC only