Database Flashcards
Database
AWS proprietery RDS (Postgre SQL and MySQL)
Multi AZ setup for DR
Verticle and Horizontal scaling
You CANNOT SSH into your instance
Aurora
Read from more than 1 instance and write to only 1
Read Replicas
Read and Write from 1 and on Failover move to another
Multi AZ
Region 1(Main) reads/writes on Region 1 instance and Region 2 reads on Region 2 but writes to Region 1
Multi Region
In Memory DB for faster read/write for all databases
ElastiCache
No SQL DB Managed DB
Serverless
Standard and IA Table Class
DynamoDB
In Memory Cache for faster read/write for Dynamo DB
DynamoDB Accelerator(DAX)
It’s a way for you to make DynamoDB table accessible with low latency in multiple regions
DynamoDB Global Tables
Serverless(Pay for what you use) and based on Postgre SQL
Only for OLAP and not OLTP
Used for Data warehousing
Uses Massively Paraller Processing Query (MPP)Integrate with BI tools like AWS QuickSight or Tableau
RedShift
Helps create Hadoop clusters(Big Data)
Clusters are many EC2 instances
Autoscaling and integrated with spot instances
ML, Data Processing, Web Indexing, Big data
EMR (Elastic Map Reduce)
Serverless and perform anaytics on S3
Uses SQL
Used for BI, Analytics, Anaylze VPC Flow Logs, CloudTrail, ELB Logs
Athena
Serverless to create interactive dashboards
Integrated with all DBs
QuickSight
Aurora for MongoDB
No SQL DB
DocumentDB
Fully Managed Graph DB
Social Media data
Neptune
Recording Financial Transactions
To review history of all the changes made to your application data over time
Central authority
QLDB
