Backup galera cluster

backup_mariadb_cluster.sh · 653 B · Bash Raw

1	#!/bin/bash
2	set -e
3
4	echo enter maintenance mode
5	maxctrl set server server_hs2 maintenance
6	mariadb -e "SET GLOBAL wsrep_desync = ON;"
7
8	backup_dir=$(mktemp -d)
9	backup_output=/tmp/backups
10
11	mkdir "$backup_output" \|\| true
12
13	cleanup () {
14	echo leaving maintenance mode
15	mariadb -e "SET GLOBAL wsrep_desync = OFF;"
16	maxctrl clear server server_hs2 maintenance
17	}
18	trap cleanup EXIT
19
20	echo running backup to "$backup_dir"
21	mariadb-backup --backup --target-dir="$backup_dir"
22
23	echo compressing
24	cd "$backup_output"
25	backup_file="dump-$(date +%Y-%m-%d_%H-%M-%S).tar.gz"
26	tar czvf "$backup_file" "."
27
28	echo backed up to "$backup_output/$backup_file"
29
30	rm -r "$backup_dir"