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