Ryan Lane has uploaded a new change for review.
https://gerrit.wikimedia.org/r/55015
Change subject: Use mysqldump --single-transaction where possible
......................................................................
Use mysqldump --single-transaction where possible
Change-Id: I14e6838a185ec8d84206bfa8f55583b6866823dd
---
M files/openstack/db-bak.sh
1 file changed, 6 insertions(+), 5 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/15/55015/1
diff --git a/files/openstack/db-bak.sh b/files/openstack/db-bak.sh
index 8d56636..88a7497 100644
--- a/files/openstack/db-bak.sh
+++ b/files/openstack/db-bak.sh
@@ -1,10 +1,11 @@
#!/bin/bash
-for i in `mysql -BNe 'show databases'`
+for i in labswiki keystone nova
do
- if [ "${i}" == "information_schema" ]
- then
- continue
- fi
+ nice -n 19 mysqldump --single-transaction -u root ${i} -c | nice -n 19
gzip -9 > /a/backup/${i}-$(date '+%Y%m%d').sql.gz
+done
+
+for i in glance mysql
+do
nice -n 19 mysqldump -u root ${i} -c | nice -n 19 gzip -9 >
/a/backup/${i}-$(date '+%Y%m%d').sql.gz
done
--
To view, visit https://gerrit.wikimedia.org/r/55015
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I14e6838a185ec8d84206bfa8f55583b6866823dd
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Ryan Lane <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
