# Replicate your MySQL database to your Data Warehouse

> Replicate MySQL tables to your warehouse via CDC (binlog) or incrementally with Erathos. Reliable pipeline, schema detection. Start free.

Source: https://www.erathos.com/en/connectors/mysql
Em português: https://www.erathos.com/connectors/mysql

MySQL is an open-source relational database management system, widely used to store, organize, and retrieve data in web and enterprise applications.

## From MySQL to your Data Warehouse in minutes

### Plug and play connectors

Connect MySQL with over 100 other plug-and-play integrations. Eliminate time-consuming manual pipelines and consolidate all your data into a single analytical environment, ready to deliver actionable insights.

### Greater control over pipelines

Build MySQL data pipelines quickly: select the relevant data, configure schedule, frequency, and update type without writing a single line of code. Choose between incremental sync or CDC via binlog depending on your use case, with total flexibility.

### Edge observability

Monitor your MySQL pipelines with real-time alerts via email, Slack, or Discord. Stop being caught off guard by sync errors and ensure your data is always up to date and reliable.

### Change Data Capture (CDC) via binlog

Capture inserts, updates, and deletes from MySQL directly from the binlog, with no performance impact on the source database. Ideal for teams that need always up-to-date data and a complete history of changes, without relying on traditional incremental polling.

## Replicate MySQL data to your Data Warehouse via CDC or incrementally

Erathos is a complete ELT software that extracts data from MySQL and 100+ other sources through instant integrations. With Change Data Capture (CDC) based on binlog, you capture inserts, updates, and deletes in near real-time, without overloading the source database. With plug & play connectors, you consolidate all your data into a single analytics environment and build a Data Warehouse in minutes.

## MySQL Connector FAQ

### How does MySQL replication work for the Data Warehouse?

Erathos performs incremental or full replication of MySQL to your target Data Warehouse, including tables, schemas, and relationships. Synchronization is configurable by frequency and schedule, with no code.

### Is MySQL data synchronized incrementally?

Yes! MySQL integration via Erathos is incremental by default: only new or changed data is synced on each run. This ensures efficient pipelines, lower processing costs, and data that is always up to date in your Data Warehouse.

### Can I try the MySQL integration for free?

Yes! You can test the MySQL integration free for 14 days. Just connect MySQL as a new source, you’ll have two weeks to validate whether the connector meets your needs before any charges apply.

### Which data warehouses can I send MySQL data to?

With Erathos, you can move data from MySQL to the market’s leading data destinations: BigQuery, Redshift, PostgreSQL, SQL Server, Databricks, and Amazon S3. Just choose a destination and set up the pipeline in minutes, no code required.

### Does Erathos integrate MySQL directly with other systems?

No. Erathos does not perform direct integrations between MySQL and other systems ("point-to-point"). Our focus is to centralize MySQL data in a Data Warehouse, creating a single source of truth so your company can make decisions based on reliable data.

### Does Erathos support Change Data Capture (CDC) for MySQL?

Yes! In addition to traditional incremental sync, Erathos offers binlog-based CDC for MySQL, capturing inserts, updates, and deletes in near real-time, without overloading the source database. It's the recommended option for teams that need always up-to-date data and full change tracking. Binlog configuration on your database (ROW format, FULL image) is detailed in the technical documentation (https://docs.erathos.com/connectors/databases/mysql#cdc-setup).