Amazon Database

Question 1

AWS Aurora

Answer 1

o Fully managed MySQL - and
PostgreSQL- compatible, relational
database engine

o Combines speed and reliability of
high-end commercial databases with
the simplicity and cost-effectiveness
of open-source databases

o Up to 5x faster than standard
MySQL

o High availability/durability, high
performance, high scalability,
multi- region, and compatible

Question 2

AWS Relational Database Service (RDS)

Answer 2

o RDS makes it easy to setup,
operate, and scale a
regional/relational
database in the cloud

o Cost efficient, easy to scale and
automatically deals with
patching/backups

o Consists of tables, rows, and
columns

o Simplify database management by
automating simple, route tasks
(ex: testing/QA)

Question 3

RDS Available Instance Types

Answer 3

o Optimized for memory,
performance, or inputs/outputs

o	6 familiar database engines to 
        choose from
             • Amazon Aurora
             • PostgreSQL
             • MySQL
             • MariaDB
             • Oracle Database
             • SQL Server

Question 4

Features of RDS (1st)

Answer 4

1. Multi-availability zones ( in case of
   failover/disaster recovery)

a) Provides enhanced availability and durability for DB Instances, making them a natural fit for production database workloads. When you provision a Multi-AZ DB Instance, Amazon RDS automatically creates a primary DB Instance and synchronously replicates the data to a standby instance in a different AZ

Question 5

Features of RDS (2nd)

Answer 5

2. Read Replicas (meant for performance use)
   a) Allow you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads

Question 6

What are the most common relational database engines?

Answer 6

• Amazon Aurora, MSFT SQL Server,

MariaDB, Oracle, PostgreSQL, MySQL

Question 7

AWS DynamoDB

Answer 7

• Fast and flexible non-relational/NoSQL database service for all applications that need consistent latency at any scale
• Fully managed, fast/consistent performance, fine grained access control (IAM), and flexible
• Cloud database that supports both document and key-value models
• Its flexible data model, reliable performance, and automatic scaling of throughput capacity makes it a great fit for mobile, web, gaming, ad tech, IoT, and many other applications
• Non-relational Database
• JSON data available

Question 8

AWS ElastiCache

Answer 8

o AWS ElastiCache:
 A way of caching your data in the cloud
 Eg. When every person coming to your website sees the top 10 selling items and clicks on them
 Web based service that makes it easy to deploy, operate, and scale in-memory cache in the cloud (helps with web applications like saving username/PW or online shopping with Amazon)
 The service improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory data stores, instead of relying entirely on slower disk-based databases.
 Elasticache to speed up performance of existing databases (frequent identical queriesa)
 Elasticache supports two open source in-memory caching engines:
• Memcached
• Redis