Skip to main content

​
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

Set the following properties in the MySQL configuration file (typically available in the /etc/mysql/ directory). 
[mysqld]
log_bin = mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800
binlog_row_image = FULL
net_read_timeout = 3600
net_write_timeout = 3600
wait_timeout = 86400
Confirm your changes by checking the binlog status, 
SHOW GLOBAL VARIABLES LIKE 'log_bin';
Last modified on April 20, 2026