Use Xtrabackup full volume backup and restore MySQL database

First, Xtrabackup Simple overview:

Percona Xtrabackup is open source free MySQL database hot backup software, it can innodb and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add table lock). Xtrabackup supports all Percona servers, MySQL, mariadb, and drizzle.

Xtrabackup Advantages:

1, no need to stop the database for InnoDB hot standby

2. Incremental backup MySQL

3, stream compression to other servers

4, can easily create master-slave synchronization

5, backup MySQL does not increase server load

Second, the installation of Xtrabackup

First list the following my current server environment

Download Xtrabackup

[Root@localhost softs]# wget http://www.percona.com/downloads/XtraBackup/LATEST/RPM/rhel5/i386/ Percona-xtrabackup-2.1.6-702.rhel5.i386.rpm--2014-01-14 10:06:41--http://www.percona.com/downloads/XtraBackup/ latest/rpm/rhel5/i386/percona-xtrabackup-2.1.6-702.rhel5.i386.rpm

Resolving www.percona.com ... 74.121.199.234

........................ Omit partial content output here ...........

100%[==========================>] 8,662,225 360k/s in 32s

2014-01-14 10:07:43 (1448 kb/s)-' percona-xtrabackup-2.1.6-702.rhel5.i386.rpm ' saved [8662225/8662225]

RPM Package Direct Installation

[Root@localhost softs]# RPM-IVH percona-xtrabackup-2.1.6-702.rhel5.i386.rpm

error:failed dependencies:

Perl (Dbd::mysql) is needed by percona-xtrabackup-2.1.6-702.rhel5.i386

Here we need to resolve the dependency package, I am using the local yum installation directly

[Root@localhost softs]# Yum Install perl-dbd-mysql-y

[Root@localhost softs]# RPM-IVH percona-xtrabackup-2.1.6-702.rhel5.i386.rpm

Preparing ... ########################################### [100%]

1:percona-xtrabackup ########################################### [100%]

Successful after attempting to install again

After installing Xtrabackup, there will actually be several tools:

Innobackupex:

This is actually a Perl script package for the following three tools that can be backed up MyISAM, InnoDB, xtradb tables.

Xtrabackup:

A binary file compiled from C that can only back up InnoDB and xtradb data.

Xbcrypt:

The data used to encrypt or decrypt the backup.

Xbstream:

A compressed file used to decompress or compress xbstream formats.

It is recommended that you use the Perl encapsulated Innobackupex as a database backup because it is easier to use.

This column more highlights: http://www.bianceng.cn/database/MySQL/