MySQL

MySQL is an open source relational database that is behind many applications, being one of the most popular databases in the world. The data integration from MySQL to the Data Warehouse created by Kondado allows you to replicate your tables and views to your analytical cloud, in a comprehensive or incremental way (capturing only new and updated data).

Adding the data source

To automate the ETL from MySQL with Kondado to your database, follow the steps below:

Whitelist the Kondado IPs on the database server (and on your VPC) for the port that will be used to connect with MySQL (usually 3306)
On the Kondado platform, go to the page to add data sources and select the MySQL data source
Give a name to your data source and fill in your database information

Now just save the data source and start integrating your MySQL data into the Data Lake or Data Warehouse.

Tables and Views

With our integration, you will be able to integrate tables and also views

If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your integration can be incremental

It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique

The table created will have a similar format to the one below:

Field   Type
col_x   text
col_y   float
col_z   date

Add MySQL as a Data Source on Kondado

Configure MySQL as a source in Kondado to replicate tables and views to your Data Warehouse or Data Lake.

Whitelist Kondado IPs

Allow Kondado's IP addresses through your database server and VPC firewall for the MySQL port (typically 3306). This secure connection is part of Kondado's security practices.

Select MySQL on the platform

On the Kondado platform, navigate to the data sources page and choose MySQL from the available connectors.

Configure connection details

Name your data source and enter your database host, port, credentials, and database name.

Define primary key and sync mode

Set the primary key (can be composite) and choose between full or incremental replication. For incremental sync, identify a datetime/timestamp column that tracks when records are inserted or updated.

Save and start integration

Save the data source to begin replicating your MySQL tables and views to your Data Warehouse or Data Lake.

Frequently asked questions

What types of MySQL objects can I integrate with Kondado?▼

You can integrate both tables and views from your MySQL database. All columns will be replicated with appropriate data types (text, float, date, etc.) to your destination.

How does incremental replication work for MySQL?▼

If your table has a datetime or timestamp column that records when each row was inserted or last modified, Kondado can use it to capture only new and updated records—reducing sync time and load. You must also define a primary key (single or composite) so Kondado can uniquely identify each record.

What port does Kondado use to connect to MySQL?▼

The default port is 3306, though your setup may differ. You need to whitelist Kondado IPs on both your database server and VPC for the configured port.

Can I send MySQL data to a BI tool instead of a Data Warehouse?▼

Yes. Once your MySQL data is in Kondado, you can route it to various destinations. For example, explore connecting MySQL to Google Data Studio or other visualization tools.

Is MySQL on Kondado compatible with MariaDB?▼

Yes—MySQL and MariaDB share protocol compatibility, so the same connector generally works for both. Kondado explicitly references MySQL (& MariaDB) in several pipeline templates.

Written by

Thassyo Pereira·Published 2023-08-02·Updated 2026-04-25