{question}
How to backup all databases in a SingleStore Cluster?
{question}
{answer}
In this article, we will discuss how to backup all databases in a SingleStore cluster.
On-Prem Cluster:
It is not possible to do a backup of all databases in bulk using the BACKUP DATABASE command but you can use sdb-admin create-backup it to do so.
Backup of all databases at once can be achieved by using the SingleStore Toolbox command below:
sdb-admin create-backup --repository "s3://singlestore-backup/destination?region=eu-central-1" --include "*"
We can use a wildcard like --include "*" to perform all DB selections,
--include GLOB Backup all databases matching GLOB (e.g. "*", "foo*", "*bar")
Click here to check the other options available with sdb-admin create-backupcommand.
SingleStore CloudDB Clusters:
It's not possible to use SingleStore tools with SingleStore CloudDB (Managed Service), instead, we can only use the BACKUP DATABASE command for each database.
Click here to learn about performing BACKUP and RESTORE on SingleStore Cloud.
{answer}