RDS (OLTP): Sql server, oracle, mysql, postgres, aurora, mariadb
- Multi AZ: for disaster recovery
- Read Replicas: For performace
With multi AZ: Amz will auto switch to another replica when the other one down
- primary db has write → sync to 2nd database automatically
- can force a failover from one AZ to another by rebooting the RDS instance

With Read Replicas
- After Write, primary database will replicate to 2nd database.
- If failure, no auto switch
- manually update in EC2

- Scale out: up performance:
- Read from replica, write in primary
Data Warehousing
Used to pull very large and complex data sets, usually used by management to do queries on data
Use for business intelligence, tools like Cognos, Jaspersoft, ...
OLTP vs OLAP
Different in terms of the types of queries you will run
Online Transaction Processing (OLTP)
- Eg: order number 2121212 pulls up a row of data such as Name, Date, Address ...