Frank walks you through
enabling the Aurora binlog file
for external replication


I want to replicate a DB cluster to an external MySQL-compatible database, or I want to create a cross-region replica. How do I enable binary logging for my Amazon Relational Database Service (Amazon RDS) DB instance running Amazon Aurora MySQL?

To replicate to an external MySQL-compatible database or to create a cross-region replica, you must enable binary logging for your Aurora DB instance. When you enable binary logging on Aurora, the recovery time after a crash is directly impacted, because it forces the DB instance to perform binary log recovery. For more information, see Amazon Aurora Reliability.

To enable binary logging for all the DB instances in an Aurora DB cluster, follow these steps:

1.    Open the Amazon RDS console.

2.    In the navigation pane, choose Parameter Groups.
Note: If you're using the default Aurora DB cluster parameter group, create a new DB cluster parameter group, and for Type, choose DB Cluster parameter group.

3.    Select the DB custom cluster parameter group, and choose Edit Parameters.

4.    Change the parameter binlog_format to any value other than OFF, and then 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 Cluster.

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've performed these steps, you must reboot the writer instance in the Aurora DB cluster for your changes to apply.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2017-02-06

Updated: 2018-01-24