🗄️ RDS Relational Database - Advanced

Multi-AZ Deployments

# Create with Multi-AZ
aws rds create-db-instance \
  --db-instance-identifier mydb \
  --multi-az \
  --engine postgres \
  --allocated-storage 100

Read Replicas

# Create read replica
aws rds create-db-instance-read-replica \
  --db-instance-identifier mydb-replica \
  --source-db-instance-identifier mydb

# Promote replica
aws rds promote-read-replica \
  --db-instance-identifier mydb-replica

Performance Insights

# Enable Performance Insights
aws rds modify-db-instance \
  --db-instance-identifier mydb \
  --enable-performance-insights \
  --performance-insights-retention-period 7

Key Takeaways

• **Multi-AZ** ensures high availability

• **Read replicas** scale reads

• **Performance Insights** optimizes queries

• **Monitoring** prevents issues

Next Steps

Explore DynamoDB optimization and global tables.