KeepAlivedでHAした時のmysqlバックアップシェルスクリプト

keepalived-mysql-backup.sh

#!/bin/bash
/sbin/service keepalived stop

/usr/sbin/tmpwatch -m 50 /usr/local/mysqlbackup/backupdata

svr_name=`uname -n`

/usr/bin/mysqladmin stop-slave
sleep 3

/sbin/service mysqld stop

sleep 3
daystr=`date -d '1 days ago' '+%Y%m%d'`

cd /var/lib/mysql
tar czvf /usr/local/mysqlbackup/backupdata/$svr_name$daystr.tgz ./* > /dev/null 2>&1

/sbin/service mysqld start
/usr/bin/mysqladmin start-slave

sleep 3

/sbin/service keepalived start

exit