Relational Databases
Types
OLTP
- Online Transaction Workload Processing
- Row Based Engines
- Aurora , MySQL, MariaDB, Oracle, SQL Server
- Good for lots of small transactions
OLAP
- Online Analytical Processing
- Column Based Engines
- Aurora, PostgreSQL, RedShift
- Good for ETL
Snapshots vs Backups
RDS Encryption
- Should be encrypted while creation
- Integrates with KMS
- To Encrypt an Unencrypted RDS - > Encrypted Snapshot → Create New Encrypted RDS
Read Replica Vs Multi-AZ
