AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company runs a production database on Amazon RDS for MySQL. The company wants to upgrade the database version for security compliance reasons. Because the database contains critical data, the company wants a quick solution to upgrade and test functionality without losing any data.
Which solution will meet these requirements with the LEAST operational overhead?
Other
Community
UAnonymous
A
Create an RDS manual snapshot. Upgrade to the new version of Amazon RDS for MySQL.
B
Use native backup and restore. Restore the data to the upgraded new version of Amazon RDS for MySQL.
C
Use AWS Database Migration Service (AWS DMS) to replicate the data to the upgraded new version of Amazon RDS for MySQL.
D
Use Amazon RDS Blue/Green Deployments to deploy and test production changes.
Explanation:
Explanation
Amazon RDS Blue/Green Deployments is specifically designed for database upgrades with minimal downtime and operational overhead. Here's why it's the best choice:
Key Benefits of RDS Blue/Green Deployments:
- Minimal Operational Overhead: Blue/Green Deployments automate the entire upgrade process, including creating a staging environment (Green environment) with the new database version.
- Safe Testing: You can test the upgraded database in the Green environment while the original Blue environment continues to serve production traffic.
- Quick Switchover: Once testing is complete, you can quickly switch traffic to the Green environment with minimal downtime.
- Data Safety: The original Blue environment remains available as a fallback option if issues are discovered.
Why Other Options Are Less Optimal:
A. Create an RDS manual snapshot and upgrade:
- This requires manual intervention and downtime during the upgrade
- No built-in testing capability before switching to production
- Higher operational overhead for managing the process
B. Use native backup and restore:
- Requires creating a new RDS instance with the upgraded version
- Manual restoration process
- Significant downtime during the restore operation
- No easy rollback mechanism
C. Use AWS DMS:
- Requires setting up replication tasks and monitoring
- More complex configuration
- Higher operational overhead compared to Blue/Green Deployments
- Need to manage schema conversion separately
Best Practice for Database Upgrades:
RDS Blue/Green Deployments provide the most streamlined approach for database version upgrades while ensuring data safety and enabling thorough testing before production cutover. This aligns perfectly with the requirement for "quick solution" with "LEAST operational overhead" while handling "critical data" that cannot be lost.
Comments
Loading comments...