SingleStore Managed Service

Lock-free Backups

Lock-free backups are enabled when the lockfree_backup engine variable is set to ON and the disable_update-delete_distributed_transactions engine variable is set to OFF. The default values of lockfree_backup and disable_update-delete_distributed_transactions are ON and OFF, respectively.

Note

Lock-free backups cannot be made using BACKUP DATABASE ... WITH SPLIT PARTITIONS ....

Locking that Occurs if Lock-free Backups are Disabled

If lock-free backups are disabled and BACKUP DATABASE is run, the following applies before the backup starts: