When CAP Is Not Enough: Understanding PACELC in Distributed Databases

Images by author

Introduction

While pondering which database I wanted to use, I had a good conversation with a few friends about designing a chat system. There were various options like MySQL, MongoDB, Postgres, and Cassandra. During the discussion, one thing led to another, and we started discussing the CAP theorem.