Quick Restoration Options for Aurora MySQL DB Cluster
Question
An IT company is planning to deploy a single master Aurora MySQL DB cluster in the us-east-2 region.
Operations Head explores options for a quick restoration that can be used with minimal service impact to the application. Which option should a Sysops Administrator propose to complete restoration quickly?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: C.
For a single master Aurora MySQL DB cluster, backtracking can be enabled during DB cluster creation.
This enables DB clusters to rewind to a specific time.
This is a quick option of restoring a DB cluster to a particular time as compared to restoration using DB cluster snapshots or from backup data.
Option A is incorrect as using AWS Backup to manage backup & restore is a manual DB cluster snapshot & will be more time-consuming in data restoration.
Options B & D are incorrect as this will launch a new DB cluster to a point in time & additional time will be required to restore data.
This would be more time-consuming than using backtrack.
For more information on backup & restoration option with an Amazon Aurora DB cluster, refer to the following URLs,
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.htmlFor a quick restoration of an Aurora MySQL DB cluster with minimal service impact to the application, a SysOps Administrator should propose using Backtrack.
Backtrack is a feature of Aurora MySQL that allows you to rewind the database to a specific point in time without having to restore from a backup. This can be used to quickly restore the database to a previous state, and it can be done without impacting the running applications.
Option A is incorrect because while AWS Backup is a service that can be used to backup and restore Aurora DB clusters, it doesn't support restoring a DB cluster to a specific time.
Option B is also incorrect because while restoring a DB cluster to a point in time using a DB cluster snapshot is possible, it can take some time to complete and can have an impact on running applications.
Option D is incorrect because restoring a DB cluster to a point in time using backup data is also possible, but it can take longer and have a greater impact on running applications compared to using Backtrack.
In summary, Backtrack is the best option for restoring an Aurora MySQL DB cluster quickly with minimal service impact to the application.
