From f6cd196d2eade11a439177072f8b91d78a67fab3 Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Tue, 2 Feb 2010 04:36:29 +0100
Subject: added replication handling for consistent backups

---
 mysql/mysql_backup.sh | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/mysql/mysql_backup.sh b/mysql/mysql_backup.sh
index 5c73da0..a255314 100755
--- a/mysql/mysql_backup.sh
+++ b/mysql/mysql_backup.sh
@@ -41,6 +41,10 @@ _check_tools mysqlshow mysqldump ncftpput
 echo "Started backup of mysql databases ($(date +%c)):" | _log
 echo | _log
 
+# pause the replication to be able to do consistent backups
+echo "STOP SLAVE SQL_THREAD;" | mysql -h${MYSQL_SERVER} -u${MYSQL_USER} \
+    -p${MYSQL_PASSWORD}
+
 # create temporary dir
 mkdir -p ${TMP_DIRECTORY}
 TMP_DIR=$(mktemp -d --tmpdir=${TMP_DIRECTORY})
@@ -58,6 +62,10 @@ do
 	${db} | bzip2 -zc > "${BACKUP_PREFIX}_${db}.sql.bz2"
 done
 
+# restart the replication
+echo "START SLAVE SQL_THREAD;" | mysql -h${MYSQL_SERVER} -u${MYSQL_USER} \
+    -p${MYSQL_PASSWORD}
+
 # echo created log of file sizes
 du -sch * | _log
 echo | _log
-- 
cgit v1.2.3