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 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 described in Building pipelines from MariaDB.
MariaDB feature summary
Feature | Initial load with Database Reader | Continuous real-time replication using MySQL Reader | Continuous real-time replication using MariaDB Reader | Continuous real-time replication using MariaDB XPand Reader | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|---|---|
Supported versions and services | |||||
MariaDB versions 5.5 to 10.0.1 | ✔ | ✔ | ✔ | ||
MariaDB versions 10.02 and later | ✔ | ✔ | ✔ | ||
MariaDB Galera Cluster versions 10.0.2 and later | ✔ | ✔ | ✔ | ||
MariaDB XPand versions 5.3.x and 6.0.x | ✔ | ✔ | ✔ | ||
SkySQL versions 5.3.x and 6.0.x | ✔ | ✔ | ✔ | ||
Amazon RDS for MariaDB | ✔ | ✔ | ✔ | ||
Security and governance | |||||
SSL / TLS | ✔ | ✔ | |||
connection profile | |||||
Operations | |||||
initial load | ✓ | ||||
initial schema creation | with supported targets | ||||
schema evolution | ✓ | ✓ | |||
DML operations replicable in target | INSERT, UPDATE, DELETE, TRUNCATE | INSERT, UPDATE, DELETE, TRUNCATE | INSERT, UPDATE, DELETE, TRUNCATE | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | |||||
automated pipelines | ✓ | ✓ | ✓ | ✓ | |
other wizards | initial load only | initial load only, change data capture only | initial load only, change data capture only | initial load only, change data capture only | initial load only |
Flow Designer | ✓ | ✓ | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ | ✓ | ✓ |
Runtime | |||||
output stream event type | WAEvent | WAEvent | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | by JDBC driver | configurable automatic retries | configurable automatic retries | configurable automatic retries | by JDBC driver |
recovery | ✓ | ✓ | ✓ | ✓ | ✓ |
parallel threads | ✓ | ✓ | |||
metrics & auditing | ✓ | ✓ | ✓ | ✓ | ✓ |