Which solution will meet these requirements?

By:
In: SAP-C01
Tagged:
With: 1 Comment
A company’s solutions architect is managing a learning platform that supports more than 1 million students.The company’s business reporting team is experiencing slow performance while extracting large datasets from the database.The learning application is based on PHP and runs on Amazon EC2 instances that are in an Amazon EC2 Auto Scaling group behind an Application Load Balancer (ALB).Application data is stored in an Amazon S3 bucket and in an Amazon RDS for MySOL database.The ALB is the origin of an Amazon CloudFront distribution.The solutions architect observes that slow read operations for SELECT queries are affecting the RDS for MySOL DB instance’s CPU utilization.The solutions architect must find a scalable solution to improve the slow website performance with near-zero downtime.The solution also must provide automatic failover with no data loss.

Which solution will meet these requirements?

Create an incremental database backup by using Percona XtraBackup. Compress the backup files. Synchronize the backup files to Amazon S3. Restore the backup files from Amazon S3 to Amazon Aurora MySOL. Direct the application endpoint to the new Aurora DB instance.

Convert the DB instance to a Multi-AZ deployment. Set the query_cache_type parameter on the database to zero. Increase the CloudFront caching TTL to reduce application server CPU utilization.

Create an Amazon Aurora read replica from the DB instance. Wait until the read replica is synchronized with the source DB instance. Promote the read replica to a standalone DB cluster. Direct the application endpoint to the new Aurora DB instance.

Create a read replica cluster on the DB instance. Use a Multi-AZ deployment. Synchronize the read replica with the primary DB instance. Promote the read replica as the primary DB instance.

Explanations:

This option involves using Percona XtraBackup to create an incremental backup and restore it to Amazon Aurora MySQL, which could result in significant downtime and data loss during the migration process. It does not ensure near-zero downtime or automatic failover.

Converting the DB instance to a Multi-AZ deployment would provide failover capabilities, but it does not address the underlying issue of slow read operations. Increasing the CloudFront caching TTL could reduce CPU utilization but may not significantly improve database performance.

Creating an Amazon Aurora read replica addresses the slow read operations by offloading read queries from the primary DB instance. Promoting the read replica to a standalone DB cluster allows for minimal downtime and provides a smooth transition. This solution also supports automatic failover, ensuring no data loss.

Creating a read replica cluster does not directly imply a Multi-AZ deployment. While it can provide read scaling, it lacks the automatic failover aspect unless explicitly promoted and could still involve downtime during the transition to the new primary instance.

2025-09-28

1 Comment

  1. Karen
    Author

    I chart that the answer is:
    Create an Amazon Aurora read replica from the DB instance. Wait until the read replica is synchronized with the source DB instance. Promote the read replica to a standalone DB cluster. Direct the application endpoint to the new Aurora DB instance.

Leave a Reply

Your email address will not be published. Required fields are marked *

nineteen − 3 =