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 <jcre...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits