MySQL

Sync your MySQL tables into Airfold and run analytics on them.
Get Started Now

3 Reasons to Connect Your MySQL

  1. Sync tables in real-time
    Keep your data up-to-date by streaming MySQL tables instantly into queryable destinations. Capture every row insertion, update, and deletion as they occur, eliminating delays from manual exports.
  2. Unlock the value of existing MySQL tables
    Use the data already stored in your MySQL databases without rebuilding pipelines. Select tables or schemas and start querying them alongside other datasets.
  3. Centralize data across teams
    Access MySQL tables managed by different departments or applications, enabling unified analytics without disrupting existing workflows.

What's Included In The Integration?

  • Real-time table ingestion
    Map MySQL tables directly to query-ready destinations.
  • SSL/TLS encryption
    Secure connections with enterprise-grade encryption and MySQL-compatible authentication.
  • Change Data Capture (CDC) via binary logs
    Track row-level changes in real-time using MySQL’s native binary log (binlog) for low-latency replication.
  • Schema synchronization
    Automatically detect and apply schema changes (e.g., new columns, modified data types) to keep destinations in sync.
  • Resilient error handling
    Built-in retries for transient network issues or database hiccups.
  • Initial full-load support
    Optionally backfill historical data before enabling continuous CDC.
  • Monitoring dashboards
    Track replication progress, latency, and row throughput.

How to Set It Up

  1. Log in to your account.
  2. Click Create Source and select MySQL from the integrations list.
  3. Provide connection details:
    • Hostname and port
    • MySQL username and password
    • Enable SSL if required.
  4. Choose databases and tables to replicate.
  5. Configure ingestion settings:
    • Enable Initial Full Load to backfill existing data.
    • Toggle Enable CDC to start replicating ongoing changes.
  6. Click Save and Start. The integration will begin syncing data immediately.m

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Want to talk to an Airfold expert?

30 minute advisory call with no strings attached.