Sources - MySQL

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