MySQL backup script based on Innobackupex

MySQL backup script based on Innobackupex

Innobackupex is part of Xtrabackup, and its essence is to call xtrabackup. The main difference is that Xtrabackup not only supports the innodb engine, but also supports the xtradb engine. This article mainly encapsulates Innobackupex to shell scripts for regular backup for your reference.

1. Script description
A. Support Incremental backup and full backup
B. It must be passed to the backup script (such as the backup path and connection parameters)
C. Full backup Based on Sunday and Wednesday, and other Incremental Backup
D. You can adjust the script as needed, such as compressing the backup folder and rsync.

2. Script content

######################################## ########################################
# File: innobk. sh #
# Author: Leshami #
# Blog:

MySQL open-source backup tool Xtrabackup backup deployment

MySQL Xtrabackup backup and recovery

Use XtraBackup to implement MySQL master-slave replication and quick deployment [master-slave table lock-free]

Install and use Xtrabackup from Percona to back up MySQL

XtraBackup details: click here
XtraBackup: click here

This article permanently updates the link address: