1 Answer
- Newest
- Most votes
- Most comments
1
- First question, what’s the requirement?
- Is there a budget?
- What’s the balance of reads and writes to the database?
- Is there an RTO?
- have you considered Aurora Postgres?
One gives you a warm standby while the other gives you 2 read replicas with failover.
Multi AZ instance Support high availability for your application with automatic database failover that completes as quickly as 60 seconds with zero data loss and no manual intervention
Multi AZ Cluster This is a database cluster with one primary and two readable standby instances. It provides up to 2x faster transaction commit latency and automated failovers, typically under 35 seconds.
Here’s a good article to read https://aws.amazon.com/blogs/aws/amazon-rds-multi-az-db-cluster/
Relevant content
- Accepted Answerasked 2 years ago
- Accepted Answerasked 2 years ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 years ago
- How do I end long-running queries in my Amazon RDS for PostrgreSQL or Aurora PostgreSQL DB instance?AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
How is cost? Does Cluster cost us more?
Please use the pricing calculator for an accurate price of both options https://calculator.aws/#/