AWS Database Options

There’s an AWS database solution for just about any project you can imagine: the trick is properly understanding the job each of them does best.

Got data? There’s an AWS database with your name on it.

Importing an existing MySQL, Oracle, Microsoft SQL, or PostgreSQL database into Amazon’s Relational Database Service (RDS), or building your own relational or NoSQL database from scratch is only the very beginning. And don’t forget the preview version of Amazon Aurora – the fifth member of the AWS database family (SQL branch) available to customers through Amazon RDS.

But there are AWS database offerings whose purpose can be downright mysterious to anyone without the background to appreciate it. So I am going to summarize all the many AWS database options, listing each one’s key benefits and some possible use cases.

AWS database: Relational Database Service (RDB)

Amazon’s RDS is a cloud service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and scalable capacity while handling time-consuming database management tasks, freeing you to focus on your applications and business.

Key benefits of RDB

  • Gives you access to the capabilities of a familiar MySQL, Oracle, SQL Server, or PostgreSQL database engine.
  • Scripts, applications, and tools you already use with your existing databases can be used with Amazon RDS.
  • Automatically patches the AWS database software and backs up your data.
  • You can scale the compute resources or storage capacity associated with your RDB instance through a single API call.
  • Two distinct but complementary replication features: Multi-AZ deployments and Read Replicas.
  • Simple and fast to deploy.
  • Simple and fast to scale.
  • Fast, predictable performance.
  • No cost to get started – pay only for what you consume.

When you may want to use an RDB

Deploying a highly available (HA), scalable web application can be complex and expensive. RDB can provide you with a relatively straightforward and inexpensive solution. To provide high availability, you simply select Multi-AZ (Multiple Availability Zones) for your AWS database during configuration.

AWS database: DynamoDB

Amazon DynamoDB provides fast and flexible NoSQL database services for apps requiring consistent, low latency at any scale. It’s fully managed and supports both document and key-value data models.

Key Benefits of DynamoDB

  • Predictable, scalable, and low-cost performance.
  • Easy to set up and manage.
  • Automatically spreads data among servers to match capacity needs.
  • Automatically and synchronously replicates data across multiple Availability Zones within an AWS Region.
  • Supports both key-value and document data models.
  • Doesn’t require a schema (data is accessed through primary keys).

When you may want to use DynamoDB

Back-end infrastructures for online games can be difficult to maintain and anticipating usage peaks and heavy write operations are complex to manage. Amazon DynamoDB allows persistent access to player data no matter how large your player population grows. You can enjoy predictable performance with seamless scalability.

Amazon ElastiCache

ElastiCache lets you deploy and scale a cloud-based in-memory cache. ElastiCache supports two caching engines: Memcached (distributed memory caching) and Redis (key-value cached and store).

Key Benefits of ElastiCache

  • Monitors, and in case of failure, replaces nodes.
  • Improves web application performance by reducing disk reads.
  • Compatible with many existing applications.

When you may want to use ElastiCache

Amazon ElastiCache is particularly useful for read-heavy applications like social networking, media sharing, and gaming, or for compute-intensive workloads.

Amazon Redshift

Amazon Redshift is a petabyte-scale data warehouse service that can analyze data using existing business intelligence packages.

Key Benefits of Amazon Redshift

  • Performs parallel queries across multiple nodes.
  • Works with PostgreSQL, ODBC, and JDBC drivers.
  • Execution speed scales up with cluster size.
  • Automatically incrementally backed up to Amazon S3.
  • Fast data restores via background spooling.
  • Built-in security.
  • Adds analytic functions to applications.
  • Cost effective over traditional enterprise data warehouse solutions.

When you may want to use Redshift

If your app receives significant request volumes from users (think online content providers like newspapers), you can greatly speed up query response and reduce infrastructure costs.

Amazon SimpleDB

Amazon SimpleDB lets you store and query data items through its cloud-optimized and flexible non-relational data store architecture.

Key Benefits of Amazon SimpleDB

  • Simple streamlined lookup and query functionality.
  • Since you don’t need to pre-define your stores with any data formats, you can essentially add or modify attributes on the fly.
  • Deeply integrated with Amazon EC2 and Amazon S3.
  • Pay only for what you use.

When you may want to use Amazon SimpleDB

If you’re into writing code for simple mobile games, SimpleDB can be perfect for integrating multi-platform mobile devices.

Relational databases on Amazon EC2

Developers may use a number of powerful relational databases on Amazon EC2. An Amazon EC2 instance can be used to run an online database, and the data can be stored within an Amazon EBS volume.

Key Benefits of Amazon EC2

  • Amazon EBS provides fast and reliable persistent storage.
  • Provisioning can be fast and efficient using pre-built Amazon EC2 Relational Database AMIs.

When you may want to use Amazon EC2

If you wanted to quickly deploy a WordPress site using an Amazon Machine Image (AMI), then this is the database option you would most likely want to use. You can simply select the AMI of your choice and all the heavy lifting would be done for you. Your database will live on an EC2 instance and the data would probably be stored within an Amazon EBS volume.

Once again AWS has left nothing out of its database family (not even big data management solutions like AWS Machine Learning). Whether you need a relational database service with minimal administration; a fast, highly scalable, non-relational database service; an easy-to-operate in-memory cache; a fast petabyte-scale data warehouse; or a relational database you can manage on your own, you will surely find a suitable solution somewhere within AWS.

Avatar

Written by

Michael Sheehy

I have been UNIX/Linux System Administrator for the past 15 years and am slowly moving those skills into the AWS Cloud arena. I am passionate about AWS and Cloud Technologies and the exciting future that it promises to bring.


Related Posts

Alisha Reyes
Alisha Reyes
— July 2, 2020

New Content: AWS, Azure, Typescript, Java, Docker, 13 New Labs, and Much More

This month, our Content Team released a whopping 13 new labs in real cloud environments! If you haven't tried out our labs, you might not understand why we think that number is so impressive. Our labs are not “simulated” experiences — they are real cloud environments using accounts on A...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Joe Nemer
Joe Nemer
— June 19, 2020

Kickstart Your Tech Training With a Free Week on Cloud Academy

Are you looking to make a jump in your technical career? Want to get trained or certified on AWS, Azure, Google Cloud Platform, DevOps, Kubernetes, Python, or another in-demand skill?Then you'll want to mark your calendar. Starting Monday, June 22 at 12:00 a.m. PDT (3:00 a.m. EDT), ...

Read more
  • AWS
  • Azure
  • cloud academy content
  • complimentary access
  • GCP
  • on the house
Alisha Reyes
Alisha Reyes
— June 11, 2020

New Content: AZ-500 and AZ-400 Updates, 3 Google Professional Exam Preps, Practical ML Learning Path, C# Programming, and More

This month, our Content Team released tons of new content and labs in real cloud environments. Not only that, but we introduced our very first highly interactive "Office Hours" webinar. This webinar, Acing the AWS Solutions Architect Associate Certification, started with a quick overvie...

Read more
  • AWS
  • Azure
  • DevOps
  • Google Cloud Platform
  • Machine Learning
  • programming
Rebecca Willis
Rebecca Willis
— June 3, 2020

Azure vs. AWS: Which Certification Provides the Brighter Future?

More and more companies are using cloud services, prompting more and more people to switch their current IT position to something cloud-related. The problem is most people only have that much time after work to learn new technologies, and there are plenty of cloud services that you can ...

Read more
  • AWS
  • Azure
  • certification
Alisha Reyes
Alisha Reyes
— June 2, 2020

Blog Digest: 5 Reasons to Get AWS Certified, OWASP Top 10, Getting Started with VPCs, Top 10 Soft Skills, and More

Thank you for being a valued member of our community! We recently sent out a short survey to understand what type of content you would like us to add to Cloud Academy, and we want to thank everyone who gave us their input. If you would like to complete the survey, it's not too late. It ...

Read more
  • AWS
  • Azure
  • blog digest
  • Certifications
  • Cloud Academy
  • OWASP
  • OWASP Top 10
  • Security
  • VPCs
Alisha Reyes
Alisha Reyes
— May 11, 2020

New Content: Alibaba, Azure Cert Prep: AI-100, AZ-104, AZ-204 & AZ-400, Amazon Athena Playground, Google Cloud Developer Challenge, and much more

This month, our Content Team released 8 new learning paths, 4 courses, 7 labs in real cloud environments, and 4 new knowledge check assessments. Not only that, but we introduced our very first course on Alibaba Cloud, and our expert instructors are working 'round the clock to create 6 n...

Read more
  • alibaba
  • AWS
  • Azure
  • gitops
  • Google Cloud Platform
  • lab playground
  • programming
Avatar
Rhonda Martinez
— May 4, 2020

Top 5 Reasons to Get AWS Certified Right Now

Cloud computing trends are on the rise and have been for some time already. Fortunately, it’s never too late to start learning cloud computing. Skills like AWS and others associated with cloud computing are in high demand because cloud technologies have become crucial for many businesse...

Read more
  • Amazon Elastic Book Store
  • Amazon Elastic Compute Cloud (EC2)
  • AWS
  • AWS Certifications
  • Glacier
Alisha Reyes
Alisha Reyes
— May 1, 2020

Introducing Our Newest Lab Environments: Lab Playgrounds

Want to train in a real cloud environment, but feel slowed down by spinning up your own deployments? When you consider security or pricing costs, it can be costly and challenging to get up to speed quickly for self-training. To solve this problem, Cloud Academy created a new suite of la...

Read more
  • AWS
  • Azure
  • Docker
  • Google Cloud Platform
  • Java
  • lab playgrounds
  • Python
Alisha Reyes
Alisha Reyes
— April 30, 2020

Blog Digest: AWS Breaking News, Azure DevOps, AWS Study Guide, 8 Ways to Prevent a Ransomware Attack, and More

  New articles by topicAWS Azure Data Science Google Cloud  Cloud Adoption Platform Updates & New Content Security Women in TechAWSBreaking News: All AWS Certification Exams Now Available Online As an Advanced AWS Technology Partner, C...

Read more
  • AWS
  • Azure
  • blog digest
  • Certifications
  • Cloud Academy
  • programming
  • Security
Avatar
Stuart Scott
— April 27, 2020

AWS Certified Solutions Architect Associate: A Study Guide

Want to take a really impactful step in your technical career? Explore the AWS Solutions Architect Associate certificate. Its new version (SAA-C02) was released on March 23, 2020, though you can still take SAA-C01 through July 1, 2020. This post will focus on version SAA-C02.The AWS...

Read more
  • AWS
  • AWS Certifications
  • AWS Certified Solutions Architect Associate
Alisha Reyes
Alisha Reyes
— April 9, 2020

New on Cloud Academy: AWS Solutions Architect Exam Prep, Azure Courses, GCP Engineer Exam Prep, Programming, and More

Free content on Cloud Academy More and more customers are relying on our technology and content to keep upskilling their people in these months, and we are doing our best to keep supporting them. While the world fights the COVID-19 pandemic, we wanted to make a small contribution to he...

Read more
  • AWS
  • Azure
  • Google Cloud Platform
  • programming
Joe Nemer
Joe Nemer
— April 3, 2020

Breaking News: All AWS Certification Exams Now Available Online

Remote proctoring for all AWS certifications Cloud Academy is an Advanced AWS Technology Partner, and we are happy to announce all AWS certification exams are available online!  What does this mean for you? You can stay focused on your certification goal. Or you can start a certifica...

Read more
  • AWS
  • AWS certification
  • AWS Certifications