A small municipal IT team needs high availability for a permits dat…

Question

A small municipal IT team needs high availability for a permits database but lacks staff to operate mirrored MySQL on EC2. What should the architect recommend?

Accepted Answer

Prefer a managed Multi-AZ database service such as Amazon RDS or Aurora so AWS handles replication and failover — A tiny IT shop shouldn’t babysit homemade MySQL mirrors. Hand HA to RDS or Aurora Multi-AZ and spend people-time on city services, not failover scripts.

Answer

Build and patch dual EC2 MySQL primaries with handmade failover scripts as the long-term HA plan

Answer

Run MySQL on a single EC2 instance with snapshots only and accept multi-hour recovery as HA

Answer

Store relational permit rows only in S3 objects and parse them with Lambda for every query

A small municipal IT team needs high availability for a permits database but lacks staff to operate mirrored MySQL on EC2. What should the architect recommend?

Short Explanation

Full Explanation