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';