Primary-Replica Architecture

Quick Definition

Architecture with primary for writes, replicas for reads

Architecture with primary handling writes and replicas handling reads.

write-read separation, failover, high availability

replication read-replica

Copying data between servers for redundancy

Physical stored copy of query results refreshed periodically

Managing simultaneous data access while maintaining consistency

Fully managed serverless NoSQL database by AWS

Copy of primary database for read-only queries

Special procedure that auto-executes on table events