Skip to main content

​
Required settings

  • Host name
  • Port (default is 3306)
  • Service account
  • Database name
  • Database with binlog_format set to ROW
  • Database with binlog retention hours set to at least 24 hours
CREATE USER 'artie_transfer' IDENTIFIED BY 'password';
GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO
'artie_transfer';
To enable binary logging, you will need to update your RDS instance’s parameter group.
To create a new parameter group: navigate to RDS > Parameter groups > click Create.For Aurora clusters, please ensure that you are creating this parameter group as DB cluster parameter group.
  1. Create the parameter group.
  2. Click into the parameter group and modify binlog_format to ROW
  3. Restart your database. Create parameter group Edit binlog format
The default value for binlog retention hours is NULL, which means they are not retained. We recommend setting this to a value that is at least 24 hours.
-- If you are using AWS RDS or Aurora
CALL mysql.rds_set_configuration('binlog retention hours', 24);
-- If you are using Azure
SET GLOBAL binlog_expire_logs_seconds = 604800;
-- You do not need to set this for GCP CloudSQL or generic MySQL

​
Additional features

Please make sure the following settings are enabled:
  • gtid_mode = ON
  • enforce_gtid_consistency = ON
Once this is configured, Artie will automatically use GTID to replicate.
⌘I