Skip to content

nlware/ansible-mydumper-backup

This branch is up to date with Oefenweb/ansible-mydumper-backup:master.

Folders and files

NameName
Last commit message
Last commit date
Feb 23, 2024
Mar 15, 2021
May 11, 2015
Mar 15, 2021
Feb 23, 2024
Mar 31, 2023
Mar 31, 2023
Apr 19, 2020
Mar 15, 2021
Mar 15, 2021
Mar 31, 2023
Jul 13, 2015
Feb 18, 2021
Mar 31, 2023
May 11, 2015
Nov 2, 2023
Feb 23, 2024
Mar 31, 2023

Repository files navigation

mydumper-backup

CI Ansible Galaxy

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 or not to backup all databases. When true, disables databases options

  • 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 or not to restore all databases. When true, disables databases options

  • 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 backup 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 or not 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!

About

Ansible role to perform backups using mydumper

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Shell 90.8%
  • Dockerfile 9.2%