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

enable-binary-logging-aurora-frank

How do I enable binary logging for my Amazon RDS DB instance running Amazon Aurora?

You might need to enable binary logging for your Aurora DB instance in order to replicate to an external MySQL-compatible database, or to create a cross-region replica.

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

  1. (Optional) If you're using the default Aurora DB cluster parameter group, create a new DB cluster parameter group.
  2. In the Parameter Groups pane of the Amazon RDS console, select the DB custom cluster parameter group and choose Edit Parameters.
  3. Change the parameter binlog_format to any value other than OFF, and then choose Save Changes.
  4. (Optional) If you created a new DB cluster parameter group in step 1, attach the parameter group to your DB cluster by selecting the cluster in the Clusters pane of the RDS console, choosing Modify Cluster, updating DB Cluster Parameter Group to the new DB cluster parameter group, and then choosing Apply Immediately.

After you've performed the above steps, you must reboot all the instances in the Aurora DB cluster for your changes to take effect.


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