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 <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
