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