Durability
On this page
What is the durability guaranteed by SingleStoreDB?
SingleStoreDB provides several options to control the trade-offs between performance and durability.
See CREATE DATABASE for more information.
Can I configure SingleStoreDB to be fully durable?
Yes, you can configure the durability through the WITH {SYNC | ASYNC} DURABILITY
option in the CREATE DATABASE and RESTORE DATABASE commands.
What isolation levels does SingleStoreDB provide?
SingleStoreDB provides the READ COMMITTED
isolation level.
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.
Even though regular transactions use READ COMMITTED
isolation level, backups created using the BACKUP
command use SNAPSHOT
isolation level.
Last modified: January 10, 2023