v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

Transactions

How transactions work in YugabyteDB

YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit of work. YugabyteDB provides ACID guarantees for all transactions.

The following table summarizes the support for transactions across the YSQL and YCQL APIs.

Property YSQL YCQL Comments
Distributed transactions Yes Yes Perform multi-row or multi-table transactions.
An application can connect to any node of the cluster.
Isolation levels Serializable
Snapshot
Read Committed		 Snapshot Repeatable read isolation level in PostgreSQL maps to snapshot isolation in YSQL.
AUTOCOMMIT = false setting Yes No The transaction must be expressed as one statement in YCQL.
Distributed transactions
Distributed transactions in YugabyteDB.
Isolation levels
Serializable, snapshot, and read committed isolation in YugabyteDB.
Explicit locking
Explicit row-level locking in YSQL.