Home / Companies / PlanetScale / Blog / Post Details
Content Deep Dive

Blocking cutovers to save replication slots

Blog post from PlanetScale

Post Details
Company
Date Published
Author
-
Word Count
1,220
Company Posts That Month
9
Language
English
Hacker News Points
-
Post removed?
No
Summary

PlanetScale Postgres blocks planned database cutovers, such as resizes, configuration changes, and maintenance, when logical replication slots are not synchronized and ready on a promotion candidate, aiming to prevent downstream applications from losing change-data-capture events. While PostgreSQL WAL replication can ensure that replica data is current, its default promotion behavior does not require logical slots—WAL bookmarks used by analytics, search, and queue consumers—to be copied and usable on the new primary. PlanetScale’s Kubernetes operator detects slot and configuration problems, alerts users through email and dashboard notices, waits for required slots to become ready, and can eventually permit a blocked cutover after a grace period with a warning of potential data loss. To make slots promotion-ready, users must create or alter them with `failover = true`, register dependent slot names in PlanetScale, and enable `hot_standby_feedback` and `sync_replication_slots`; these settings preserve and synchronize slot state but can increase primary database bloat, particularly when replicas have long-running transactions.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Kubernetes 1 956 75 30 -73%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.