Ref: https://learn.cantrill.io/courses/1820301/lectures/41301425 and https://learn.cantrill.io/courses/1820301/lectures/41301426
- When taking a snapshot, it's a good idea to include the DB engine and the DB version in the snapshot name
- Multi-AZ deployment & creation of a standby replica are recommended for PROD usage
- Primary instance will be left untouched for backups, also provides resilience vs primary AZ outage
- Backup windows defined upon instance creation, can also adjust later in instance settings
- When creating a standby replica (Multi-AZ), we can create it immediately, or in the next backup window
- if immediately, there can be outages
- creation of a standby replica & configuring synchronous replication will take some time
- An RDS instance can be rebooted with failover if a standby replica is configured
- After restoring a snapshot, the new instance will take time to be available
- ❗ Once available, the app (in the EC2 instance) must update its configuration to point to the new RDS instance!