Home » AWS Certification Training Notes » AWS Certified Cloud Practitioner » AWS Databases

AWS Databases

This article covers AWS Databases for the AWS Cloud Practitioner exam. This is one of the key technology areas covered in the exam blueprint.

Use Cases For Different Database Types

The table below provides guidance on the typical use cases for several AWS database/data store services:

Amazon Database Use Cases

We’ll now cover several of these database types that may come up on the exam.

Amazon Relational Database Services (RDS)

Amazon Relational Database Service (Amazon RDS) is a managed service that makes it easy to set up, operate, and scale a relational database in the cloud.

Relational databases are known as Structured Query Language (SQL) databases.

Non-relational databases are known as NoSQL databases.

RDS is an Online Transaction Processing (OLTP) type of database.

RDS features and benefits:

  • SQL type of database.
  • Can be used to perform complex queries and joins.
  • Easy to setup, highly available, fault tolerant, and scalable.
  • Used when data is clearly defined.
  • Common use cases include online stores and banking systems.

Amazon RDS supports the following database engines:

  • SQL Server.
  • Oracle.
  • MySQL Server.
  • PostgreSQL.
  • Aurora.
  • MariaDB.

Aurora is Amazon’s proprietary database.

RDS is a fully managed service and you do not have access to the underlying EC2 instance (no root access).

The RDS service includes the following:

  • Security and patching of the DB instances.
  • Automated backup for the DB instances.
  • Software updates for the DB engine.
  • Easy scaling for storage and compute.
  • Multi-AZ option with synchronous replication.
  • Automatic failover for Multi-AZ option.
  • Read replicas option for read heavy workloads.

A DB instance is a database environment in the cloud with the compute and storage resources you specify.

Encryption:

  • You can encrypt your Amazon RDS instances and snapshots at rest by enabling the encryption option for your Amazon RDS DB instance.
  • Encryption at rest is supported for all DB types and uses AWS KMS.
  • You cannot encrypt an existing DB, you need to create a snapshot, copy it, encrypt the copy, then build an encrypted DB from the snapshot.

DB Subnet Groups:

  • A DB subnet group is a collection of subnets (typically private) that you create in a VPC and that you then designate for your DB instances.
  • Each DB subnet group should have subnets in at least two Availability Zones in a given region.
  • It is recommended to configure a subnet group with subnets in each AZ (even for standalone instances).

AWS Charge for:

  • DB instance hours (partial hours are charged as full hours).
  • Storage GB/month.
  • I/O requests/month – for magnetic storage.
  • Provisioned IOPS/month – for RDS provisioned IOPS SSD.
  • Egress data transfer.
  • Backup storage (DB backups and manual snapshots).

Scalability:

  • You can only scale RDS up (compute and storage).
  • You cannot decrease the allocated storage for an RDS instance.
  • You can scale storage and change the storage type for all DB engines except MS SQL.

RDS provides multi-AZ for disaster recovery which provides fault tolerance across availability zones:

  • Multi-AZ RDS creates a replica in another AZ and synchronously replicates to it (DR only).
  • There is an option to choose multi-AZ during the launch wizard.
  • AWS recommends the use of provisioned IOPS storage for multi-AZ RDS DB instances.
  • Each AZ runs on its own physically distinct, independent infrastructure, and is engineered to be highly reliable.
  • You cannot choose which AZ in the region will be chosen to create the standby DB instance.

Read Replicas – provide improved performance for reads:

  • Read replicas are used for read heavy DBs and replication is asynchronous.
  • Read replicas are for workload sharing and offloading.
  • Read replicas provide read-only DR.
  • Read replicas are created from a snapshot of the master instance.
  • Must have automated backups enabled on the primary (retention period > 0).

More detailed info: https://digitalcloud.training/certification-training/aws-solutions-architect-associate/database/amazon-rds/

Amazon DynamoDB

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability.

Dynamo DB features and benefits:

  • NoSQL type of database (non-relational).
  • Fast, highly available, and fully managed.
  • Used when data is fluid and can change.
  • Common use cases include social networks and web analytics.

Push button scaling means that you can scale the DB at any time without incurring downtime.

SSD based and uses limited indexing on attributes for performance.

DynamoDB is a Web service that uses HTTP over SSL (HTTPS) as a transport and JSON as a message serialisation format.

Amazon DynamoDB stores three geographically distributed replicas of each table to enable high availability and data durability.

Data is synchronously replicated across 3 facilities (AZs) in a region.

Cross-region replication allows you to replicate across regions:

  • Amazon DynamoDB global tables provides a fully managed solution for deploying a multi-region, multi-master database.
  • When you create a global table, you specify the AWS regions where you want the table to be available.
  • DynamoDB performs all of the necessary tasks to create identical tables in these regions, and propagate ongoing data changes to all of them.

Provides low read and write latency.

Scale storage and throughput up or down as needed without code changes or downtime.

DynamoDB is schema-less.

DynamoDB can be used for storing session state.

Provides two read models.

Eventually consistent reads (Default):

  • The eventual consistency option maximises your read throughput (best read performance).
  • An eventually consistent read might not reflect the results of a recently completed write.
  • Consistency across all copies reached within 1 second.

Strongly consistent reads:

  • A strongly consistent read returns a result that reflects all writes that received a successful response prior to the read (faster consistency).

Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement – from milliseconds to microseconds – even at millions of requests per second.

More detailed info: https://digitalcloud.training/certification-training/aws-solutions-architect-associate/database/amazon-dynamodb/

Amazon RedShift

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and existing Business Intelligence (BI) tools.

RedShift is a SQL based data warehouse used for analytics applications.

RedShift is a relational database that is used for Online Analytics Processing (OLAP) use cases.

RedShift is used for running complex analytic queries against petabytes of structured data, using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel query execution.

RedShift is ideal for processing large amounts of data for business intelligence.

RedShift is 10x faster than a traditional SQL DB.

RedShift uses columnar data storage:

  • Data is stored sequentially in columns instead of rows.
  • Columnar based DB is ideal for data warehousing and analytics.
  • Requires fewer I/Os which greatly enhances performance.

RedShift provides advanced compression:

  • Data is stored sequentially in columns which allows for much better performance and less storage space.
  • RedShift automatically selects the compression scheme.

RedShift uses replication and continuous backups to enhance availability and improve durability and can automatically recover from component and node failures.

RedShift always keeps three copies of your data:

  • The original.
  • A replica on compute nodes (within the cluster).
  • A backup copy on S3.

RedShift provides continuous/incremental backups:

  • Multiple copies within a cluster.
  • Continuous and incremental backups to S3.
  • Continuous and incremental backups across regions.
  • Streaming restore.

RedShift provides fault tolerance for the following failures:

  • Disk failures.
  • Nodes failures.
  • Network failures.
  • AZ/region level disasters.

More detailed info: https://digitalcloud.training/certification-training/aws-solutions-architect-associate/database/amazon-redshift/

Amazon ElastiCache

ElastiCache is a web service that makes it easy to deploy and run Memcached or Redis protocol-compliant server nodes in the cloud.

The in-memory caching provided by ElastiCache can be used to significantly improve latency and throughput for many read-heavy application workloads or compute-intensive workloads .

Best for scenarios where the DB load is based on Online Analytics Processing (OLAP) transactions.

The following table describes a few typical use cases for ElastiCache:

Amazon ElastiCache Use Cases

Elasticache EC2 nodes cannot be accessed from the Internet, nor can they be accessed by EC2 instances in other VPCs.

Can be on-demand or reserved instances too (but not Spot instances).

Elasticache can be used for storing session state.

There are two types of ElastiCache engine:

  • Memcached – simplest model, can run large nodes with multiple cores/threads, can be scaled in and out, can cache objects such as DBs.
  • Redis – complex model, supports encryption, master / slave replication, cross AZ (HA), automatic failover and backup/restore.

The table below describes the requirements that would determine whether to use the Memcached or Redis engine:

Amazon ElastiCache Memcached or Redis

More detailed info: https://digitalcloud.training/certification-training/aws-solutions-architect-associate/database/amazon-elasticache/

Also in AWS Certified Cloud Practitioner Training Notes:

5 Comments

misshygienic · April 29, 2019 at 6:32 pm

Hi Neal, what’s the difference between a replica and a backup?

Secondly, would it be possible to provide (at the end of each training note) a link strictly with questions from the AWS CCP exam for that particular topic? For example, after reading training notes for AWS database, I find a link at the bottom of the page with questions from the exam pertaining to databases alone. This will mean I can test my knowledge and understanding of that particular topic immediately.

It would be great. Thanks

    Neal · April 30, 2019 at 5:08 am

    Hi, a Read Replica is used to offload reads for performance reasons whereas a backup is just a DB snapshot stored on S3 that you can restore from. I can’t put questions at the end of the training notes as these are a free resource and you need to login to access these questions. However, for those with access to the question bank I do exactly this with “Knowledge Reviews” that are collections of questions under a specific knowledge area.

Chamara · March 14, 2019 at 2:40 pm

– Please mention that Amazon RedShift is a relational database management system.
– Elasticache and Neptune is in “Additional AWS Services and Tools” do you think you can move those to this “AWS Databases” section? Since those two are Non-Relational Databases.

    Neal · March 16, 2019 at 7:27 pm

    Hi Chamara,
    I have updated the RedShift description as requested. The reason ElastiCache and Neptune are in the “Additional AWS Services and Tools” section is because I haven’t received reports that they are featured in the exam. Therefore, they are positioned there for extra reading. Happy to move them when I hear they’re featuring on the exam.
    Best regards
    Neal

Leave a Reply