Forge Home

mysql_zrm

Manage Amanda mysql-zrm with Puppet

Abstract IT Pty Ltd

abstractit

9,908 downloads

9,244 latest version

3.6 quality score

Version information

  • 0.1.4 (latest)
  • 0.1.3
  • 0.1.2
  • 0.1.1
  • 0.1.0
released Mar 26th 2014

Start using this module

Documentation

abstractit/mysql_zrm — version 0.1.4 Mar 26th 2014

abstractit-mysql_zrm

####Table of Contents

  1. Overview - What is the mysql_zrm module?
  2. Module Description - What does the module do?
  3. How it works - The basics of getting started with mysql_zrm
  4. Usage - How to set it up
  5. Implementation - An under-the-hood peek at what the module is doing
  6. Limitations - OS compatibility, etc.
  7. Development - Guide for contributing to the module
  8. Support - Where to get support

Overview

Puppet module for setting up Zamanda MySQL-ZRM to backup databases from a MariaDB, Percona or MySQL server.

Module Description

Manages full and incremental backups of selected databases using MySQL-ZRM. It can use a server <-> client setup or the server can be installed directly onto your database server to do backups there. Backupsets can be setup on any node and get exported to the server of your choosing. At this stage it doesn't manage database users to do the backups due to the variety of ways to implement this. This may be implemented in a future release if I can find good modules for each server type.

How it works

what mysql_zrm affects:

  • configuration files for mysql_zrm
  • cron jobs to do the backups
  • expunging old backups

Usage

Setting up mysql_zrm

Automatic Client <-> Server mode.

# override these variables if needed.
`$mysql_zrm::params::db_servers` Array of database servers. (defaults to "db.${::domain}")
`$mysql_zrm::params::backup_server` (defaults to "backup.${::domain}")

Setting these variables will automaticlly include the server or client class.

# include this on your database and backup servers.
include mysql_zrm

Manual Client <-> Server mode

# include this on your database servers.
include mysql_zrm::client

# include this on your backup servers.
include mysql_zrm::server

Exporting backupsets for mysql_zrm servers

These will get exported to the

mysql_zrm::backupset { 'testing':
  databases        => 'test',
  fullhours        => ['0','12'],
  backup_db_user   => 'backup',
  backup_db_pass   => 'PASSWORD',
  backup_db_server => $::fqdn,
}   

title

Name for the backup

ensure

Whether to setup the backup set, defaults to present.

databases

Databases to backup.

fullhours

Hours to run the backup.

backup_db_user

Database user to use for the backup.

backup_db_pass

Password for the backup user.

backup_db_server

Database server.

Limitations

Backupset config files and crons need stored configs on your puppet master. I recommend using PuppetDB for this.

Development

All development, testing and releasing is done by Abstract IT at this stage. If you wish to join in let me know.

Support

Please log tickets on the github issues page https://github.com/abstractitptyltd/puppet-mysql_zrm/issues