What is read replica?

Definition

Replication updates the copy from a source database, allowing queries or analysis to run against a separate instance. The application can grant read-only access to reduce the authority needed for reporting.

A replica may lag behind current writes, and read-only access does not remove privacy or query-load risks. Actual permissions and freshness must be understood rather than inferred from the name alone.

ELI5

A read replica is like a reference copy of a shared record book. People can consult the copy without editing the main book.

For example, an analysis assistant can query a read-only copy while the main application continues recording transactions. The copy may be slightly behind, and its private information still needs protection.

Is a replica always fully up to date?

No. Replication can introduce delay, so a reader must understand the freshness guarantees of the particular system.

Does read-only access eliminate every risk?

No. It limits changes but does not remove risks from sensitive data exposure or expensive queries.

  1. David Ondrej and Ant Wilson beside the blue and white headline Agent Ready Software on black.
Definition card for read replica: What is read replica?

A read replica is a database copy maintained from another database and used to serve read operations separately from the primary writer.