Autoxtrabackup script for Percona 8
- Copy default
autoextrabackup
file to /etc/default directory - Edit file to adjust parameters
- Copy
autoxtrabackup8.sh
to /usr/local/bin directory - Make the script executable
- Add to cron jobs
- Decompress
xtrabackup --decompress --remove-original --parallel=4 --target-dir=$BACKUP_DIR/FULL
- Prepare
xtrabackup --prepare --apply-log-only --target-dir=$BACKUP_DIR/FULL
- Stop mysqld
- Move backup to mysql datadir
rm -rf $DATA_DIR/*
mv $BACKUP_DIR/* $DATA_DIR/
- Restart mysqld
- Decompress
xtrabackup --decompress --remove-original --parallel=4 --target-dir=$BACKUP_DIR/FULL
- Prepare
xtrabackup --prepare --apply-log-only --target-dir=$BACKUP_DIR/inc
- Prepare incremental
xtrabackup --prepare --apply-log-only --target-dir=$BACKUP_DIR/FULL --incremental-dir=$BACKUP_DIR/inc
- Stop mysqld
- Move backup to mysql datadir
rm -rf $DATA_DIR/*
mv $BACKUP_DIR/* $DATA_DIR/
- Restart mysqld