Answer-first summary for fast verification
Answer: Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Use database cloning to create the staging database on-demand.
## Explanation **Correct Answer: B** **Why Option B is correct:** 1. **Amazon Aurora MySQL with Multi-AZ Aurora Replicas** addresses the heavy read activity issue by providing read replicas that can handle read traffic, reducing load on the primary instance. 2. **Database cloning** is a key Aurora feature that creates a new database cluster using a copy-on-write mechanism. This allows the development team to create a staging database instantly without impacting production performance. 3. The clone is created from a snapshot but doesn't require the full data copy initially - it only copies data as it's modified, making it fast and efficient. 4. This solution eliminates the latency issue during database exports and allows the staging environment to be available immediately. **Why Option A is incorrect:** - Using mysqldump for backup/restore would still cause performance issues during the export process, similar to the current problem. **Why Option C is incorrect:** - Using the standby instance for staging would interfere with the Multi-AZ failover capability and could impact production availability. - The standby instance is meant for high availability, not for development/staging workloads. **Why Option D is incorrect:** - Similar to Option A, using mysqldump would still cause performance degradation during exports. - While RDS read replicas help with read scaling, the backup process would still impact production. **Key AWS Services:** - **Amazon Aurora**: Provides better performance than standard RDS MySQL, with up to 5x throughput. - **Aurora Database Cloning**: Creates a new Aurora cluster that shares the underlying storage with the source cluster, using copy-on-write technology for efficient cloning. - **Multi-AZ Aurora Replicas**: Provide read scaling and high availability across Availability Zones.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company runs an on-premises application that is powered by a MySQL database. The company is migrating the application to AWS to increase the application's elasticity and availability.
The current architecture shows heavy read activity on the database during times of normal operation. Every 4 hours, the company's development team pulls a full export of the production database to populate a database in the staging environment. During this period, users experience unacceptable application latency. The development team is unable to use the staging environment until the procedure completes.
A solutions architect must recommend a replacement architecture that alleviates the application latency issue. The replacement architecture also must give the development team the ability to continue using the staging environment without delay.
Which solution meets these requirements?
A
Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Populate the staging database by implementing a backup and restore process that uses the mysqldump utility.
B
Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Use database cloning to create the staging database on-demand.
C
Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas for production. Use the standby instance for the staging database.
D
Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas for production. Populate the staging database by implementing a backup and restore process that uses the mysqldump utility.