02 - High Availability Approaches for Databases Flashcards
1
Q
High Availability Approaches for Databases
A
- If possible, choose DynamoDB over RDS because of inherent fault tolerance
- If DynamoDB cannot be used, choose Aurora because of Redundancy and Automatic recovery features
- If Aurora cannot be used, choose Multi-AZ RDS
- Frequent RDS snapshots can protect against data corruption or failure - and they will not impact performance of multi-AZ deployments (from standby instance or read replica)
- Regional replication is also an option, but it will not be strongly consistent
- If database is on EC2, you will have to design HA on your own
