AWS - Database

AWS Database Types - Summary

RDS - OLTP

• SQL
• MySQL
• PostgreSQL
• Oracle
• Aurora
• MariaDB

DynamoDB - No SQL

RedShift - OLAP

Elasticache - In Memory Caching

• Memcached
• Redis

DMS

What is DynamoDB

Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed database and supports both document and key-value data models. Its flexible data model and reliable performance make it a great fit for mobile, web, gaming, ad-tech, IoT, and many other applications.

 

DynamoDB

• Stored on SSD storage
• Spread Across 3 geographically distinct data centres
• Eventual Consistent Reads (Default)
• Strongly Consistent Reads

Eventual Consistent Reads

• Consistency accross all copies of data is usually reached within a second. Repeating a read after a short time should return the updated data. (Best Read Performance)

Strongly Consistent Reads

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

 

Aurora

Amazon Aurora is a MySL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.

 

Aurora Scaling

Start with 10 Gb, Scales in 10 Gb increments to 64Tb （Storage Autoscaling)

Compute resources can scale up to 32vCPUs and 240+Gb of Memory

 

Aurora Replicas

2 Types of Replicas are available

• Aurora Replicas (currently 15)
• MySQL Read Replicas (currently 5)