What isolation levels does SingleStoreDB provide?

SingleStoreDB provides the “READ COMMITTED” isolation level. This guarantees that no transaction will read any uncommitted data from another transaction. Furthermore, once a change is observed in one transaction, it will be visible to all transactions.

Unlike the “REPEATABLE READ” or “SNAPSHOT” isolation level, “READ COMMITTED” isolation level does not guarantee that a row will remain the same for every read query in a given transaction. Applications that use SingleStoreDB should take this into account.

Even though regular transactions use “READ COMMITTED” isolation level, backups created using the BACKUP command use “SNAPSHOT” isolation level.