Backup and Restore on S3, Azure or GCS

Backup and restore can specify an S3 bucket or Azure container or Google Cloud Storage (GCS). In this case, all the backup files across all the leaves (one per partition as described above) are put directly into the S3 bucket or Azure container or GCS. When restore is called, SingleStore will distribute the backup files appropriately and restore the data (similar to how restoring from an NFS drive works).

When taking a database backup to an Azure bucket [blob container] ensure that your service account has all required privileges, including the blob feed privilege.

See BACKUP DATABASE and RESTORE DATABASE for syntax and examples.

Last modified: September 22, 2023

Was this article helpful?