RDS vs. EC2
Amazon RDS Costs
Amazon RDS Performance Insights
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!
- 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
Snapshots in RDS are your backups of your database tables and instances, and these snapshots can then be exported out of Amazon RDS, to Amazon S3. You might want to do this perform analysis of the data held within your database using more specific tools, for example, Amazon Athena, which is an interactive query service that allows you to perform analysis on data that you have stored in Amazon S3 using a standard SQL.
You could also use other services, such as Amazon SageMaker and Amazon Elastic Map Reduce (EMR), however, the point is, the data can be exported from your RDS database to S3 for further in-depth analysis as required.
Also, during an export of a snapshot, you can decide, through filtering, to simply export specific databases, tables, or even schemas.
The cost associated with performing snapshot exports are again based on a region by region basis. The example here shows the costs for the Ireland Region when using MySQL and is based upon a cost per GB of snapshot
For additional security and protection of your exported data, you can encrypt the data using the Key Management Service (KMS). As a result, additional KMS costs would be incurred depending on the KMS key selected. For more information on the Key Management Service, please see our existing course here: https://cloudacademy.com/course/amazon-web-services-key-management-service-kms/
Also, you will also be charged costs associated with Amazon S3 for the storage and your PUT requests. For more information on how Amazon S3 costs are calculated, please see our existing course here: https://cloudacademy.com/course/understanding-optimizing-costs-with-aws-storage-services/
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.