Schedule database backups

SingleStore Tools
1

Hello,

We are on version 6.8.* and with the memsql-ops deprecated…

  1. We are trying to figure what the best way is to schedule full database backups (preferably to s3) on a recurring basis.
  2. Is there a way to configure snapshots to be saved to an S3 bucket?

Thanks.

2
  1. There currently (as of 6.X) is no in-database way to schedule backups, you’ll have to use a system like crontab to do this.
  2. Snapshots are stored on the local system, but of course taking a backup will effectively allow you to upload them to S3.

Hope that helps

3

Thanks for confirming. Will share if I end-up writing something.