Database Isolation Levels, Data Issues and Global Transaction Consistency

Dirty reads, phantom reads, write skew, ACID rain? These are all data concerns that are often overlooked but can be very troubling and super expensive. Are you familiar with database isolation levels and how they can impact these data integrity?

In this session, we walk through a definition of these potential data issues and then map them talk about database isolation levels. We will then speak to how CockroachDB delivers serializable isolation in a distributed environment to ensure these issues won’t plague your application. We will cover...

• Common data consistency issues

• Transaction isolation levels

• Application best practices for retries

• Transactions in a distributed environment

• CockroachDB and PostgreSQL compatibility