Amazon 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 DR 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.

  3. Restart the cluster.