Aurora MySQL Cluster Setup

If you are planning to use Aurora MySQL as your source database for mirroring using a transaction log,  you need to perform an additional installation step on the MySQL server: configure MySQL so that Syniti Replicate can read the database's binary log and set the binary logging to ROW.

To enable binary logging on an Aurora MySQL DB cluster:

1. Create a new DB parameter group and associate it to your DB instance.

2. Set the binlog_format parameter to ROW.
   The binlog_format parameter is a cluster-level parameter that is in the default cluster parameter group.
   If you are changing the binlog_format parameter from OFF to another value, you need to reboot your Aurora DB cluster for the change to take effect.

log_bin=mysql-bin
server_id=1
binlog_format=ROW

3. Restart MySQL.