Backup your MySQL database(s) using SimpleBackups and store it on UpCloud Object Storage.
UpCloud is one of the leading cloud providers around.
They provide fast and secured infrastructure that can now be connected with SimpleBackups.
In this article we'll focus on their S3-compliant storage that can be used as storage for all your backups.
Sign in your UpCloud account at https://hub.upcloud.com/
Go to https://hub.upcloud.com/object-storage/new or navigate to "Object Storage" and click on "New Object Storage"
Select the location for your storage (think about GDPR rules, if you're an EU company)
Make sure to keep "Public network access" option enabled
Name your storage
Select "Yes, create a bucket now" and finally give your bucket a name
Good job, your UpCloud bucket is created!
Information you'll need in step 3:
Let's now go to SimpleBackups and get that backup configured.
From this screen you'll be able to configure what data you're backing up (MySQL in this case), where you want it to be saved (in this case your UpCloud Bucket), and how often you want this to be done.
FYI this section will be the same, no matter what storage you pick. And that's the beauty of it, if you want to change storage, just select another one from the list (Backblaze, AWS, or whatever you might prefer), and you'll be good to go.
Select your schedule option (here we picked a daily schedule) You can select a pre-defined schedule (daily, weekly, monthly) or a custom option allowing you to schedule it whenever you want to use CRON syntax.
Example of CRON schedule for "20:00 every Tuesday" =
0 22 * * 2
Finally, the "On demand" option won't schedule anything but will allow you to trigger the backup manually or using our API.
Define the backup retention, which is the number of backups you want to keep (kind of the history length of your backup if you prefer)
You'll have to input :
Congratulations, you now have your MySQL database backed up on UpCloud!
Run it once manually (using the "Run" backup button from the backups list), and you'll trigger your first backup!