Interview Databases & Caching

Can a read replica be in a different region, and why would you do that?

Databases & Caching · Basic level

Answer

Multi-AZ protects the writer for HA and failover; read replicas are readable copies used for read scaling, reporting, migration, and DR. Read replicas are generally asynchronous, can lag, can often be cross-Region, and can be promoted to standalone databases when needed.

Technical explanation

Use Multi-AZ for availability and read replicas for read workload isolation or migration targets.

Replica lag means read-your-writes is not guaranteed from replicas.

Cross-Region replicas are useful for DR and locality, but require RPO/RTO, secrets, DNS, KMS, and failover runbooks.

Hands-on example

Read/write routing example:

POST /orders -> primary endpoint

GET /orders/{id} immediately after create -> primary endpoint

GET /orders/report -> read replica endpoint

Promotion command for migration or DR:

$ aws rds promote-read-replica --db-instance-identifier orders-replica-dr

Before promotion, check replica lag and stop writes if a clean cutover is required.

Preparing for an interview?

Check how well your resume matches the role with our free resume checker— match score, ATS check, and the skills you're missing.

More Databases & Caching interview questions

← All Databases & Caching questions