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.