Using database backup add-in

What is the database backup add-in?

Use this add-in to automatically back up your database on a schedule of your choosing.

Backup types

Cloud 66 supports two types of backups: managed and unmanaged.

Managed backups

Using managed backups has several benefits:

The 100 most recent managed backups are kept by default.

Unmanaged backups

Unmanaged backups are stored on your local server and are available under /var/cloud66/backups. The 10 most recent unmanaged backups are kept by default.

Note

In order for backups to work, you are required to have twice as much space on your server as your backup consumes.

Backup format

The backup format for redis and mongodb is always binary. For MySQL and Postgresql you can choose between binary and text.

Binary

A binary backup is a snapshot of the data folder of your database service along with necessary log files. The result is a data folder which can be restored on your server to return it to the same state as it was at the time of backup.

As this backup contains raw data of your database server (rather than a human readable SQL dump file) you can expect much faster backup/restore process, particularly for large databases. This method can be up to 4 times faster which can be very helpful in failover scenarios. But there are some limitations:

Text

For this format we generate a dump file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time of the dump.

As the output of the backup is a simple SQL dump file, you can use it to import your data to other servers or when you want to upgrade your server version but restore process will be much longer than binary, particularly if you have lots of indexes in your database.

These are other benefits of this type of backup:

Backup schedule

You can specify how often you would like to backup your database. Your options are:

Compression

You can specify whether or not you would like to Gzip compress your backups. Compressing your backups will take up less space, but will require additional processing during the compression.

Exclude tables

This option only applies to text MySQL and PostgreSQL backups. You can provide a comma separated list of tables which you want to exclude from your backup to create a smaller one.

Install on replica

This option only applies to text MySQL and PostgreSQL and to redis (binary) backups. With this option you can move the backup service to your database replica if available, to relieve pressure on your production database.

Warning

Adding or removing a Postgresql binary backup requires a service restart.

Restoring database backups

We recommend using the automated restore process to restore backups. To do this:

If you need to manually download and/or restore a backup, please read our in-depth guide on manually managing database backups.