Which database configuration meets these requirements MOST cost-effectively?
An Aurora PostgreSQL global database cluster
An Aurora PostgreSQL DB cluster that has a single DB instance
An Aurora PostgreSQL DB cluster that has a primary DB instance and a read replica
Two Aurora PostgreSQL DB clusters, with each DB cluster in a separate Availability Zone
Explanations:
An Aurora PostgreSQL global database cluster is designed for cross-region replication and high availability. Since the application does not require high availability, this option is more complex and costly than necessary for the given requirements.
An Aurora PostgreSQL DB cluster with a single DB instance meets the requirement for data storage in multiple Availability Zones when configured properly. This option is cost-effective as it provides the necessary data storage without unnecessary features or complexity.
An Aurora PostgreSQL DB cluster with a primary DB instance and a read replica incurs additional costs for the read replica. Since the application does not require high availability, this setup is more expensive than needed for the stated requirements.
Two Aurora PostgreSQL DB clusters in separate Availability Zones would provide redundancy and availability, but this configuration is costly and unnecessary since the application does not require high availability. It is more expensive than using a single cluster configured across multiple AZs.
From what I’ve heard, the answer is:
An Aurora PostgreSQL DB cluster that has a single DB instance