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.
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 SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT, LOCK TABLES ON *.* TO 'flydata'@'%';
FLUSH PRIVILEGES;
Enable binary logging
Create a DB Parameter Group and set the following parameters:
| Parameter | Value |
|---|
| binlog_format | ROW |
| binlog_row_image | FULL |
| binlog_expire_logs_seconds | 604800 (Minimum 1 day or 86400) |
| Parameter | Value |
|---|
| net_read_timeout | 3600 |
| net_write_timeout | 3600 |
| wait_timeout | 86400 |
SHOW GLOBAL VARIABLES LIKE 'log_bin';
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 (Minimum 1 day)
CALL mysql.rds_set_configuration('binlog retention hours', 168);
