{"id":653,"date":"2017-10-19T10:12:40","date_gmt":"2017-10-19T10:12:40","guid":{"rendered":"http:\/\/wiki.thomasandsofia.com\/?p=653"},"modified":"2017-10-20T02:50:47","modified_gmt":"2017-10-20T02:50:47","slug":"rds-backups-and-scaling","status":"publish","type":"post","link":"https:\/\/wiki.thomasandsofia.com\/?p=653","title":{"rendered":"RDS Backups and Scaling"},"content":{"rendered":"

https:\/\/www.udemy.com\/aws-certified-solutions-architect-associate\/learn\/v4\/t\/lecture\/4782126?start=0<\/a><\/p>\n

Automated Backups<\/h2>\n

Automated Backups allow you to recover your database to any point in time within a “retention period”. Retention period can be between 1 and 35 days.\u00a0 (Default 7 Days.)\u00a0 Automated Backups will take a full daily snapshot and will also store transaction logs throughout the day.\u00a0 When you do a recovery, AWS will first choose the most recent daily backup, then apply transaction logs relevant to that day.\u00a0 This allows you to do a “point in time” recovery down a second, within the retention period.<\/p>\n

Automated Backups are enabled by default.\u00a0 The backup data is stored in S3 and you get free storage space equal to the size of your database.\u00a0 So if you have an RDS instance of 10GB, you will get 10GB worh of storage.<\/p>\n

Backups are taken within a defined window.\u00a0 During the backup window, storage I\/O may be suspended while your data is being backed up and you may experience elevated latency.<\/p>\n

DB Snapshots<\/h2>\n

DB Snapshots are done manually.\u00a0 They are stored even after you delete the original RDS instance, unlike automated backups.<\/p>\n

Whenever you restore either an Automated Backup or a manual Snapshot, the restored version of the database will be a new RDS instance with a new endpoint (domain?).<\/div>\n

 <\/p>\n

Encryption<\/h2>\n

Encryption at rest is supported for MySQL, Oracle, SQL Server, PostgreSQL & MariaDB.\u00a0 Encryption is done using AWS Key Management Service (KMS).\u00a0 Once an RDS instance is encrypted, the data stored at rest in the underlying storage is encrypted, as are its automated backups, read replicas and snapshots.<\/p>\n

You cannot directly encrypt an existing DB instance.\u00a0 Instead, create a new instance with encryption enabled, then migrate your data into it.<\/p>\n

Restoring an RDS Database<\/h2>\n