Question

What Are My Options (Backup)

Posted September 30, 2015 1.4k views
Backups

Hi,

I am relatively new to Digital Ocean. I have about 12 droplets under my account, for various different clients.

I have backup enabled on each droplet, however i was surprised to learn that this does not include a backup of the database.

Can anyone recommend any other backup systems or scripts that will automatically backup the files and database on a daily basis… even to 3rd party storage?

Thank you in advance for your help.

Add a comment
mosaic
By:
mosaic
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer
kamaln7 September 30, 2015

A droplet backup includes every single thing that is on the droplet. It’s a complete copy of the filesystem, which means that it does include your database. However, you can’t restore part of the backup only. So you can’t restore just your database.

You can set up your own backup solution using Bacula. Take a look at the following series:

Especially this tutorial:

How To Create Hot Backups of MySQL Databases with Percona XtraBackup on Ubuntu 14.04
by Mitchell Anicas
This tutorial will show you how to perform a full hot backup of your MySQL or MariaDB databases using Percona XtraBackup on Ubuntu 14.04. The resulting database backup can then be copied to a remote server with a traditional file backup system, like Bacula. The process of restoring the database from a backup is also covered.
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help