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