Tag: #zero-downtime
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 3 posts
The Complete Guide to Zero-Downtime Schema Changes: The Lock Level Each DDL Takes and How to Run It Safely
Working from the PostgreSQL 18 documentation, this lays out by grade exactly which lock each DDL statement takes: the eight table lock modes and their conflicts, the lock level of every ALTER TABLE variant, which changes
2026-08-15 · 18 min read #database#postgresql#schema-migration#zero-downtime#lockingThe Expand-Contract Pattern — The Right Way to Change Schemas with Zero Downtime
A thorough walkthrough of the Expand-Contract pattern, the standard technique for changing a live database schema without downtime. We cover per-scenario SQL for adding columns, renaming, dropping, and adding constraints
2026-06-16 · 15 min read #database#migration#zero-downtime#expand-contract#reliabilityZero-Downtime Data Migration — Moving Data with Dual-Write, Backfill, and CDC
Moving data to a new store without stopping the service is tricky because of consistency and ordering guarantees. This post lays out a staged cutover strategy combining Dual-Write, Backfill, and CDC, plus verification, r
2026-06-16 · 21 min read #database#migration#cdc#debezium#dual-write