Which MySQL database option would meet these requirements?

By:
On:
In: DBS-C01
Tagged:
With: 0 Comments
A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier.The database is used primarily during business hours with random activity peaks throughout the day.A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS.

Which MySQL database option would meet these requirements?

Amazon RDS for MySQL with Multi-AZ

Amazon Aurora Serverless MySQL cluster

Amazon Aurora MySQL cluster

Amazon RDS for MySQL with read replica

Explanations:

Amazon RDS for MySQL with Multi-AZ provides high availability but does not necessarily reduce costs, as it involves running a standby instance in a separate AZ.

Amazon Aurora Serverless MySQL is cost-effective for variable workloads, automatically scaling capacity based on demand, making it ideal for random activity peaks.

Amazon Aurora MySQL cluster offers high performance and availability, but it may not be as cost-effective for workloads with unpredictable peaks and low activity periods.

Amazon RDS for MySQL with read replicas improves read scalability but does not address availability or reduce costs for fluctuating workloads.

Leave a Reply

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

fourteen − 9 =