Optimistic locking: Consistency and migration
Defines version-based optimistic concurrency, conflict responses, safe retries, and a zero-downtime migration path for mutable records where lost updates matter.
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.