mydumper-backup

Perform backups using mydumper.

Requirements

• mydumper (will not be installed)

Variables

• mydumper_backup_install_path: [default: /usr/local/bin]: Install directory

• mydumper_backup_mydumper_path: [default: /usr/local/bin]: Path to mydumper

• mydumper_backup_myloader_path: [default: mydumper_backup_mydumper_path]: Path to myloader

• mydumper_backup_all: [optional, default: false]: Whether to back up all databases. When true, disables databases options

• mydumper_backup_options: [default: {}]: Arbitrary options (passed to mydumper) (e.g. {trx-tables: '', defaults-extra-file: ~/.my.cnf, clear: ''})

• mydumper_backup_all_regex: [optional]: A regular expression to match against database and table (only when mydumper_backup_all is true)

• mydumper_backup_backup_databases: [default: []]: Backup declarations

• mydumper_backup_backup_databases.{n}.src: [required]: Database name (from)

• mydumper_backup_backup_databases.{n}.dest: [optional, default src]: Directory name (to)

• mydumper_backup_restore_all: [optional, default: mydumper_backup_all]: Whether to restore all databases. When true, disables databases options

• mydumper_backup_restore_options: [default: {}]: Arbitrary options (passed to myloader)

• mydumper_backup_restore_databases: [default: mydumper_backup_backup_databases]: Restore declarations

• mydumper_backup_restore_databases.{n}.src: [required]: Database name (to)

• mydumper_backup_restore_databases.{n}.dest: [optional, default src]: Directory name (from)

• mydumper_backup_restore_databases.{n}.overwrite_tables: [optional, default mydumper_backup_overwrite_tables]: Drop any existing tables when restoring schemas

• mydumper_backup_backup_path: [default: /tmp]: Directory to back up to

• mydumper_backup_restore_path: [default: mydumper_backup_backup_path]: Directory to restore from

• mydumper_backup_backup_threads: [optional, default: 4]: Number of threads to use for backup (e.g. "{{ (ansible_processor_vcpus / 2) | round(0, 'ceil') }}")

• mydumper_backup_restore_threads: [optional, default: mydumper_backup_backup_threads]: Number of threads to use for restore

• mydumper_backup_host: [optional, default localhost]: The host to connect to

• mydumper_backup_user: [optional]: User with privileges to run the dump

• mydumper_backup_password: [optional]: User password

• mydumper_backup_verbose: [optional, default: 2]: The verbosity of messages (e.g. 0 = silent, 1 = errors, 2 = warnings, 3 = info)

• mydumper_backup_compress: [optional, default: false]: Compress output files

• mydumper_backup_build_empty_files: [optional, default: false]: Build dump files even if no data available from table

• mydumper_backup_triggers: [optional, default: false]: Whether to dump triggers

• mydumper_backup_overwrite_tables: [optional, default: false]: Drop any existing tables when restoring schemas

• mydumper_backup_enable_binlog: [optional, default: false]: Log the data loading in the MySQL binary log if enabled

Dependencies

None

Recommended

• ansible-mydumper (see)

Example(s)

Simple (all)

• Backup all databases
• Restore all databases

---
- hosts: all
  roles:
    - oefenweb.mydumper-backup
  vars:
    mydumper_backup_all: true
    mydumper_backup_overwrite_tables: true

Simple (all with ignore)

• Backup all databases ignore sakila
• Restore all databases

---
- hosts: all
  roles:
    - oefenweb.mydumper-backup
  vars:
    mydumper_backup_all: true
    mydumper_backup_all_regex: '^(?!(sakila\.))'

Simple (same src and dest)

• Backup database sakila to directory sakila
• Restore database sakila from directory sakila

---
- hosts: all
  roles:
    - oefenweb.mydumper-backup
  vars:
    mydumper_backup_backup_databases:
      - src: sakila
    mydumper_backup_overwrite_tables: true

Simple (different src and dest)

• Backup database sakila to directory alikas
• Restore database sakila from directory alikas

---
- hosts: all
  roles:
    - oefenweb.mydumper-backup
  vars:
    mydumper_backup_backup_databases:
      - src: sakila
        dest: alikas
    mydumper_backup_overwrite_tables: true

Advance (different configuration for backup and restore and different src and dest)

• Backup database a to directory b
• Restore database c from directory d

---
- hosts: all
  roles:
    - oefenweb.mydumper-backup
  vars:
    mydumper_backup_backup_databases:
      - src: a
        dest: b
    mydumper_backup_restore_databases:
      - src: c
        dest: d
    mydumper_backup_overwrite_tables: true

License

MIT

Author Information

Mischa ter Smitten

Feedback, bug-reports, requests, ...

Are welcome!