Multi-Az Deployment
Scenario: Lets create a multi az rds mysql db instance and then create a read replica in a different region
- With multi az, we get HA and auto failover. This is generally used in production
- The cross region read replica is to offload the read traffic for analytics/Business Intelligence applciations
- Create a multi AZ DB instance with mysql of size t2.micro or t3.micro, storage => gp2 (20GB), new security group
- Create a read replica in different region