Ensure that Backtrack feature is enabled for your Amazon Aurora with MySQL compatibility database clusters in order to backtrack your clusters to a specific time, without using backups. Backtrack is an AWS Relational Database Service (RDS) feature that allows you to specify the amount of time that an Aurora MySQL database cluster needs to retain change records so that you can have a fast way to recover from user errors, such as dropping the wrong table or deleting the wrong row by moving your MySQL database to a prior point in time without the need to restore from a recent backup. The feature is currently supported only by Aurora MySQL 5.6 database engine.
Once the Backtrack feature is enabled, Amazon RDS can quickly "rewind" your Aurora MySQL database cluster to a point in time that you specify. In contrast to the backup and restore method, with Backtrack you can easily undo a destructive action, such as a DELETE query without a WHERE clause, with minimal downtime, you can rewind your Aurora cluster in just few minutes, and you can repeatedly backtrack a database cluster back and forth in time to help determine when a particular data change occurred.
To determine if your Amazon Aurora MySQL-compatible database clusters are using the Backtrack feature, perform the following actions:
To enable Backtrack feature for an existing Amazon Aurora MySQL database cluster, you have to re-create the cluster and configure the feature during setup. To implement backtracking for your Aurora database cluster, perform the following: