InstallationΒΆ

  1. Install backup server with LVM support. Install and configure mylvmbackup config file
$ apt-get install mylvmbackup
$ cp /etc/mylvmbackup.conf{,.bak}
$ cat > /etc/mylvmbackup.conf << END
[mysql]
user=root
password=123password123

socket=/var/run/mysqld/mysqld.sock

[lvm]
vgname=vg0
lvname=mysql
lvsize=2G
END
  1. Install dbsnapshot using pip:
$ pip install django-db-snapshot
  1. Add the dbsnapshot application to INSTALLED_APPS
  2. Configure django-celery on project settings
$ apt-get install redis-server
$ pip install django-celery

INSTALLED_APPS += ('djcelery',)

BROKER_URL = 'redis://127.0.0.1:6379/1'
CELERYBEAT_SCHEDULER = 'djcelery.schedulers.DatabaseScheduler'

import djcelery
djcelery.setup_loader()
  1. Sync database (./manage.py syncdb or ./manage.py migrate)
  2. Run internal dbsnapshot server (./manage.py run_dbsnapshot_server)
  3. Restart Redis instance
$ /etc/init.d/redis-server restart
  1. Add backup server and configure backup options on django admin interface (/admin/dbsnapshot/server/)
  2. That’s all. Enjoy.