MySQL

Learn the steps for ingesting your MySQL data into your target.

Steps

1. Enable CDC for your source MySQL database.

2. Create a connection to your source MySQL database.

3. Create a connection to your target (see the Supported Targets list below for links).

4. Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift Amazon S3 AWS Glue Data Catalog ClickHouse Elasticsearch Polaris Catalog PostgreSQL Snowflake
Replication Job Create a replication job to ingest into multiple target schemas	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake
Single Entity Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a single entity job that auto-creates a sub-job for each source table to copy data to the target table	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake

No-code Wizard

Alternatively, you can use the Upsolver no-code Wizard to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.

---

Related Content

Quickstarts

• Create a MySQL Connection

• Ingest CDC Data from Your MySQL Database

How To Guides

• Create and Maintain Connections to Your MySQL Database
• Enable CDC on Your MySQL Database
• Replicate CDC Data to Multiple Schemas in Your Targets

Reference

• Connection Options for MySQL

• Ingestion Job Options for MySQL

• Replication Job Options for MySQL

Articles

• Ingest Data Using CDC
• Performing Snapshots
• MySQL Binlog Retention