Pitfalls of isolation levels in distributed databases
The more loosely coupled components are in a distributed system, the better it scales. This rule applies to distributed databases, too, and the isolation level plays a big part in this. This post attempts to explain what these isolation levels mean and the tradeoffs between them. We also give you recommendations on how to choose the isolation level best suited to your needs. There exists a set of ANSI Standards for isolation. There is also a critique about those standards explaining the ambiguit
