Production data changes happen while users and workers continue writing. This track follows a permit service through connection admission, transaction conflicts, a historical backfill, and an index build. Each operation has a measurable stop condition and a recovery path.
Topics in this track
- Connection Pool Budgets and Queue Admission — Budget connections across application instances and bound waiting before the database reaches its limit.
- Transaction Retry, Deadlock, and Side-Effect Boundaries — Retry the complete database transaction after a retryable conflict without repeating external effects.
- Resumable Data Backfills and Reconciliation — Move old rows to a new representation in bounded chunks while concurrent writes continue.
- Online Index Builds and Query Plan Release Gates — Stage large index changes with write-availability checks, validity checks, and measured query plans.
Prerequisite paths
Data Persistence; Transactions and Concurrent Writes; Expand-and-Contract Schema Migrations.
Practice and check
Build Project: permit data change under live traffic and review Web Development: database online operations quiz.