Read-Write Transaction API

By Lu Pan in transaction on

There are multiple ways you can approach a Read-Write transaction API. MySQL's transaction API is fully conversational that comes with great flexibility and power. However it can be easily abused causing long lock duration, especially in an OLTP workload. Most of the choices related to transactions boil down to pessimistic…

Consistent Badge Count at Scale

By Lu Pan in transaction on

-- Scalable Read Atomic Transaction for Partitioned Datastore A Story You are building a messaging app. You start with a non-partitioned single database, where you store unseen message count and the actual messages in two different tables. It served you well ... until more and more people are using your app…