Basics

→ Multi AZ- for Disaster Recovery

→ Read Replicas - For Performance

→ Non Relational Databases

→ Data Warehousing →Redshift

→ OTLP vs OLAP

Elasticache

→ in-memory cache

→ RDS on Virtual Machine and users have no direct access to it.

→ RDS is not Serverless

→ Backups for RDS

→ Automated Backups take full snapshot of database stored in S3.

→ DB Snapshots are done manually

→ Restored Version of the database will be new RDS Instance with new endpoint

→ Encryption at Rest using Key management service

DS Multi-AZ

→ Exact copy of production database with automatic synchronisation

→ Force a failover from Availibilty zone to other.

Read Replicass

→ Can Be Multi AZ

→ Used to increase performance

→ Must have backup turned on

→ Can be in different region

→ Can’t have MSSQL Server read replica

→ Can be promoted to Master, it will break read replica

DynamoDB

→ Flexible NoSQL databsse service

→ Stored on SSD Storage

→ Spread across 3 geographically distinct data centers

→ Strongly Consistent reads < 1 second reading

→ Eventual Consistent reads = 1 second reading

→ DynamoDB Accelrator

→ Fully managed highly available, in-memory cache

→ 10x performance improvement

→ Provision capacity vs On-demand capacity

→ On-Demand backup and restore

→ Point-in-Time Recovery

→ Streams

→ Encryption at test using KMS

→ Site-to-site VPN

→ Direct Connect( DX)

→ IAM Policies and roles

→ Fine-grained access

→ Cloudwatch and cloudtrail

→ VPC endpoints

Redshift

→ Fast,powerful, full managed data warehouse for Business intelligence

→ Advanced Compression technique

→ Uses less space than relation database system

→ Provides Parallel Processing

→ Backup upto 35 days

→ Encrypted in transit with SSL

→ Encrypter at rest using AES-256 encryption

→ Available only in 1AZ

Aurora

→ MySQL and PostgresSQL-compatible RDS

→ Five times better than MYSQL and three times better than PostgreSQL

→ Aurora serverless automatically scales up or scales down MYSQL or postgresSQL. Relatively simple, cost-effective option for frequent, intermittent or unpredictable workloads

Elasticache

→ Webservice that provides in-memory cache

→ Provides both memcached and redis

→ Increase database and web application performance

Database Migration Service(DMS)

→ Helps in migrating data

→ Supports both homogenous and hetrogenous migrations with AWS Schema conversion tool

→ Source and target can be both in cloud and on permise.