1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
| #!/bin/bash
#
# 2014/12/16
# v5.1
# increment backup, with timestamp, compressed, with master & slave.
######################
s_port="$1"
s_action="$2"
s_slave="$3"
##### 配置参数 ######
##
f_my_cnf="/data/svr/mysql/my.cnf.${s_port}"
d_bak_base="/data/backup/mysql/${s_port}"
s_copies=6
s_password="xxx"
##
####################### 用法
function usage() {
cat <<EOF
[-] 用法: $0 port [full|incr|full_tar|full_stream] [slave]
$0 3306 full & 全备份，未压缩；完成后压缩前一天的备份；
$0 3306 incr & 增量备份，未压缩；完成后压缩前一天的备份；
$0 3306 full_tar & 全备份，未压缩；完成后，压缩这个备份；
$0 3306 full_stream & 全备份，边备份边压缩，stream=tar模式；
[-] 针对slave实例：
$0 3306 full slave &
$0 3306 incr slave &
$0 3306 full_tar slave &
$0 3306 full_stream slave &
[-] 针对crontab的配置：
+------------------------------+
# [mysql]
0 0 * * 6 $0 3306 full &
0 0 * * 0-5 $0 3306 incr &
+------------------------------+
EOF
exit 2
}
#######################
test ${s_port} -gt 0
if [ $? -gt 0 ]; then
echo "[+] Tips: 端口没有指定或者有误；"
usage
exit 3;
fi
if [ -z ${s_slave} ]; then
s_args="--defaults-file=${f_my_cnf} --host=127.0.0.1 --port=${s_port} --user=root --password=${s_password}"
else
s_args="--defaults-file=${f_my_cnf} --host=127.0.0.1 --port=${s_port} --user=root --password=${s_password} --slave-info --safe-slave-backup"
fi
d_bak_gz="${d_bak_base}/gz"
d_bak_tmp="${d_bak_base}/tmp"
d_bak_log="${d_bak_base}/log"
d_bak_full="${d_bak_base}/full"
f_bak_stream="${d_bak_full}/mysql-stream-$(date +%F).gz"
[ -d ${d_bak_gz} ] || mkdir -p ${d_bak_gz}
[ -d ${d_bak_tmp} ] || mkdir -p ${d_bak_tmp}
[ -d ${d_bak_log} ] || mkdir -p ${d_bak_log}
[ -d ${d_bak_full} ] || mkdir -p ${d_bak_full}
###################### 清理旧备份
function do_cleanup() {
echo "[-] `date` delete old files over ${s_copies} days ... "
find ${d_bak_gz} -type f -name "*.gz" -mtime +${s_copies} -print
find ${d_bak_gz} -type f -name "*.gz" -mtime +${s_copies} -delete
find ${d_bak_full} -type f -name "*.gz" -mtime +${s_copies} -print
find ${d_bak_full} -type f -name "*.gz" -mtime +${s_copies} -delete
find ${d_bak_log} -type f -name "*.log" -mtime +${s_copies} -print
find ${d_bak_log} -type f -name "*.log" -mtime +${s_copies} -delete
echo "[-] `date` done."
}
###################### 压缩今天之前的目录，清理旧备份
function do_tar_yesterday() {
local s_yesterday=$(date -d "1 day ago" +%F)
echo "[-] `date` waiting for file compression process ..."
cd ${d_bak_tmp}
ls |grep -v "`date +%F`" |xargs -i tar zcf "{}.tar.gz" {} --remove-files
echo "[-] `date` move: `ls *.gz` to: ${d_bak_gz}"
mv *.gz ${d_bak_gz}
do_cleanup
}
###################### 压缩指定目录
function do_tar() {
echo "[-] `date` waiting for file compression process ..."
cd ${d_bak_full}
ls |grep -v ".gz" |xargs -i tar zcf "{}.tar.gz" {} --remove-files
do_cleanup
}
###################### 全备份，未压缩；完成后压缩前一天的备份；
function do_full() {
echo "[+] `date` +------------------------Start--------------------+"
innobackupex ${s_args} ${d_bak_tmp}
echo "[-] `date` +------------------------cleanup------------------+"
do_tar_yesterday
echo "[-] `date` +------------------------The End------------------+"
}
###################### 增量备份，未压缩；完成后压缩前一天的备份；
function do_increment() {
echo "[+] `date` +------------------------Start--------------------+"
innobackupex --incremental ${s_args} ${d_bak_tmp}
echo "[-] `date` +------------------------cleanup------------------+"
do_tar_yesterday
echo "[-] `date` +------------------------The End------------------+"
}
###################### 全备份，未压缩；完成后，压缩这个备份；
function do_full_tar() {
echo "[+] `date` +------------------------Start--------------------+"
innobackupex ${s_args} ${d_bak_full}
echo "[-] `date` +------------------------cleanup------------------+"
do_tar
echo "[-] `date` +------------------------The End------------------+"
}
###################### 全备份，边备份边压缩，stream=tar模式；
function do_full_stream() {
echo "[+] `date` +------------------------Start--------------------+"
innobackupex --stream=tar ${s_args} ${d_bak_full} |gzip >${f_bak_stream}
echo "[-] `date` +------------------------cleanup------------------+"
do_cleanup
echo "[-] `date` +------------------------The End------------------+"
}
####################
case ${s_action} in
full)
do_full >"${d_bak_log}/$(date +%F_%H-%M-%S).log" 2>&1
;;
incr)
do_increment >"${d_bak_log}/$(date +%F_%H-%M-%S).log" 2>&1
;;
full_tar)
do_full_tar >"${d_bak_log}/$(date +%F_%H-%M-%S).log" 2>&1
;;
full_stream)
do_full_stream >"${d_bak_log}/$(date +%F_%H-%M-%S).log" 2>&1
;;
*)
usage
;;
esac
|
QQ群⑧：
窥视卡
雷达卡
发表于 2014-12-25 08:14:22
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡