Blocking cutovers to save replication slots
Blog post from PlanetScale
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.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Kubernetes | 1 | 956 | 75 | 30 | -73% |
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.