Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

​
Requirement

  • Aurora  cluster connecting to WRITER endpoint

​
Create DB Parameter Group 

On AWS console,  create a DB Parameter Group for your Aurora cluster. This allows you to create a collection of parameters you can later attach to your cluster. Click on Create Parameter Groups, name its group name and description as you like, and hit Save.
Creating a new DB Parameter Group in the AWS RDS console
Edit DB Parameter Group Select that DB Parameter group you made and edit the following parameters:
Editing DB Parameter Group settings for Aurora MySQL binlog

DB Parameter Group parameter values after editing

​
Create DB Cluster Parameter Group

Next step is to create a DB Cluster Parameter Group for your Aurora cluster. This allows you to create a collection of parameters you can later attach to your cluster. First click on Parameter Groups from the left pane, name its group name and description as you like, and hit Save.
Creating a new DB Cluster Parameter Group in the AWS RDS console

​
Edit DB Cluster Parameter Group

Select that DB Cluster Parameter Group you made and edit the following parameters:
Editing DB Cluster Parameter Group binlog settings

DB Cluster Parameter Group updated parameter values

Additional DB Cluster Parameter Group configuration parameters

Saved DB Cluster Parameter Group configuration overview

​
Configure The Instance

Attach the DB Parameter Group to your Aurora cluster. From the list of Aurora clusters, select the Aurora cluster you want to modify. Then click on Modify. You will need to change the DB Parameter Group and the DB Cluster Parameter Group to the one you just created. Finally, click the check box for Apply Immediately, confirm the changes, and Modify.
Modifying the Aurora cluster to attach the new parameter groups

Confirming parameter group changes with Apply Immediately selected

​
Create user for Sync

On your sourceDB, 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;

​
Increase binlog retention

To increase the binlog retention of the DB cluster, use the mysql_rds_set_configuration procedure. You can run the following command and sample parameters on the writer instance to retain the binlog files for 7 days: 
CALL mysql.rds_set_configuration('binlog retention hours', 168);
Last modified on April 20, 2026