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.
Confirm your changes by checking the binlog status,
SHOW GLOBAL VARIABLES LIKE 'log_bin';