liveBook · Manning

Read replication

Read replication is the replication of database data from a writable primary instance to one or more instances that serve read operations.

How 2 Manning books explain it

Amazon Web Services in Action, Third Edition: An in-depth guide to AWS

A read replica is a replicated database instance that serves read-only queries and can be promoted to primary in supported configurations.

How it is used
Uses replicas to increase read throughput for applications that generate many more reads than writes.
How deep it goes
Explains asynchronous replication, application routing, creation steps, lag monitoring, promotion, and billing, but not replica internals.
Examples
Uses an RDS WordPress database, HyperDB, AWS CLI commands, distributed read requests, and a Redis gaming application with measurable lag.
What you can do after
Apply it via Amazon RDS by creating replicas, routing reads, monitoring lag, and promoting or deleting replicas when appropriate.

Read how Amazon Web Services in Action, Third Edition: An in-depth guide to AWS explains read replication →

Kubernetes for Developers

A read replica is a synchronized database instance that serves read operations separately from a primary writable instance.

How it is used
Offloads SELECT queries from the primary database to reduce strain during application scaling.
How deep it goes
Provides an implementation pattern with separate connections and permissions, but does not detail replication internals.
Examples
Uses two connections to one database first, then redirects the read-only connection to a deployed replica.
What you can do after
Configure an application for read scaling by separating read-only and primary database connections.

Read how Kubernetes for Developers explains read replication →

Related concepts

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.