Amazon Relational Database Service
The course is part of these learning paths
This course explores the different strategies that are available for when you need to both back up and restore your AWS databases across Amazon Relational Database Service (RDS) and Amazon DynamoDB. During this course, you will learn about the different backup features that are available in Amazon RDS and DynamoDB, how to identify the differences between them, and when you should use one over the other. The course also explains how to copy and share RDS snapshots across regions and AWS accounts.
The concepts covered in this course are complemented with guided demonstrations from the AWS platform, to ensure you get a real-world understanding of them. If you have any feedback relating to this course, feel free to get in touch with us at firstname.lastname@example.org.
- Introduce you to the different backup features that are available in Amazon RDS and DynamoDB
- Identify the differences between the different backup features and when you should use one over the other
- Explain how to copy and share RDS snapshots across regions and AWS accounts
This course has been designed for those who are responsible for maintaining AWS database solutions at an operational level. It is also suitable for anyone looking to take the AWS Certified Database Specialty certification.
To get the most out of this course, you should be familiar with Amazon RDS and Amazon DynamoDB at a foundational level. For more information on these databases, please see our existing course here.
Hello, and welcome to this lecture which is going to examine the different backup features and techniques of Amazon DynamoDB. Which are not too distinctively different from that of RDS. DynamoDB utilizes automatic and manual backup options.
So let me start off by looking at the automatic options first. Using DynamoDB you're able to configure point in time recovery which works the same as it does when we discussed it in the audience lecture of this course. However, unlike when configuring this in RDS, you don't need to set up a backup retention period or backup time period. Instead, this is automatically defined.
You can either have point in time recovery enabled or disabled with a simple click from within the AWS Management Console. The retention period for continuous point in time recovery backups is 35 days, meaning you can restore at any point over the previous 35 days.
Point in time recovery really helps to act as an additional security barrier. Should you experience some issues with your tables that may have suffered from accidental or deliberate malicious activity. Should something like this occur, you can restore from any point in time, from the previous 35 days.
If you delete your table you'll still be able to restore your database for the duration of the retention period. When you go to delete your database you are given the option to create a backup before deleting the table as shown in a screenshot. And this final backup will be maintained until you manually delete it and will be classed as a manual on demand backup rather than an automated backup.
Let me now take a look at manual backups known as on demand backups that can be taken with DynamoDB. One of the main benefits that on demand backups has over automatic backups is that they are not limited by the 35 day retention period that exists until you manually delete them. Sometimes this is required to meet certain governance and compliance requirements.
When performing your on-demand backups, you should rest in the comfort that it does not pose any kind of performance throughput impact against your table. Thanks to a unique distributed technology that DynamoDB is built upon. This also enables your backup process to scale which means that your backups can be created in seconds despite how big your database might be in size.
Now, this has the benefit of requiring you not to specify backup windows or schedules. Every time an on-demand backup is taken, a full backup of the entire table is included. Also much like in RDS, you can also use AWS backup to schedule on-demand backups on a regular and recurring basis.
Let me now provide a demonstration on how to both enable and disable automatic backups for point in time recovery in addition to how to run an on-demand backup of your DynamoDB table.
Okay, so currently I'm at the dynamo DB dashboard of the AWS Management console. Now, if I go across to tables, we can see that have a very simple table here. It's only got five items in it, product one, two, three, four, and five, but what I want to do with table is enable automatic backups for the point in time recovery.
Now, to do that, I'll go across to the backups tab. Now at the top here, we see points in time recovery. Now at the moment, the status of this is disabled, but what I want to do is to enable it. So it's very simple simply click on enable, and it will check with you to say do you want to enable point in time recovery on this table? And then just say enable.
Now straight away this will give you the earliest restore date and time. So straight away it's created a backup. Now, if I wanted to disable point in time recovery then I would simply click on disable. So that's very easy to enable or disable point in time recovery. And in the next lecture, I'll show you how to restore from a particular point in time as well. But at the moment in this demonstration, I want to show you how to create a manual backup.
Now, if we scroll down here, we can see on demand, backup and restore. So to create a manual backup, simply click on, create backup, make sure you select the right table and then create a backup name. Just call it my backup, click on create. And it says the backup request was successful. And now if you sit at the bottom here you can see we have a manual backup and the creation time as well. So it's very easy to both enable and disable point in time recovery and also create a manual backup for your DynamoDB tables.
Stuart has been working within the IT industry for two decades covering a huge range of topic areas and technologies, from data center and network infrastructure design, to cloud architecture and implementation.
To date, Stuart has created 90+ courses relating to Cloud reaching over 140,000 students, mostly within the AWS category and with a heavy focus on security and compliance.
Stuart is a member of the AWS Community Builders Program for his contributions towards AWS.
He is AWS certified and accredited in addition to being a published author covering topics across the AWS landscape.
In January 2016 Stuart was awarded ‘Expert of the Year Award 2015’ from Experts Exchange for his knowledge share within cloud services to the community.
Stuart enjoys writing about cloud technologies and you will find many of his articles within our blog pages.