使用shell脚本结合innobackupex自动备份mysql innodb数据库

上篇文章介绍了使用Xtrabackup备份mysql innodb数据库，这次给出一个自动备份的shell脚本，脚本每周六作一次完整备份，其它时间每天作一次增量备份。

#!/bin/bash
#检查命令是否执行成功
if_sucess(){
	local command="$1"
	$command
	if [ $? -ne 0 ];then
		echo "error."
		touch $error_lock_file
		exit 1
	fi	
}
#检查是否存在锁文件，如果存在就退出。
check_locked(){
	if [ -f  "$error_lock_file" ];then
		echo "error_lock_file found"
		exit 1
	fi	
}
 
#压缩备份一周的完整与增量备份
compress_old_backup(){
	if_sucess "tar czf $old_backup_file_temp $full_backup_dir $incr_backup_dir"
	rm -f $old_backup_file
	if_sucess "mv $old_backup_file_temp $old_backup_file"
	rm -rf $full_backup_dir $incr_backup_dir/*
}
#定义相关变量
backup_base=/data/mysql_backup
full_backup_dir=$backup_base/centos_full_backup
incr_backup_dir=$backup_base/centos_incr
sub_incr_dir=$(date +%w)
old_backup_file=$backup_base/old/centos_old.tar.gz
old_backup_file_temp=$backup_base/old/centos_old_temp.tar.gz
user=www.centos.bz
password=123456
defaults_file=/etc/mysql/my.cnf
include_db="centos.*|mysql.*"
error_lock_file=$backup_base/error.locked
 
#程序从这里开始
check_locked
mkdir -p  $incr_backup_dir $backup_base/old 
 
#周六就作完整备份，其它时间增量备份。
if [ $sub_incr_dir -eq 6 ];then
	[ -d "$full_backup_dir" ] && compress_old_backup
	if_sucess "innobackupex --user=$user --password=$password  --defaults-file=$defaults_file --no-timestamp --include=$include_db  $full_backup_dir"
	echo "incr_base_dir=$full_backup_dir" > $full_backup_dir/incr_base_dir.txt
else
	[ -f "$full_backup_dir/incr_base_dir.txt" ] && . $full_backup_dir/incr_base_dir.txt || exit 1
	if_sucess "innobackupex --user=$user --password=$password  --defaults-file=$defaults_file --incremental $incr_backup_dir/$sub_incr_dir --no-timestamp  --include=$include_db --incremental-basedir=$incr_base_dir"
	echo "$incr_base_dir=$incr_backup_dir/$sub_incr_dir" > $full_backup_dir/incr_base_dir.txt	
fi