Springle has uploaded a new change for review.
https://gerrit.wikimedia.org/r/207680
Change subject: script used for non-replicated dbstore backups
......................................................................
script used for non-replicated dbstore backups
Bug: T95835
Change-Id: I90ee834c2157783e79bb4118f3fe1603ec1646ca
---
M manifests/role/mariadb.pp
A templates/mariadb/dumps-misc.sh.erb
2 files changed, 34 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/80/207680/1
diff --git a/manifests/role/mariadb.pp b/manifests/role/mariadb.pp
index 69d3694..c2f27cd 100644
--- a/manifests/role/mariadb.pp
+++ b/manifests/role/mariadb.pp
@@ -281,6 +281,14 @@
lag_crit => $lag_crit,
warn_stopped => $warn_stopped,
}
+
+ file { '/usr/local/bin/dumps-misc.sh':
+ ensure => present,
+ owner => 'root',
+ group => 'root',
+ mode => '0755',
+ content => template('mariadb/dumps-misc.sh.erb'),
+ }
}
# MariaDB 10 Analytics all-shards slave, with scratch space and TokuDB
diff --git a/templates/mariadb/dumps-misc.sh.erb
b/templates/mariadb/dumps-misc.sh.erb
new file mode 100644
index 0000000..6803654
--- /dev/null
+++ b/templates/mariadb/dumps-misc.sh.erb
@@ -0,0 +1,26 @@
+#!/bin/bash
+
+find /srv/backups -mtime +14 -type f -delete
+
+my="/usr/local/bin/mysql --skip-column-names -e"
+dump="/usr/local/bin/mysqldump --single-transaction --quick"
+
+$dump -h m1-slave --databases bacula etherpadlite librenms puppet racktables
rt | \
+ pigz > /srv/backups/m1-$(date +%Y%m%d%H%M%S).sql.gz &
+
+$dump -h m2-slave --databases iegreview reviewdb scholarships | \
+ pigz > /srv/backups/m2-$(date +%Y%m%d%H%M%S).sql.gz &
+
+$dump -h m2-slave --max_allowed_packet=64M --databases otrs | \
+ pigz > /srv/backups/m2-otrs-$(date +%Y%m%d%H%M%S).sql.gz &
+
+sql="select schema_name from information_schema.schemata where schema_name
regexp '^(phab|phlegal)'"
+
+$dump -h m3-slave --ignore-table=phabricator_search.search_documentfield \
+ --databases $($my "$sql" | tr '\n' ' ') | \
+ pigz > /srv/backups/m3-phabricator-phlegal-$(date +%Y%m%d%H%M%S).sql.gz
+
+sql="select schema_name from information_schema.schemata where schema_name
regexp '^(wik|flowdb)'"
+
+$dump -h x1-slave --databases $($my "$sql" | tr '\n' ' ') | \
+ pigz > /srv/backups/x1-$(date +%Y%m%d%H%M%S).sql.gz
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/207680
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I90ee834c2157783e79bb4118f3fe1603ec1646ca
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Springle <sprin...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
