High Availability in RDS
Amazon RDS Performance Insights
DynamoDB Backup Capabilities
The course is part of this learning path
This section of the SysOps Administrator - Associate learning path introduces you to the AWS database services relevant to the SOA-C02 exam. We will understand the service options available and learn how to select and apply AWS database services to meet specific design scenarios relevant to the exam.
- Understand the various database services that can be used when building cloud solutions on AWS
- Learn how to build databases using Amazon RDS, DynamoDB, Redshift and Elasticache
- Learn how to perform database backups across different services
- Understand how to implement database solutions with high availability in mind
- Understand the methods and techniques that can be used to enhance performance across your databases
Hello, and welcome to this lecture looking at how to restore your Amazon DynamoDB tables from an existing backup, whether this is an automatic backup to be used as a future point-in-time recovery, or from a manual on-demand backup.
During a restore, you have the ability to change some configuration settings, such as restoring with or without secondary indexes, restoring to a different region, or encrypting your database using a KMS key. Let me now jump straight into a demonstration showing you some of these configurable options, both on how to restore using the point-in-time recovery function, in addition to a restore from an existing manual on-demand backup. Let's take a look.
As you can see, I'm in the DynamoDB dashboard of the AWS Management Console, and we're gonna be looking at how to restore from an existing backup, both the points-in-time recovery and also a manual backup. So if we take a look at our table again, and then if we go across to the Backup tab, we have our point-in-time recovery and also our manual backups as well.
So let's start with restoring from a manual backup. So this was the backup we took in the previous lecture. Now, to restore from this back up all we need to do is to select the backup and then click Restore backup. We can give this a new table name. So let's call this ManualRestore, and you can either restore the entire table data or restore it without the secondary indexes.
Now, you have the option to restore within the same region or to a different region. For this demonstration, I'm just going to leave it in the same region. And also you can change the encryption type as well, using KMS, either a custom-managed CMK or an AWS-managed CMK. I'm just gonna leave it as default, but you have the option to encrypt your restored database as well.
Now, once you've finished selecting those options simply click on Restore table. Now, as you can see here under our list of tables we have our new table being restored and we called it ManualRestore. So that'll take a few minutes to restore, so let me pause the video and we'll come back in just a moment.
Okay, our new table has now been created, and if we go to the items, then we can see the five products as well. So that's how you restore to a new table from an existing manual backup. So let's now restore from a point-in-time recovery. So let's say, for example, in the original table I accidentally deleted four of the items and I needed to get them back.
So what I can do, I can use a point-in-time recovery. So if I go across to Backups, here we can see both the earliest restore date and also the latest restore date. So I can restore to any point-in-time between those two dates and times. So let me now do that. So if I click on Restore to point-in-time, again, I can have a new table name. Let's call this point-in-time recovery restore. This is the latest restore date and time I can choose.
Let's go back six minutes. So this is the point in time that I want to restore to. And remember, this value here can be between the earliest restore date and the latest restore date. Now I want to restore the entire table data within the same region and using the same encryption type. So it's the same options as the restore from the manual backup. And then click on Restore table. So again, this is gonna take a little bit of time, so I'm just gonna pause the video here and then start it back up when it's complete.
Okay, the restore is now complete. Here is our new table. And if we go across to the items, then we can see that we have restored the table back with the four products that I accidentally deleted. So as you can see, it's very straightforward to restore from both a manual backup and also restoring using the point-in-time recovery feature.
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 150+ courses relating to Cloud reaching over 180,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.