Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/234503
Change subject: Save binary log coordinates from the master and the slave on
backup
......................................................................
Save binary log coordinates from the master and the slave on backup
Right now, backups are performed, but no binary log coordinates
are saved, which makes them useless except for "best effort"
backups.
Change-Id: Ia87879f8d888efd10bd2cea771e75dd6d7b50e35
---
M templates/mariadb/dumps-misc.sh.erb
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/03/234503/1
diff --git a/templates/mariadb/dumps-misc.sh.erb
b/templates/mariadb/dumps-misc.sh.erb
index 9658803..5814cbd 100644
--- a/templates/mariadb/dumps-misc.sh.erb
+++ b/templates/mariadb/dumps-misc.sh.erb
@@ -3,7 +3,7 @@
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="/usr/local/bin/mysqldump --single-transaction --master-data=2
--dump-slave=2 --include-master-host-port --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 &
--
To view, visit https://gerrit.wikimedia.org/r/234503
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia87879f8d888efd10bd2cea771e75dd6d7b50e35
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
