I have an Amazon Aurora MySQL-Compatible Edition DB cluster, and I want to backtrack my instance to a time that I specify.
Short description
You can choose to turn on backtrack when you create your Amazon Aurora DB cluster. If you have an existing cluster and you want to turn on backtrack, first create a new cluster from a snapshot of your Amazon Aurora cluster. Then, turn on backtrack during the cluster creation process.
There are some limitations when you use the backtrack feature:
- Backtracking is supported for select Aurora MySQL-Compatible versions. You can't use backtrack with Amazon Aurora PostgreSQL-Compatible Edition instances.
- Backtracking isn't available in these AWS Regions: Africa (Cape Town), China (Ningxia), Asia Pacific (Hong Kong), Europe (Milan), Europe (Stockholm), Middle Easy (Bahrain), and South America (São Paulo).
- You can't use backtrack with Amazon Aurora multi-master clusters.
- Backtracking isn't supported with binary log (binlog) replication. This means that cross-Region replication must be turned off before you can configure or use backtracking.
- The maximum limit for a backtrack window is 72 hours.
- Backtracking is applied to the cluster as a whole. So, you can't use backtracking for a single data update or for specific tables. You must update the entire cluster.
Resolution
Follow these steps to turn on backtrack in your Aurora MySQL-Compatible DB cluster.
1. Create an Aurora MySQL-Compatible cluster.
2. In the Backtrack section of your cluster configuration, select the check box to Enable Backtrack.
3. For Target Backtrack window, choose the number of hours that you want to configure for your Backtrack window. This determines how far back in time you can backtrack the cluster. Enter a number in hours up to 72 hours.
You can also modify the backtrack window at a later date, or turn backtrack off entirely by modifying your cluster.
If you created an Aurora cluster without turning on the backtrack feature, you must first restore a snapshot of the Aurora cluster. Then, use the steps in this article to turn on backtrack during the snapshot restore/cluster creation process.
Related information
Amazon Aurora backtrack - turn back time