Automated Backup & Snapshot:
- Automated Backup enables poin-in-time recovery
- Automated Backups => AWS RDS performs a full daily snapshot of your and captures transaction logs (this is updated whenever db changes)
- Automated Backup is Enabled when Backup Retention Period is enabled
- DBSnapshot => Full daily snapshot
Read Replica will not be enabled if Daily Backup Retention is zero days.
While Creating a Read-Replica other Region also can be selected to make it a cross region replication.
After Read Replica is created it looks like
Read Replica will take only SQL Read queries and will be to able to allow write queries when it is promote and replication will be lost.
Scenario of Read Replica
Why Amazon Promotes Aurora?
- Create a Multi AZ db.t2.micro mysql database which is accesible publically in Region A(us-west-2 oregon)
- Now try to create a read replica in other region Region B (us-east-1 N.Virginia)
- Represent the work done in a image.