Backups

~~~~~~~

If the backup for this role has been enabled, the following paths are backed-up:

**/srv/backup/maraidb/{{ db_name }}.sql**

  Dump of the database. Database dump is created every day at 01:45 in the

  morning.

---

enable_backup: False

allow_duplicates: yes

dependencies:

  - role: backup_client

    when: enable_backup

---

- name: Create directory for storing MariaDB database dumps

  file: path="{{ item }}" state=directory

        owner=root group=root mode=700

  with_items:

    - "/srv"

    - "/srv/backup"

    - "/srv/backup/mariadb"

- name: Deploy include patterns to backup

  template: src="backup_patterns.j2" dest="/etc/duply/main/patterns/{{ db_name }}"

            owner="root" group="root" mode="700"

  notify:

    - Assemble Duply include patterns

- name: Create crontab entry for creating MariaDB database dumps every day at 01:45

  cron: name="mariadb_{{ db_name }}" cron_file="mariadb_{{ db_name }}" hour=1 minute=45

        job="/usr/bin/mysqldump \"{{ db_name }}\" > /srv/backup/mariadb/\"{{ db_name }}\".sql"

        state=present user=root

- name: Enable backup

  include: backup.yml

  when: enable_backup

/srv/backup/mariadb/{{ db_name }}.sql