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

Distributed NoSQL database with high availability and scalability

Non-relational databases with flexible data models and scaling

Special procedure that auto-executes on table events

Organizing tables to reduce redundancy and improve integrity

Field referencing primary key to establish table relationships

Dividing tables into smaller pieces for better performance