Atomicity & Durability
Rule: COMMIT SUCCESSFUL is a promise about your database's local rows, and nothing else.
Atomicity, isolation, locking and consistency boundaries.
View all tagsRule: COMMIT SUCCESSFUL is a promise about your database's local rows, and nothing else.
Rule: decide which invariants must be true *right now*, and let everything else converge.
A consistency model is a contract about what a read is allowed to return. It is not a quality
Rule: ACID stops at the database boundary, and "localhost is a great lie." Across services you
Rule: the choice is a bet on how often writes actually collide, and being wrong is expensive in
Rule: a read-modify-write split across two statements is a race condition unless you have