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.

AWS Database optionsGot 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

  • 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 it
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

  • 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 it
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

  • 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 it
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

  • 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 it
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-optimised and flexible non-relational data store architecture.
Key Benefits

  • 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 it
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

  • 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 it
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.

Written by

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

— November 28, 2018

Two New EC2 Instance Types Announced at AWS re:Invent 2018 – Monday Night Live

Let’s look at what benefits these two new EC2 instance types offer and how these two new instances could be of benefit to you. Both of the new instance types are built on the AWS Nitro System. The AWS Nitro System improves the performance of processing in virtualized environments by...

Read more
  • AWS
  • EC2
  • re:Invent 2018
— November 21, 2018

Google Cloud Certification: Preparation and Prerequisites

Google Cloud Platform (GCP) has evolved from being a niche player to a serious competitor to Amazon Web Services and Microsoft Azure. In 2018, research firm Gartner placed Google in the Leaders quadrant in its Magic Quadrant for Cloud Infrastructure as a Service for the first time. In t...

Read more
  • AWS
  • Azure
  • Google Cloud
Khash Nakhostin
— November 13, 2018

Understanding AWS VPC Egress Filtering Methods

Security in AWS is governed by a shared responsibility model where both vendor and subscriber have various operational responsibilities. AWS assumes responsibility for the underlying infrastructure, hardware, virtualization layer, facilities, and staff while the subscriber organization ...

Read more
  • Aviatrix
  • AWS
  • VPC
— November 10, 2018

S3 FTP: Build a Reliable and Inexpensive FTP Server Using Amazon’s S3

Is it possible to create an S3 FTP file backup/transfer solution, minimizing associated file storage and capacity planning administration headache?FTP (File Transfer Protocol) is a fast and convenient way to transfer large files over the Internet. You might, at some point, have conf...

Read more
  • Amazon S3
  • AWS
— October 18, 2018

Microservices Architecture: Advantages and Drawbacks

Microservices are a way of breaking large software projects into loosely coupled modules, which communicate with each other through simple Application Programming Interfaces (APIs).Microservices have become increasingly popular over the past few years. The modular architectural style,...

Read more
  • AWS
  • Microservices
— October 2, 2018

What Are Best Practices for Tagging AWS Resources?

There are many use cases for tags, but what are the best practices for tagging AWS resources? In order for your organization to effectively manage resources (and your monthly AWS bill), you need to implement and adopt a thoughtful tagging strategy that makes sense for your business. The...

Read more
  • AWS
  • cost optimization
— September 26, 2018

How to Optimize Amazon S3 Performance

Amazon S3 is the most common storage options for many organizations, being object storage it is used for a wide variety of data types, from the smallest objects to huge datasets. All in all, Amazon S3 is a great service to store a wide scope of data types in a highly available and resil...

Read more
  • Amazon S3
  • AWS
— September 18, 2018

How to Optimize Cloud Costs with Spot Instances: New on Cloud Academy

One of the main promises of cloud computing is access to nearly endless capacity. However, it doesn’t come cheap. With the introduction of Spot Instances for Amazon Web Services’ Elastic Compute Cloud (AWS EC2) in 2009, spot instances have been a way for major cloud providers to sell sp...

Read more
  • AWS
  • Azure
  • Google Cloud
— August 23, 2018

What are the Benefits of Machine Learning in the Cloud?

A Comparison of Machine Learning Services on AWS, Azure, and Google CloudArtificial intelligence and machine learning are steadily making their way into enterprise applications in areas such as customer support, fraud detection, and business intelligence. There is every reason to beli...

Read more
  • AWS
  • Azure
  • Google Cloud
  • Machine Learning
— August 17, 2018

How to Use 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.So you’ve been using AWS for awhile and finally feel comfortable clicking your way through all the services....

Read more
  • AWS
Albert Qian
— August 9, 2018

AWS Summit Chicago: New AWS Features Announced

Thousands of cloud practitioners descended on Chicago’s McCormick Place West last week to hear the latest updates around Amazon Web Services (AWS). While a typical hot and humid summer made its presence known outside, attendees inside basked in the comfort of air conditioning to hone th...

Read more
  • AWS
  • AWS Summits
— August 8, 2018

From Monolith to Serverless – The Evolving Cloudscape of Compute

Containers can help fragment monoliths into logical, easier to use workloads. The AWS Summit New York was held on July 17 and Cloud Academy sponsored my trip to the event. As someone who covers enterprise cloud technologies and services, the recent Amazon Web Services event was an insig...

Read more
  • AWS
  • AWS Summits
  • Containers
  • DevOps
  • serverless