Forge Home

dbbackup

Install a generic database backup solution for mysql and postgres

1,839 downloads

273 latest version

5.0 quality score

Version information

  • 1.2.0 (latest)
  • 1.1.1
  • 1.1.0
  • 1.0.1
  • 1.0.0
released Apr 20th 2022
This version is compatible with:
  • Puppet Enterprise 2021.6.x, 2021.5.x, 2021.4.x, 2021.3.x, 2021.2.x, 2021.1.x, 2021.0.x, 2019.8.x, 2019.7.x, 2019.5.x, 2019.4.x, 2019.3.x, 2019.2.x, 2019.1.x
  • Puppet >= 6.1.0 < 8.0.0
  • , Archlinux

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'puppet-dbbackup', '1.2.0'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add puppet-dbbackup
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install puppet-dbbackup --version 1.2.0

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

puppet/dbbackup — version 1.2.0 Apr 20th 2022

puppet-dbbackup

Build Status Release Puppet Forge Puppet Forge - downloads Puppet Forge - endorsement Puppet Forge - scores puppetmodule.info docs AGPL v3 License

Table of Contents

Overview

This is a module for deploying a backup solution for mysql,postgresql and LDAP databases.

It configures two things, the dump_databases script in /usr/local/bin/, and a sytemd timer+service to start it. multiple parameters are exposed to configure the history you want to keep and also the backup interval. All parameters have puppet-strings documentation in the REFERENCE.md. Dependingon the database you backup, multiple CLI tools are required:

  • psql
  • pg_dumpall
  • mysql
  • mysqldump
  • slapcat
  • pigz

The script always assumes that it's executed on the same machine that runs the database. The dependencies aren't managed by this module.

Example configuration

You can simply include the class and it will do dumps every 1 hour and never delete them:

include dbbackup

you can also configure parameter via Hiera or Puppet DSL. An example:

dbbackup::backuphistory: 730
dbbackup::destination: '/var/dumps'
dbbackup::interval: '2h'

Tests

This module has several unit tests and linters configured. You can execute them by running:

bundle exec rake test

Detailed instructions are in the CONTRIBUTING.md file.

Contributions

Contribution is fairly easy:

  • Fork the module into your namespace
  • Create a new branch
  • Commit your bugfix or enhancement
  • Write a test for it (maybe start with the test first)
  • Create a pull request

Detailed instructions are in the CONTRIBUTING.md file.

License and Author

This module was originally written by Tim Meusel. It's licensed with AGPL version 3.