Posted On: May 10, 2018

Amazon Aurora with MySQL compatibility now offers a quick way to recover from user errors, such as dropping the wrong table or deleting the wrong row. Backtrack allows you to move your database to a prior point in time without needing to restore from a backup, and it completes within seconds, even for large databases.

When you enable Aurora Backtrack in the RDS management console, you specify how long to retain data records, and you pay for the space these records use. For example, you could set up Backtrack to allow you to move your database up to 72 hours back. Read the AWS blog for an overview, and refer to the Aurora documentation for more details.

Backtrack is also useful for development & test, particularly in situations where your test deletes or otherwise invalidates the data. Simply backtrack to the original database state, and you're ready for another test run.

Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. See the AWS Region Table for complete regional availability.