A company wants to migrate its on-premises MySQL database to AWS. The database receives frequent imports from a client-facing application, resulting in a high volume of write operations that may be degrading application performance. How should a solutions architect design the architecture on AWS?
Choose an answer
Tap an option to check your answer.
Correct answer: Provision an Amazon RDS for MySQL DB instance with Provisioned IOPS SSD storage. Monitor write operation metrics by using Amazon CloudWatch. Adjust the provisioned IOPS if necessary..
Why this is the answer
The correct option addresses the core problem of high write operations impacting performance. Amazon RDS for MySQL with Provisioned IOPS SSD storage is designed for I/O-intensive workloads, allowing you to specify a consistent IOPS rate to handle frequent writes. Monitoring with CloudWatch enables you to track performance and scale IOPS as needed. General Purpose SSD storage (incorrect option) might not provide sufficient performance for consistently high write volumes. Placing ElastiCache in front (incorrect option) primarily helps with read scaling, not write performance. Amazon DocumentDB (incorrect option) is a NoSQL database and not a direct migration path for MySQL, nor does it inherently solve high write performance for a relational database use case. Amazon EFS (incorrect option) is a shared file system, not a relational database service, and is unsuitable for migrating a MySQL database.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed