Connect MySQL data with any data source.

Replicate any source into MySQL without custom pipelines.

Load data into MySQL Read the docs

Sources: 590+
Standard support: 1.1.1

Overview

What is the Airbyte MySQL connector?

The Airbyte MySQL connector loads data from 590+ Airbyte sources into MySQL, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into MySQL from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the MySQL connector on Cloud, OSS, Hybrid.

Setup

Live in ten steps

First, you need to have a MySQL database set up and running. Ensure that you have the necessary credentials to access the database.
Log in to your Airbyte account and navigate to the "Destinations" tab.
Click on the "Add Destination" button and select "MySQL" from the list of available connectors.
Enter the necessary details such as the host, port, username, password, and database name. Ensure that the details are accurate and match the credentials you have for your MySQL database.
Test the connection to ensure that Airbyte can successfully connect to your MySQL database. If the connection is successful, you will receive a confirmation message.
Once the connection is established, you can configure the settings for your MySQL destination connector. You can choose to enable or disable certain features such as SSL encryption, bulk loading, and more.
You can also set up the schema mapping for your MySQL database. This involves mapping the fields from your source data to the corresponding fields in your MySQL database.
Once you have configured the settings and schema mapping, you can start syncing data from your source to your MySQL database. You can choose to run the sync manually or set up a schedule for automatic syncing.
Monitor the sync process to ensure that data is being transferred accurately and efficiently. You can view the sync logs and troubleshoot any issues that may arise.
Congratulations! You have successfully connected your MySQL destination connector on Airbyte and can now start syncing data from your source to your MySQL database.

Configuration fields

MySQL Destination configuration fields
Field	Type	Description
database*	string	Name of the database.
host*	string	Hostname of the database.
port*	integer	Port of the database.
username*	string	Username to use to access the database.
disable_type_dedupe	boolean	Disable Writing Final Tables. WARNING! The data format in _airbyte_data is likely stable but there are no guarantees that other metadata columns will remain the same in future versions
jdbc_url_params	string	Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
password	string	Password associated with the username.
raw_data_schema	string	The database to write raw tables into

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

MySQL connector questions

What data can I load into MySQL with Airbyte?

Airbyte moves data from any supported source into MySQL on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the MySQL connector support incremental sync?

Yes. The MySQL destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the MySQL connector?

Run the MySQL connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales