Course Introduction
Amazon RDS
RDS vs. EC2
Amazon RDS Costs
Amazon RDS Performance Insights
DynamoDB Basics
DynamoDB
DynamoDB Accelerator
ElastiCache
Neptune
Redshift
Amazon DocumentDB
Amazon Keyspaces
Which database service should I use?
Using Automation to Deploy AWS Databases
Data Lakes in AWS
The course is part of this learning path
This section of the AWS Certified Solutions Architect - Professional learning path introduces you to the AWS database services relevant to the SAP-C02 exam. We then understand the service options available and learn how to select and apply AWS database services to meet specific design scenarios relevant to the AWS Certified Solutions Architect - Professional exam.
Want more? Try a Lab Playground or do a Lab Challenge!
Learning Objectives
- 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, DocumentDB, Keyspaces, and QLDB
- Learn how to create ElastiCache and Neptune clusters
- Understand which AWS database service to choose based on your requirements
- Discover how to use automation to deploy databases in AWS
- Learn about data lakes and how to build a data lake in AWS
Now that we have looked at primary storage and I/O costs for your database, let’s now take a look at what costs you will incur for backups that you take of your database. Firstly, I want to identify which actions and considerations need to be taken into account and that will affect how your backup storage fluctuates:
- The first point I want to make, and it might surprise you, is that Amazon RDS does not charge any backup storage costs that equates to the total sum of provisioned storage used with your databases within a specific region. So for example, Assume you had a MySQL DB with provisioned storage of 150GiB-Month DB, plus a MariaDB DB with 450GiB in a single region. Amazon RDS would not charge you for any storage utilised up to 600GiB-Month.
- Any backup storage used over this ‘free’ tier is charged at $0.10 per GiB-Month, regardless of the region for:
- MySQL
- PostgreSQL
- MariaDB
- Oracle
- SQL Server
- Any backup storage used over this ‘free’ tier for Aurora is charged differently based upon the region. Currently at the time of writing this course, it is $0.022 per GiB-Month in the London region
- Any automated backups taken use backup storage
- Any manual snapshots that are taken of your database will also use backup storage
- By extending your backup retention periods (how long you’d like to keep your backups for) will increase the amount of storage required for backups
- Backup storage is calculated based upon the total amount of backup storage consumed within a specific region across all your RDS databases
- If you copy your backups to another region, this will also increase the amount of backup storage used within that new region
So all in all, backup storage for your RDS databases is relatively simple to calculate and inexpensive bearing in mind it is free to backup 100% of your provisioned database storage.
Let me now move onto Backtrack storage costs with Amazon Aurora.
Danny has over 20 years of IT experience as a software developer, cloud engineer, and technical trainer. After attending a conference on cloud computing in 2009, he knew he wanted to build his career around what was still a very new, emerging technology at the time — and share this transformational knowledge with others. He has spoken to IT professional audiences at local, regional, and national user groups and conferences. He has delivered in-person classroom and virtual training, interactive webinars, and authored video training courses covering many different technologies, including Amazon Web Services. He currently has six active AWS certifications, including certifications at the Professional and Specialty level.