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

Vijayakumar Athithan
Vijayakumar Athithan
— March 27, 2020

What is Cognito in AWS?

Web applications usually allow a valid username and password combination for successful sign in to the application. Modern authentication flows incorporate more approaches to ensure user authentication. When using AWS, this is no exception, thanks to the abilities and features offered b...

Read more
  • AWS
  • AWS Cognito
  • Solutions Architect
Connie Benton
Connie Benton
— March 25, 2020

How To Build a Career with AWS Certifications

From Iaas and PaaS solutions to digital marketing, cloud computing reshapes the world of technology. As the influence of this technology grows, so does investment. Tens of billions of dollars are being spent on cloud computing-related services each year. This influx is continuing to inc...

Read more
  • AWS
  • Certifications
Avatar
Andrew Larkin
— March 20, 2020

The 12 AWS Certifications: Which is Right for You and Your Team?

As companies increasingly shift workloads to the public cloud, cloud computing has moved from a nice-to-have to a core competency in the enterprise. This shift requires a new set of skills to design, deploy, and manage applications in cloud computing. As the market leader and most ma...

Read more
  • AWS
  • AWS Certifications
Alisha Reyes
Alisha Reyes
— March 17, 2020

Cloud Academy’s Blog Digest: How Do AWS Certifications Increase Your Employability, How to Become a Microsoft Certified Azure Data Engineer, and more

With everything going on right now, it's likely that the only thing you've been reading lately is related to the coronavirus pandemic. It's important to stay informed during these times, but it's also good to jump into something that can take your mind off of the current situation for j...

Read more
  • AWS
  • Azure
  • blog digest
  • Certifications
  • Cloud Academy
  • programming
  • Security
Avatar
Cloud Academy Team
— March 13, 2020

Which Certifications Should I Get?

As we mentioned in an earlier post, the old AWS slogan, “Cloud is the new normal” is indeed a reality today. Really, cloud has been the new normal for a while now and getting credentials has become an increasingly effective way to quickly showcase your abilities to recruiters and compan...

Read more
  • AWS
  • Azure
  • Certifications
  • Cloud Computing
  • Google Cloud Platform
Alisha Reyes
Alisha Reyes
— March 7, 2020

New on Cloud Academy: Intro to GitOps; AWS Courses; Java, Python, Amazon Linux 2, Ubuntu, & Docker Playgrounds; and much more

New Lab Playgrounds This month, our Content Team released six new "playground labs." Our playground labs provide a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions — all without having to instal...

Read more
  • AWS
  • Azure
  • gitops
  • Google Cloud Platform
  • lab playground
  • programming
Alisha Reyes
Alisha Reyes
— March 6, 2020

New on Cloud Academy: Intro to GitOps; AWS Courses; Java, Python, Amazon Linux 2, Ubuntu, & Docker Playgrounds; and much more

New Lab Playgrounds This month, our Content Team released six new "playground labs." Our playground labs provide a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions — all without having to instal...

Read more
  • AWS
  • Azure
  • gitops
  • Google Cloud Platform
  • lab playground
  • programming
Patrick Navarro
Patrick Navarro
— March 4, 2020

AWS Certifications: How Do They Increase Your Employability and Progress Your Career?

AWS certifications are no walk in the park. They’re designed to validate in-depth, specialist knowledge and comprehensive experience, often requiring months of dedicated studying to earn even for those already working with the cloud platform. But the rewards that AWS professionals ca...

Read more
  • AWS
  • AWS certification
  • certification
Avatar
Chandan Patra
— February 21, 2020

Elasticsearch vs. CloudSearch: AWS Cloud Search Choices

Elasticsearch vs. CloudSearch: What's the main difference? Let's compare AWS-based cloud tools: Elasticsearch vs. CloudSearch. While both services use proven technologies, Elasticsearch is more popular, open source, and has a flexible API to use for customization; in comparison, CloudS...

Read more
  • AWS
  • Azure
  • cloudsearch
  • elasticsearch
Avatar
Andrew Larkin
— February 13, 2020

Cloud Academy Content Roadmap Updates

Welcome to our Q1 2020 roadmap. This is the content we plan to build over the next three months, between February 1 - and April 30, 2020. Let's look at some of our roadmap highlights. Atlassian Bamboo for CI/CD We had a lot of requests for practical guides on how to apply DevOps tool...

Read more
  • Artificial Intelligence
  • AWS
  • Azure
  • Docker
  • Google Cloud Platform
  • Kubernetes
  • Machine Learning
Alisha Reyes
Alisha Reyes
— February 7, 2020

New on Cloud Academy: Git Labs, CKA and CKAD Lab Challenges, AWS and Azure Learning Paths, AGILE, and Much More

We just kicked off our first Free Weekend of 2020. This means we've unlocked our Training Library for just 72 hours. Until Sunday at 11:59 pm (PST), you can get unlimited access to our industry-leading learning paths, courses, certification prep exams, and our most popular hands-on labs...

Read more
  • agile
  • AWS
  • Azure
  • Google Cloud Platform
  • Linux
  • OWASP
  • programming
  • red hat
  • scrum
Avatar
Stuart Scott
— February 6, 2020

How to Encrypt an EBS Volume

Keeping data and applications safe in the cloud is one of the most visible challenges facing cloud teams in 2020. Cloud storage services where data resides are frequently a target for hackers, not because the services are inherently weak but because they are often improperly configured....

Read more
  • AWS
  • EBS
  • Encryption