Which approach should the Database Specialist take to reduce downtime?

Last Updated on September 18, 2021 by Admin 3

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.

Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.

Which approach should the Database Specialist take to reduce downtime?

  • Deploy multiple read replicas and have the team members make changes to separate replica instances
  • Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
  • Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
  • Enable the Amazon RDS for MySQL Backtrack feature
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments