Causal Reads with MariaDB Xpand

Overview

MariaDB Xpand writes data in a strongly consistent manner. Xpand's consistency model is stronger than a causally consistent model. Therefore, Xpand provides causal reads by design without any extra configuration.

A read query outside of a transaction on any Xpand node will always return the most current data.

A read query within a transaction uses the Repeatable Read transaction isolation level. The Repeatable Read isolation level allows a transaction to see a consistent snapshot of data for a given table throughout the lifetime of a transaction, even if the underlying data has been modified. See Using Transaction Isolation Levels with MariaDB Xpand for more information.