Databases - Backups + Multi-AZ + Read Replicas Flashcards
Types of Backups
Automated Backups, Database Snapshots
Automated Backups
allow you to recover your DB to any point in time within a retention period. they will take a full daily snapshot and will store transaction logs throughout the day
Retention period range
1-35 days, 7 days by default
Recover an automated backup
AWS will choose the most recent daily backup, and then apply transaction logs relevant to that day
Which type of backup is enabled by default?
Automated
Where is the backup data stored?
S3
How much storage will you get?
Free storage space = size of your database
When are backups taken?
within a defined window
What will happen to storage I/O during the backup window?
may be suspended
Are DB snapshots manual or automated?
Manual
When the RDS instance is deleted, what happens to automated backups?
They are deleted.
When the RDS instance is deleted, what happens to DB snapshots?
They are stored
When the RDS instance is deleted, do you have a chance to make one final snapshot?
Yes.
What happens when you restore either an automated backup or a DB snapshot?
the restored version of the DB will be a new RDS instance with a new end point.
Encryption at rest is supported for which DBs?
MySQL, Oracle, SQL Server, PostgreSQL, MariaDB