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

Avatar
Michael Sheehy
— August 19, 2019

What Exactly Is a Cloud Architect and How Do You Become One?

One of the buzzwords surrounding the cloud that I'm sure you've heard is "Cloud Architect." In this article, I will outline my understanding of what a cloud architect does and I'll analyze the skills and certifications necessary to become one. I will also list some of the types of jobs ...

Read more
  • AWS
  • Cloud Computing
Avatar
Andrew Larkin
— August 13, 2019

Content Roadmap: AZ-500, ITIL 4, MS-100, Google Cloud Associate Engineer, and More

Last month, Cloud Academy joined forces with QA, the UK’s largest B2B skills provider, and it put us in an excellent position to solve a massive skills gap problem. As a result of this collaboration, you will see our training library grow with additions from QA’s massive catalog of 500+...

Read more
  • AWS
  • Azure
  • content roadmap
  • Google Cloud Platform
Avatar
Adam Hawkins
— August 9, 2019

DevSecOps: How to Secure DevOps Environments

Security has been a friction point when discussing DevOps. This stems from the assumption that DevOps teams move too fast to handle security concerns. This makes sense if Information Security (InfoSec) is separate from the DevOps value stream, or if development velocity exceeds the band...

Read more
  • AWS
  • cloud security
  • DevOps
  • DevSecOps
  • Security
Avatar
Stefano Giacone
— August 8, 2019

Test Your Cloud Knowledge on AWS, Azure, or Google Cloud Platform

Cloud skills are in demand | In today's digital era, employers are constantly seeking skilled professionals with working knowledge of AWS, Azure, and Google Cloud Platform. According to the 2019 Trends in Cloud Transformation report by 451 Research: Business and IT transformations re...

Read more
  • AWS
  • Cloud skills
  • Google Cloud
  • Microsoft Azure
Avatar
Andrew Larkin
— August 7, 2019

Disadvantages of Cloud Computing

If you want to deliver digital services of any kind, you’ll need to estimate all types of resources, not the least of which are CPU, memory, storage, and network connectivity. Which resources you choose for your delivery —  cloud-based or local — is up to you. But you’ll definitely want...

Read more
  • AWS
  • Azure
  • Cloud Computing
  • Google Cloud Platform
Joe Nemer
Joe Nemer
— August 6, 2019

Google Cloud vs AWS: A Comparison (or can they be compared?)

The "Google Cloud vs AWS" argument used to be a common discussion among our members, but is this still really a thing? You may already know that there are three major players in the public cloud platforms arena: Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP)...

Read more
  • AWS
  • Google Cloud Platform
  • Kubernetes
Avatar
Stuart Scott
— July 29, 2019

Deployment Orchestration with AWS Elastic Beanstalk

If you're responsible for the development and deployment of web applications within your AWS environment for your organization, then it's likely you've heard of AWS Elastic Beanstalk. If you are new to this service, or simply need to know a bit more about the service and the benefits th...

Read more
  • AWS
  • elastic beanstalk
Avatar
Stuart Scott
— July 26, 2019

How to Use & Install the AWS CLI

What is the AWS CLI? | The AWS Command Line Interface (CLI) is for managing your AWS services from a terminal session on your own client, allowing you to control and configure multiple AWS services and implement a level of automation. If you’ve been using AWS for some time and feel...

Read more
  • AWS
  • AWS CLI
  • Command line interface
Alisha Reyes
Alisha Reyes
— July 22, 2019

Cloud Academy’s Blog Digest: July 2019

July has been a very exciting month for us at Cloud Academy. On July 10, we officially joined forces with QA, the UK’s largest B2B skills provider (read the announcement). Over the coming weeks, you will see additions from QA’s massive catalog of 500+ certification courses and 1500+ ins...

Read more
  • AWS
  • Azure
  • Cloud Academy
  • Cybersecurity
  • DevOps
  • Kubernetes
Avatar
Stuart Scott
— July 18, 2019

AWS Fundamentals: Understanding Compute, Storage, Database, Networking & Security

If you are just starting out on your journey toward mastering AWS cloud computing, then your first stop should be to understand the AWS fundamentals. This will enable you to get a solid foundation to then expand your knowledge across the entire AWS service catalog.   It can be both d...

Read more
  • AWS
  • Compute
  • Database
  • fundamentals
  • networking
  • Security
  • Storage
Avatar
Adam Hawkins
— July 17, 2019

How to Become a DevOps Engineer

The DevOps Handbook introduces DevOps as a framework for improving the process for converting a business hypothesis into a technology-enabled service that delivers value to the customer. This process is called the value stream. Accelerate finds that applying DevOps principles of flow, f...

Read more
  • AWS
  • AWS Certifications
  • DevOps
  • DevOps Foundation Certification
  • Engineer
  • Kubernetes
Avatar
Vineet Badola
— July 15, 2019

AWS AMI Virtualization Types: HVM vs PV (Paravirtual VS Hardware VM)

Amazon Machine Images (AWS AMI) offers two types of virtualization: Paravirtual (PV) and Hardware Virtual Machine (HVM). Each solution offers its own advantages. When we’re using AWS, it’s easy for someone — almost without thinking —  to choose which AMI flavor seems best when spinning...

Read more
  • AWS
  • Hardware Virtual Machine
  • Paravirtual
  • Virtualization