Google Cloud SQL MySQL source for ELT & CDC

Create Read-Replica (optional)

We recommend syncing data using a read-replica of your database to ensure sync doesn’t affect your primary database instance. If you wish to sync against Primary, feel free to skip this step.Refer this documentation to create a read-replica

Create user

Create a sync user for Integrate.io by executing,

CREATE USER 'flydata'@'%' IDENTIFIED BY '<your_password>';

Grant necessary privileges,

GRANT SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT, LOCK TABLES ON *.* TO 'flydata'@'%';
FLUSH PRIVILEGES;

Enable binary logging

Select your database instance in CloudSQL on Google Cloud Platform

Go to Backup

Enable Automated Backups by clicking on Edit and selecting Automate backups and Enable point-in-time recovery options.

Google Cloud SQL backup settings with automated backups and point-in-time recovery enabled

Confirm your changes by checking the binlog status,

SHOW GLOBAL VARIABLES LIKE 'log_bin';

Last modified on June 1, 2026

Azure MySQL source for ELT & CDC

Self-hosted MySQL source for ELT & CDC

⌘I

Getting Started

Pipelines

Sources

Destinations

Monitoring

Security

Transforms

Data Observability

Google Cloud SQL MySQL source for ELT & CDC

Create Read-Replica (optional)

Create user

Enable binary logging

​Create Read-Replica (optional)

​Create user

​Enable binary logging

Create Read-Replica (optional)

Create user

Enable binary logging