#Replication

3 articles tagged with Replication.

Infrastructure•#Postgres#Database•last month

Postgres Read Replicas: Routing Reads Without Stale-Data Bugs

Adding a read replica cut primary load 60%, then support tickets rolled in about users not seeing their own edits. Replication lag turned into a correctness bug we had to route around.

KU

Kiril Urbonas·2

Read article

Infrastructure•#Postgres#Replication•2 months ago

Postgres Logical Replication for Zero-Downtime Major Upgrades

pg_upgrade is fast but takes downtime; logical replication lets you cut over while the old DB still serves traffic. The runbook, the gotchas, and the post-cutover checklist.

KU

Kiril Urbonas·7

Read article

Infrastructure•#Postgres#Replication•3 months ago

Postgres Replication Lag — Monitoring and Failover Practice

Replication is the foundation of database HA. What we monitor, how we practice failover, and the gotchas that show up only when you actually fail over.

KU

Kiril Urbonas·7

Read article