MySQL Data Sync

Updated by Devinder Singh

This comprehensive document will walk you through the step-by-step configuration process for MySQL data sync and address specific use cases tailored to MySQL .

Standard Data Sync functionality

Please refer to Data Sync - Getting Started for the standard data sync functionality. The getting started document covers usages of data sync features valid for all integrations.

Configuring PostgreSQL Data Sync

1. Click on 'Create Sync'

2. Pick the app that you want to sync with MySQL

3. Select the MySQL from the dropdown

4. Select the schema from the dropdown

5. Click on 'Next' button

6. Delete any tables that you don't want to sync. If the table you want to sync is not displayed, add it using "Add table" button

7. Select the 'Last updated column' from dropdown

8. Click on 'Next' button

9. Mark any of the field as unique

10. Click on 'Confirm' button

11. Click on 'Save' button

12. Click on 'Start Sync' button

Required MySQL Columns

Auto increment Primary key

You need to have an auto-increment primary key to work with Byteline data sync. It can be created using the below alter statement.

alter table <table name> add <column name> INT NOT NULL AUTO_INCREMENT PRIMARY KEY;

For example: alter table products add ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY;

Last Updated Column
You need to specify Timestamp data type for the last updated column.

The "last updated" column is required for Byteline data sync and other sync tools. So, ensure your data sync works seamlessly by setting up the essential "last updated" column. This column is crucial for identifying modified records that need to be synced. You will configure this column when setting up the data sync, as shown in the below screenshot.

You can use below type on the last updated column

timestamp default now() on update now()

Alter table SQL to add the last updated column

Below is an example SQL to add last updated column

alter table products add last_updated timestamp default now() on update now();

How did we do?