Playbooks

Choose an isolation level

Transactions on one database read and write the same rows: rewrite the operation, push the rule into a constraint, or pick read committed, snapshot isolation or serializable? Four questions, cheapest answer first.

Decide on consistency

Data is replicated across machines or regions: does your rule need coordination at all, can you split the budget so replicas act alone, or do you need real-time ordering? Five questions, cheapest answer first.