QuestionQ63

VerifiedDesign Cost-Optimized Architectures

A company has an on-premises MySQL database that the global sales team uses, with infrequent access patterns. The sales team requires minimal downtime for the database. A database administrator wants to migrate this database to AWS without choosing a specific instance type in anticipation of more users in the future.

Which service should a solutions architect recommend?

Explanation

Amazon Aurora Serverless for MySQL is the best fit because it supports MySQL compatibility while avoiding the need to choose a fixed DB instance class up front. Aurora Serverless is intended for variable or infrequent usage patterns and automatically adjusts database capacity as demand changes, which aligns with expected future growth. By contrast, Amazon RDS for MySQL and provisioned Amazon Aurora MySQL require selecting DB instance classes, and Amazon Redshift Spectrum is an analytics feature for querying data in Amazon S3 rather than a managed MySQL transactional database service.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!