Elukey has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/364195 )
Change subject: role::piwik::server: add regular bacula backups ...................................................................... role::piwik::server: add regular bacula backups Bug: T164073 Change-Id: Id35e45c1fa848c634b6dd893927b139276c66f35 --- A modules/profile/manifests/piwik/backup.pp M modules/role/manifests/piwik/server.pp 2 files changed, 41 insertions(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/95/364195/1 diff --git a/modules/profile/manifests/piwik/backup.pp b/modules/profile/manifests/piwik/backup.pp new file mode 100644 index 0000000..c9909bb --- /dev/null +++ b/modules/profile/manifests/piwik/backup.pp @@ -0,0 +1,39 @@ +# == Class: profile::piwik::backup +# +# Periodical backups of the Piwik database tables using Bacula. +# +class profile::piwik::backup ( + $backup_username = hiera('profile::piwik::backup_username'), + $backup_password = hiera('profile::piwik::backup_password'), +) { + include ::profile::backup::host + + file { '/srv/backups': + ensure => directory, + owner => 'root', + group => 'root', + mode => '0600', # implicitly 0700 for dirs + } + + file { '/etc/mysql/conf.d/dumps.cnf': + ensure => present, + owner => 'root', + group => 'root', + mode => '0400', + content => "[client]\nuser=${backup_username}\npassword=${backup_password}\n", + } + + backup::mysqlset {'piwik': + xtrabackup => false, + per_db => true, + innodb_only => true, + binlog => false, + slave => false, + local_dump_dir => '/srv/backups', + password_file => '/etc/mysql/conf.d/dumps.cnf', + method => 'predump', + mysql_binary => '/usr/bin/mysql', + mysqldump_binary => '/usr/bin/mysqldump', + jobdefaults => "Weekly-${profile::backup::host::day}-${profile::backup::host::pool}", + } +} diff --git a/modules/role/manifests/piwik/server.pp b/modules/role/manifests/piwik/server.pp index 2d4bbfe..61dee0d 100644 --- a/modules/role/manifests/piwik/server.pp +++ b/modules/role/manifests/piwik/server.pp @@ -4,9 +4,10 @@ include ::standard include ::profile::piwik::webserver include ::profile::piwik::instance + # override profile::backup::enable to disable regular backups + include ::profile::piwik::backup # TODO - puppetization of mysql instance - # Ref: T159136 require_package('mysql-server') system::role { 'piwik::server': -- To view, visit https://gerrit.wikimedia.org/r/364195 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Id35e45c1fa848c634b6dd893927b139276c66f35 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Elukey <ltosc...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits