tezvyn:

Read replicas in managed relational databases

Source: interviewbeginner

WHAT IT TESTS: scaling reads and replication basics. OUTLINE: a read replica is an async copy of the primary that serves read-only queries, offloading the primary and scaling read-heavy workloads; expect replication lag.

WHAT IT TESTS: understanding read scaling versus high availability. ANSWER OUTLINE: a read replica is an asynchronously replicated, read-only copy of the primary database; its purpose is to offload read traffic so the primary handles writes, letting read-heavy applications scale by spreading queries across replicas. Mention replication lag means replicas may be slightly stale, and that this differs from a synchronous standby used purely for failover.

Read the original → interview

Get five bites like this every day.

Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.

Read replicas in managed relational databases · Tezvyn