Skip to main content

MySQL Source

MySQL Source enables data synchronization from MySQL to your desired destination.

info

OLake UI is live (beta)! You can now use the UI to configure your MySQL source, discover streams, and sync data. Check it out at OLake UI regarding how to setup using Docker Compose and running it locally.

olake-source-mysql

Now, you can use the UI to configure your MySQL source, discover streams, and sync data.

Create a MySQL Source in OLake UI

Follow the steps below to get started with the MySQL Source using the OLake UI (assuming the OLake UI is running locally on localhost:8000):

  1. Navigate to Sources Tab.
  2. Click on + Create Source.
  3. Select MySQL as the source type from Connector type.
  4. Fill in the required connection details in the form. For details regarding the connection details, refer to the MySQL Source Configuration section on the right side of UI.
  5. Click on Create ->
  6. OLake will test the source connection and display the results. If the connection is successful, you will see a success message. If there are any issues, OLake will provide error messages to help you troubleshoot.

This will create a MySQL source in OLake, now you can use this source in your Jobs Pipeline to sync data from MySQL to Apache Iceberg or AWS S3.

Edit MySQL Source in OLake UI

To edit an existing MySQL source in OLake UI, follow these steps:

  1. Navigate to the Sources Tab.
  2. Locate the MySQL source you want to edit from Active Sources or Inactive Sources tabs or using the search bar.
  3. Click on the Edit button next to the source from the Actions tab (3 dots).
  4. Update the connection details as needed in the form and Click on Save Changes.
caution

Editing a source can break pipeline.

You will see a notification saying "Due to the editing, the jobs are going to get affected".

Editing this source will affect the following jobs that are associated with this source and as a result will fail immediately. Do you still want to edit the source?

olake-source-edit-2

  1. OLake will test the updated source connection once you hit confirm on the Source Editing Caution Modal. If the connection is successful, you will see a success message. If there are any issues, we will provide error messages to help you troubleshoot.

Jobs Associated with MySQL Source

In the Source Edit page, you can see the list of jobs that are associated with this source. You can also see the status of each job, whether it is running, failed, or completed and can pause the job from the same screen as well.

olake-source-associated-job-1

Delete MySQL Source in OLake UI

To delete an existing MySQL source in OLake UI, follow these steps:

  1. Navigate to the Sources Tab.
  2. Locate the MySQL source you want to delete from Active Sources or Inactive Sources tabs or using the search bar.
  3. Click on the Delete button next to the source from the Actions tab (3 dots).

olake-source-delete-2

  1. A confirmation dialog will appear asking you to confirm the deletion.
  2. Click on Delete to confirm the deletion.

olake-source-delete-1

This will remove the MySQL source from OLake.

note

You can also delete a source from the Source Edit page by clicking on the Delete button at the bottom of the page.

MySQL to Iceberg Data Type Mapping

When syncing data from MySQL to Iceberg, OLake handles data type conversions to ensure compatibility. Below is a table that outlines how MySQL data types are mapped to Iceberg data types:

MySQL Data TypesIceberg Data Type
int, int unsigned, mediumint, mediumint unsigned, smallint, smallint unsigned, tinyint, tinyint unsignedint
bigint, bigint unsignedbigint
float, decimal(10,2)float
double, double precision, realdouble
datetime, timestamptimestamp
char, varchar, text, tinytext, mediumtext, longtext, enum, json, bit(1), timestring

Changelog

Expand to review
VersionDatePull RequestSubject
v0.0.214.04.2025https://github.com/datazip-inc/olake/pull/203
v0.0.331.04.2025https://github.com/datazip-inc/olake/pull/250

Need Assistance?

If you have any questions or uncertainties about setting up OLake, contributing to the project, or troubleshooting any issues, we’re here to help. You can:

  • Email Support: Reach out to our team at hello@olake.io for prompt assistance.
  • Join our Slack Community: where we discuss future roadmaps, discuss bugs, help folks to debug issues they are facing and more.
  • Schedule a Call: If you prefer a one-on-one conversation, schedule a call with our CTO and team.

Your success with OLake is our priority. Don’t hesitate to contact us if you need any help or further clarification!