blob: be63cd93887a3c3cf90e8675ade2f088341cccf3 (
plain)
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
|
#!/usr/bin/env bash
set -eu
set -o pipefail
# Execute a full backup
backup_full() {
echo "Taking a full backup"
LAST_FULL_DATE=$(date +%d-%m-%Y-%s)
BACKUP_FILE="mysqlbackup-${LAST_FULL_DATE}.qp.xbc.xbs.gz"
BACKUP_PATH="$BACKUP_DIR/full-${LAST_FULL_DATE}"
mkdir -p "$BACKUP_PATH"
mariabackup \
--defaults-file=/etc/mysql/my.cnf \
--backup \
--stream=xbstream \
--history=$LAST_FULL_DATE | gzip > \
"$BACKUP_PATH/$BACKUP_FILE"
echo "$BACKUP_PATH/$BACKUP_FILE" > "$BACKUP_DIR/last_full_file"
}
# Execute an incremental backup
backup_incremental() {
echo "Taking an incremental backup"
if [ ! -r "$BACKUP_DIR/last_full_file" ]; then
echo "Error: No full backup file found."
exit 1
fi
FULL_BACKUP_FILE=$(cat "$BACKUP_DIR/last_full_file")
LAST_FULL_DATE=$(basename "$(dirname "$FULL_BACKUP_FILE")" | sed 's/^full-//')
NOW=$(date +%H-%M-%S-%d-%m-%Y)
INCR_DIR="$BACKUP_DIR/incr-${NOW}-since-${LAST_FULL_DATE}"
mkdir -p "$INCR_DIR"
TMP_BASEDIR=$(mktemp -d)
echo "Decompressing full backup to temp dir: $TMP_BASEDIR"
gunzip -c "$FULL_BACKUP_FILE" | mbstream -x -C "$TMP_BASEDIR"
mariabackup \
--defaults-file=/etc/mysql/my.cnf \
--backup \
--stream=xbstream \
--incremental-basedir="$TMP_BASEDIR" \
--history="incr-${NOW}" | gzip > \
"$INCR_DIR/incremental-${NOW}-mysqlbackup-${LAST_FULL_DATE}.qp.xbc.xbs.gz"
rm -rf "$TMP_BASEDIR"
}
BACKUP_DIR=/backup/
cd "$BACKUP_DIR"
if [ -n "${BACKUP_TYPE:-}" ]; then
case "$BACKUP_TYPE" in
"full")
backup_full
;;
"incremental")
backup_incremental
;;
*)
echo "Only full or incremental options are supported."
exit 1
;;
esac
else
echo "You need to specify either full or incremental backup options."
exit 1
fi
|
