How do I enable binary logging for my Amazon Aurora MySQL cluster?

Last updated: 2019-11-07

I want to replicate an Amazon Aurora MySQL cluster to an external MySQL-compatible database, or I want to create a cross-region replica. How do I enable binary logging for an Aurora MySQL DB cluster?

Resolution

To replicate to an external MySQL-compatible database or to create a cross-Region replica, you must enable binary logging for your Aurora MySQL DB cluster. When you enable binary logging on Aurora, the recovery time after a crash can take longer. This is because the recovery performs a full binary log recovery on the writer instance. The duration of the crash recovery varies based on your configuration and workload. For more information, see Amazon Aurora DB Clusters.

To enable binary logging for an Aurora DB cluster, follow these steps:

  1. Open the Amazon Relational Database Service (Amazon RDS) console.
  2. In the navigation pane, choose Parameter groups.
    Note: If you're using the default Aurora DB cluster parameter group, then create a new DB cluster parameter group. For Type, choose DB Cluster Parameter Group.
  3. Select the DB custom cluster parameter group, choose Parameter group actions, and select Edit.
  4. Change the value for the binlog_format parameter, for example to ROW, Statement, or MIXED.
  5. Choose Save changes.

If you created a new DB cluster parameter group in step 2, attach the parameter group to your DB cluster:

  1. Open the Amazon RDS console.
  2. In the navigation pane, under Clusters, choose Modify.
  3. Update the DB Cluster Parameter Group to the new DB cluster parameter group, and then choose Apply immediately.
  4. Choose Continue, and choose Modify cluster.

After you perform these steps, you must reboot the writer instance in the Aurora DB cluster for your changes to apply. When you reboot the writer instance, all the readers in the DB cluster are also rebooted.