Unanswered Questions
-
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?
Exercise:
- 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.