Multi AZ RDS

• Database is Created and Sync automatically in more that one availability zone as shown below
• High-Availability Not a scaling solution
• Basic Failover
• Failovers are automatic when we AWS RDS when
  • AZ outage
  • Primary DB fails
  • DB Instances server type is changed
  • OS is patching
  • A manual failover can be done with Reboot with failover

Perform Read Replications

• Create a Replica with Read Permission (Select Query) in any AZ of the same region
• The Replicated Read RDS instance can allow write when it is promoted

Cross-Region Replications

• Much like Perform Read Replicas

Backups

• Amazon RDS Backup is called as DB Snapshot

• From RDS we can Create a DB Snapshot

• Taking Backups can be manual or Automated

• Restoring from DB Snapshot to DB Instance

• DB Snapshot can be copide and shared

• Export DB Snapshot Data to Amazon S3

• Manual Snapshot

• Snapshot are of different kinds

Automated Backups

• Your DB Instance should be in AVAILABLE state
• Automated Backups can be enable while creating the db or even after db is created. Modify the Database and change the Backup Retention Period

Pending Items

• Create Read Replica is Disabled
• Cross Region Replication
• Automated Backup vs Snapshot
• CLI-Commands