Learn the optimal way to rightsize an Amazon RDS for MySQL instance with a read replica to reduce costs while maintaining performance for future growth. Find out whether to modify the primary instance, read replica, or both.
Table of Contents
Question
A company uses an Amazon RDS for MySQL instance. To prepare for end-of-year processing, the company added a read replica to accommodate extra read-only queries from the company’s reporting tool. The read replica CPU usage was 60% and the primary instance CPU usage was 60%.
After end-of-year activities are complete, the read replica has a constant 25% CPU usage. The primary instance still has a constant 60% CPU usage. The company wants to rightsize the database and still provide enough performance for future growth.
Which solution will meet these requirements?
A. Delete the read replica Do not make changes to the primary instance
B. Resize the read replica to a smaller instance size Do not make changes to the primary instance
C. Resize the read replica to a larger instance size Resize the primary instance to a smaller instance size
D. Delete the read replica Resize the primary instance to a larger instance
Answer
B. Resize the read replica to a smaller instance size Do not make changes to the primary instance
Explanation
The key points are:
- The read replica was added temporarily to handle extra read-only queries during end-of-year processing.
- After this period, the read replica CPU usage dropped to a constant 25%, indicating it is now oversized for the workload.
- Meanwhile, the primary instance still has a constant 60% CPU usage, so it is adequately sized for the current workload and anticipated future growth.
Therefore, the company should downsize the read replica to a smaller instance size to reduce costs, since it no longer needs the extra capacity. The primary instance should remain at its current size to maintain adequate performance.
Resizing the primary instance is not necessary since its CPU usage has remained steady at 60%, indicating it is already properly sized. Deleting the read replica altogether would remove the ability to offload read-only queries from the primary instance. And upsizing the read replica is not needed given the low CPU usage.
So in summary, resizing just the read replica to a smaller instance type will allow the company to optimize costs while still providing good performance now and room for future growth.
Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Associate SAA-C03 exam and earn Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification.