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 →

Also covered in

Related concepts

Questions about read replication

What is read replication?

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

Which Manning books explain read replication?

Amazon Web Services in Action, Third Edition: An in-depth guide to AWS and Kubernetes for Developers.

What is the difference between read replication and listen/notify feature?

Read replication is the replication of database data from a writable primary instance to one or more instances that serve read operations. The LISTEN/NOTIFY feature is PostgreSQL's asynchronous event-notification mechanism for delivering channel notifications from the database to connected clients.

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.