AWS-Database-index

AWS Database Types

RDS - OTLP (Online Transaction Processing)

  - SQL Server

  - Oracle

  - MySQL

  - PostgreSQL

  - Amazon Aurora

  - MariaDB

- DynamoDB

- RedShift OLAP (Online Analytics Processing, Datawarehousing)

- Elasticache

Non-Relational Database Structure

- Database

- Collection (table)

 - Document (row)

   - Key/Value Pairs (fields)

Data Warehousing

- Used for Business Intelligence (Cognos, Jaspersoft, etc.)

- OLTP Vs. OLAP

OLTP (Online Transaction Processing)

- Order number 2120121

- Pulls up a row of data (name, date, address, status)

OLAP (Online Analytics Processing, used for Data warehousing)

- Pull in large number of records

- Uses different type of architecture for database and infrastructure

Elasticache

- Web service that makes it easy to deploy, operate, and scale in-memory cache in the cloud

- Types - Memcached, Redis

Multi-AZ

- Used for DR

- Not used for performance gains

Read Replicas

- Used for scaling, performance gains

- You can have up to five Read Replicas

Aurora scaling

- 2 copies of data in each AZ, 3 AZ's minimum (total of 6 copies)

- Designed to handle losses transparently

- Self-healing storage

Aurora Replicas - Up to 15 Replicas

MySQL Replicas - Up to 5 Replicas

DynamoDB vs RDS

- DynamoDB offers "push button" scaling

- RDS requires bigger instance size or to add Read Replica

DynamoDB

- Stored on SSD storage

- Spread across 3 geographically distinct data centers

- Types

  - eventually consistent reads (default)

  - strongly consistent reads

Redshift Configuration

Single Node (160GB)

Multi-Node

- Leader Node (manages client connections)

- Compute Node (stores data, performs queries, up to 128 nodes)

Elasticache

Memcached - Multi-AZ NOT available

Redis - Multi-AZ available