Mercurial > repos > other > Puppet
view modules/mysql/manifests/backup/xtrabackup.pp @ 26:58d1818c2ded puppet-3.6
Update MySQL module (which adds "staging" module)
author | IBBoard <dev@ibboard.co.uk> |
---|---|
date | Mon, 09 Mar 2015 01:34:59 +0000 |
parents | |
children | 48d3a1948e4d |
line wrap: on
line source
# See README.me for usage. class mysql::backup::xtrabackup ( $backupuser, $backuppassword, $backupdir, $backupmethod = 'mysqldump', $backupdirmode = '0700', $backupdirowner = 'root', $backupdirgroup = 'root', $backupcompress = true, $backuprotate = 30, $ignore_events = true, $delete_before_dump = false, $backupdatabases = [], $file_per_database = false, $ensure = 'present', $time = ['23', '5'], $postscript = false, $execpath = '/usr/bin:/usr/sbin:/bin:/sbin', ) { mysql_user { "${backupuser}@localhost": ensure => $ensure, password_hash => mysql_password($backuppassword), provider => 'mysql', require => Class['mysql::server::root_password'], } package{ 'percona-xtrabackup': ensure => $ensure, } cron { 'xtrabackup-weekly': ensure => $ensure, command => 'innobackupex $backupdir', user => 'root', hour => $time[0], minute => $time[1], weekday => 0, require => Package['percona-xtrabackup'], } cron { 'xtrabackup-daily': ensure => $ensure, command => 'innobackupex --incremental $backupdir', user => 'root', hour => $time[0], minute => $time[1], weekday => 1-6, require => Package['percona-xtrabackup'], } file { 'mysqlbackupdir': ensure => 'directory', path => $backupdir, mode => $backupdirmode, owner => $backupdirowner, group => $backupdirgroup, } }