|
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 |
