Databases

Question 1

Amazon Relational Database Service (RDS)

Answer 1

Service for launching and managing relational DBs

Supports: Amazon Aurora, Postgre SQL, MYSQL, Maria DB, Oracle, and MS SQL

Highly available w/ fault tolerance using multi-AZ deployment option

AWS manages the DB w/automatic software patching, automated backups, OS maint & more

Launch replicas across regions to provide enhanced performance and durability

Question 2

Amazon Aurora

Answer 2

Relational DB service compatible with MySQL & Postgre SQL

Cheaper service

5x faster than MySQL and 3x faster than Postgre SQL

Scales automatically while providing availability and durability

Managed by RDS

Question 3

Amazon Dynomo DB

Answer 3

Fully managed NoSQL, key value, andDocument DB

Fully managed and serverless

Non-relational

Scales automatically to massive workloads with fast performance

Question 4

Amazon Document DB

Answer 4

Fully managed document DB that supports Mongo DB

Fully managed and serverless

Non-Relational

Question 5

Amazon Elasticache

Answer 5

In memory data store

Compatible with Reid’s and memcached engines

Data can be lost!

Offers high performance with low latency

Question 6

Amazon Neptune

Answer 6

Graph database service

Supports highly connected datasets like social media networks

Fully managed and serverless

Fast and reliable

Question 7

Best use case for each DB service

Answer 7

RDS - Migrate on-prem oracle DB to the cloud

RDS / Aurora - migrate on prem Postgre DB to the cloud

Elasticache - Alleviate DB load for data that is accessed often

Neptune - Process large sets of user profiles and social interconnections

Dino of DB - nosql DB fast enough to handle millions of requests a second

Document DB - Operate Mongo DB workloads @ scale

Question 8

Database Migration Service (DMS)

Answer 8

Helps migrate DBs to or within AWS

Continuous data replication

Supports homogenous or heterogeneous migrations (eg oracle to oracle or oracle to Aurora)

Virtually no downtime