01 - RDS

Question 1

RDS

Answer 1

• Managed database instances
• RDS can contain multiple DBs
• Supports multiple DB engines.

Question 2

Relational Database Engines

Answer 2

• Microsoft SQL Sever
• MySQL Server (open source) Port: 3306 (required for exam - same as Aurura)
• PostgresSQL (open source)
• Oracle
• AWS Aurora (MySQL compatible)
• MariaDB (open source)

Question 3

Non-Relational Database Engines

Answer 3

• Amazon Dynamo DB

Question 4

What is a Relational Database?

Answer 4

• Relational Database (SQL)
  
  • consists of
    
    • tables
    • rows
    • columns
  • example:
    
    • Amazon Aurora DB

Question 5

What is a NON-Relational Database?

Answer 5

• Non-Relational Databases (No SQL)
  
  • consists of
    
    • collections (tables)
    • documents (rows)
    • key value pairs (fields)
  • Example:
    
    • Amazon Dynamo DB (JSON / NoSQL)

Question 6

Access

Answer 6

• Must use the CNAME to access the database

Question 7

Supported instance types

Answer 7

• db.m5 - general usage
• db.r5 - is memory optimized
• db.t3 - is burst capable.

Question 8

Provision storage for DB on attached EBS storage

Answer 8

• SSD gp2 or io1 offer high end performance
• Magnetic is offered for compatibility only. Long term historic usage.

Question 9

Reliability

Answer 9

• Failure of a AZ will kill the DB.
• Managed database instance (1+ more DBs)

Question 10

Cost

Answer 10

• Bill for the
  
  • instance +
  • Storage +
  • PIOPS

Question 11

When to use RDS database?

Answer 11

• Definitions:
  
  • OLTP (Online Transaction Processing) (RDS)
  • OLAP (Online Analytics Processing) (RedShift)
• Differences:
  
  • Focuses on the type of queries run