Read-Write Transaction API

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

-- Scalable Read Atomic Transaction for Partitioned Datastore A StoryYou 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 and…