If you have experience with restoring an Aurora database, you’ll likely be aware that restoring a snapshot onto a new cluster can take almost an hour.Rolling back with Backtrack instead is a matter of seconds, and you can roll back to the exact second you wish as well.Again if you previously ran into any other dependency issues they will also likely be fixed since the sources repository was not previously updating from the default install of Back Track. live in the So Bro neighborhood of Louisville, KY with my daughter and our cat Apollo.The new backtracking feature within Amazon Aurora allows a user to "rewind" a database (DB) cluster to within one second of a specified point in time.
This new feature facilitates developers in undoing mistakes like deleting data inappropriately or dropping the wrong table.
However, backtracking provides the following advantages over traditional backup and restore: the DB cluster can be backtracked to a time before a destructive action with minimal interruption of service; backtracking a DB cluster doesn't require a new DB cluster, and instead "rewinds" the DB cluster in minutes; earlier data changes can easily be explored -- users can repeatedly backtrack a DB cluster back and forth in time to help determine when a particular data change occurred.
Amazon announced the backtrack feature for Aurora two weeks ago, which currently only works for My SQL databases.
During the use of the database cluster, Aurora will leverage a distributed, log-structured storage system; each change to any of the databases will generate new log records, which are identifiable by a so-called Log Sequence Number (LSN).
Moreover, these LSNs are stored in the buffer, allowing quick access and recovery.