Durability
On this page
What is the durability guaranteed by SingleStoreDB Cloud?
SingleStoreDB Cloud provides several options to control the trade-offs between performance and durability.
Transaction writes are replicated on two nodes before commit, to ensure updates are never lost in case of single-node failure thereby ensuring durability.
See CREATE DATABASE for more information.
Can I configure SingleStoreDB Cloud 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 Cloud provide?
SingleStoreDB Cloud 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.
What happens if the hardware SingleStoreDB Cloud runs on fails?
SingleStore is built on a cloud-native and highly resilient architecture that features high availability within the workspace.
Last modified: January 10, 2023