Backup solutions for Rackspace cloud sites?

What options do I have for backing up the content from a Rackspace Cloud Sites including files and databases? I know they have cron jobs, but I am not sure what options I have when it comes to that.

Here are some of the things the cron jobs they have support.

Solution 1:

I use two scripts to back up my VPS (hosted on Linode, but the same should work on Rackspace).

First, for mysql backup, I use the automysqlbackup script. It takes care of dumping your databases, compressing them, and maintaining several daily/weekly/monthly copies of the backup files. It can also email you the compressed .sql dumps as well.

For general filesystem backup, I use duplicity - this can use a number of different storage backends (ftp, scp, nfs, etc), but I choose to use the Amazon S3 backend. Duplicity will do either full or incremental backups depending on your need. It will also handle compression of your backup files as well as encryption if you so desire.

Solution 2:

Rackspace doesn't allow SSH to their Cloud Sites so I don't think Duplicity will work unless you can convince them to install it.

We were looking for a solution as well, but ended up building a backup system which archives files and SQL dumps and transfers them to Rackspace Cloud Files, named and dated. The system handles cleaning up old backups (we keep a variety of daily/weekly/monthly backups) and works as a module on a dedicated Drupal install. The admin gives feedback on the status of each backup and populates a Google spreadsheet to give an overview. It can also work with any site outside of Rackspace, since it's using a PHP client to do all the work (upload one PHP script to the sites you want to back up, set it up on the admin UI, and the master site will take care of all the scheduling/authentication/etc...) We're using it internally but may release it as a module if there is any interest for it, so let me know.