MySQL
MySQL is an open-source relational database.
You can read from MySQL and write to any target supported by Striim. Typically, you will set up data pipelines that read from MySQL in two phases—initial load, followed by continuous replication—as described in Building pipelines from MySQL.
MySQL feature summary
Feature | Initial load with Database Reader | Continuous real-time replication using MySQL Reader | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|
Supported versions and services | |||
MySQL version 5.5 to 8.4 self-managed (for example, installed and managed on-premise or in a cloud VM) | ✔ | ✔ | ✔ |
Amazon Aurora for MySQL | ✔ | ✔ | ✔ |
Amazon RDS for MySQL | ✔ | ✔ | ✔ |
Azure Database for MySQL | ✔ | ✔ | ✔ |
Google Cloud SQL for MySQL | ✔ | ✔ | ✔ |
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 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 |
Flow Designer | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ |
Runtime | |||
output stream event type | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | by JDBC driver | configurable automatic retries | by JDBC driver |
recovery | ✓ | ✓ | ✓ |
parallel threads | ✓ | ✓ | |
metrics & auditing | ✓ | ✓ | ✓ |