Description |
MySQL is the world's most popular open source database |
Type |
CDC/Binlog Replication |
Supported Replication |
Initial Sync Continuous Sync |
Authentication Type |
Password Authentication |
Setting up MySQL CDC for ELT & CDC
Overview
ELT & CDC uses binlog replication for MySQL database source.
Supported providers
Requirements
- MySQL versions 5.7.x or above.
- Tables with
PRIMARY KEY
. - Superuser access for creating a user for syncing. The created sync user itself will only need read only access to the database.
Features
Feature
|
Supported | Notes |
Full (Historical) sync | Yes | |
Incremental sync
|
Yes | |
Replicate DELETE
|
Yes | |
UPSERT | Yes | |
Append only mode
|
Yes |
Can be specified at a table level
|
Exclude tables
|
Yes | |
Exclude columns
|
Yes | |
SSL Support
|
Yes | |
Secure tunnel
|
Yes | Supported on AWS Secure VPN Tunnel for RDS and Redshift |