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.
I infer that the answer is:
Amazon Aurora Serverless MySQL cluster