Optimistic locking: Consistency and migration
Introduces version columns and conflict responses with backfill defaults so existing rows join the concurrency protocol safely.
Routes read queries to primary or replica nodes based on session stickiness, read-your-writes requirements, and measured replication lag so stale reads fail visibly instead of silently misinforming users.