"Stoked that SnapShooter takes care of MySQL backups for us, I started out writing my own scripts to do it but it gets pretty complicated between dumping, uploading, rotating, verifying... would much rather use a reliable service like this than roll my own!"
Schedule snapshots from every hour to every day, in your timezone.
Advanced backup rotation retention policies allows you to keep as many daily, weekly and monthly backups as you want.
Restoring a MySQL backup is a simple process, select the backup you want to run and copy the command provided.
Bring your Own Storage
Store your MySQL backups in AWS S3 or DigitalOcean Spaces. More S3 compatible storage coming soon!
"After messing around with bash scripts and cron jobs to back up my MySQL databases, Snapshooter's new service has been a godsend. Just a few clicks and I have reliable backups to S3 on a regular schedule."
Super Simple Setup
Choose a server to run as a worker. Once connected via SSH enter database backup credentials, choose a storage provider and set your schedule!Start Free Trial
Works with self hosted MySQL as well as Managed DigitalOcean MySQL
We use DigitalOcean managed databases here at SnapShooter and we love the offering! They include daily backups as part of the offering, however as a business we like to have our most important data backed up in two locations, so we schedule additional hourly backups to S3.
Not Limited to DigitalOcean!
This is our first offering that supports backups from any provider, if there is SSH access we can back it up!
What gets installed on my server?
Currently, we need the following software installed: mysql-client (or mariadb) with mysqldump, tar, zip, and curl. We also use rclone but we use a binary that does not require installing by the end user.
Who pays for storage?
You pay the fees associated with any external S3 storage.
How does SnapShooter make backups secure
Our commands are executed over the industry standard of OpenSSH, using bash commands, we don't require any sudo permissions to make a backup. We use 4096 bit secure ssh keys. We encrypt all keys and passwords, in our systems.
Who pays for the network transfer costs?
You pay the fees associated with the inbound/outbound traffic.
DigitalOcean offers a generous 1TB of traffic for the lowest cost ($5) droplet, but if you exceed this you may be required to pay for network traffic.
We compress the generated SQL backup to reduce transfer costs.