MySQL Xtrabackup backup and recovery

Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup has two main tools: xtrabackup and innobackupex. xtrabackup can only back up InnoDB and XtraDB data tables. innobackupex encapsulates xtrabackup and can back up MyISAM data tables. 1. install mysql 2. install Xtrabackup and download the Xtrabackup configuration source # vi/etc/yum. repos. d/percona. repo Java code [percona] name = CentOS $ releasever-Percona baseurl = http://repo.percona.com/centos/ $ Releasever/OS/$ basearch/enabled = 1 gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona Gpgcheck = 1 add key # cd/etc/pki/rpm-gpg # wget http://www.percona.com/downloads/RPM-GPG-KEY-percona Install Xtrabackup yum install xtrabackup 3 backup # xtrabackup -- backup -- datadir =/var/lib/mysql/-- target-dir =/data/backups/mysql/4 recover backup data. stop MySQL service: $/etc/init. d/mysqld stop or service mysql stop B. modify my. cnf datadir to the backup directory: datadir =/data/backups/mysql/c. start MySQL service: $/etc/init. d/mysqld start the latter service mysql start is quite simple. As for Incremental backup, the directory xtrabackup -- backup -- target-dir =/data/backups/inc1 -- incremental-basedir =/data/backups/base -- datadir =/var must be specified during backup. /lib/mysql/author instance