# MySQL + Amazon S3

> Store data as Parquet in S3 Iceberg with Erathos. Sync MySQL data with Erathos, an incremental, no-code pipeline with observability.

Source: https://www.erathos.com/en/pipelines/mysql-amazon-s3
Em português: https://www.erathos.com/pipelines/mysql-amazon-s3

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

With Erathos, you can integrate data from MySQL into Amazon S3 in just a few minutes. Our platform handles the entire data movement process to your data lake and makes it easy to combine that data with other sources. That means your time is focused on what really creates value — extracting insights and making data-driven decisions.

### Which MySQL data does Erathos sync to Amazon S3?

The integration automatically syncs the main MySQL objects:

- **Tables and collections** — structure, records, and metadata
- **Records and documents** — raw data with creation and update timestamps
- **Indexes** — configuration and performance metrics
- **Schemas** — type definitions and relationships
- **Audit logs** — write, update, and delete operations
- **Connections** — user and session metadata

### Why sync MySQL with Amazon S3?

In Amazon S3 with Iceberg, your data is stored as Parquet files with support for time travel and schema evolution — ready to query with Athena, Spark, Trino, or any query engine in your stack. Ideal for low-cost archival and ML feature stores.

### How it works

Erathos connects to MySQL through the official API and syncs your data incrementally — only new or updated records are processed in each run. You choose the sync frequency (from every 5 minutes to daily), which objects to sync, and the destination in Amazon S3. The sync uses automatic partitioning and Parquet file optimization. You choose the sync frequency, the objects to sync, and the target bucket. Each run is logged with full observability: run time, processed rows, errors with context, and alerts via Slack or email.

## MySQL Data in Amazon S3 in Minutes

### MySQL connector ready to use

Connect MySQL to Amazon S3 and automatically export data. Centralize database information for analysis — no spreadsheets, no scripts.

### Full control over your MySQL pipelines

Configure the schedule, frequency, and sync type at the table level. Configure partitioning, file format, and write frequency at the table level. The Iceberg format ensures ACID compliance and schema evolution — without full bucket rewrites.

### End-to-end observability

Stop finding out about MySQL failures when the business team complains. Every run is logged with execution time, rows processed, and error context. Automatic alerts via Slack, Discord, or email as soon as anything deviates from expected — so your data stays fresh for analysis.

## Centralizing MySQL data in Amazon S3 has never been easier

Erathos is a data ingestion platform built for data and engineering teams. With the MySQL connector, you automatically centralize MySQL database tables and objects in Amazon S3 — keeping data always up to date, with full observability into every run and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like MySQL to their data warehouse — with full observability into every run, zero maintenance, and none of the black-box behavior of traditional market tools.

### What MySQL data does Erathos sync to Amazon S3?

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

### How often does Erathos sync data from MySQL to Amazon S3?

You can configure sync frequency from every 5 minutes up to daily, on a per-table basis. Erathos uses incremental synchronization—only new or updated records are processed on each run, keeping the MySQL pipeline efficient and Amazon S3 costs predictable.

### What happens if a MySQL sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial for the MySQL connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect MySQL to Amazon S3 and start syncing right away — no credit card required.