mysql:5.6.29
xtrabackup:2.2.10
MySQL Data Catalog:/data/mysql
MySQL backup directory:/data/dbbak/full #确保有足够的磁盘空间
1. Installation dependent
-y install Libaio perl-Time-hires Perl-DBD-MySQL perl-IO- Socket-SSL rsync.x86_64
2, Installation Xtrabackup
-IVH percona-xtrabackup-2.2. Ten - 1. el6.x86_64.rpm
3. Create a backup account in the database
Mysql> CREATE USER 'Bkpuser'@'localhost'Identified by 'S3cret'; MySQL> GRANTRELOAD, LOCK TABLES,REPLICATIONClient,process on *.* to 'Bkpuser'@'localhost'; MySQL>FLUSHPrivileges;
4. Using Xbstream Backup
Time Innobackupex--user=bkpuser--password=s3cret--no-timestamp--defaults-file=/etc/my.cnf/data/dbbak/full--tmpdir=/data/dbbak/full-stream=xbstream|gzip- >/data/dbbak/full/full.xbstream.gz161124 Ten: ,: -Innobackupex:connection to DatabaseServer closed161124 Ten: ,: -innobackupex:completed ok!Real0m37.613sUser0m28.506ssys 0m3.186s Decompression time gzip-D Full. xbstream.gzReal0m26.678sUser0m13.405ssys 0m2.354stime Xbstream-X< Full. XbstreamReal1m7.379sUser0m6.055ssys 0m11.173s
5. Using a tar Backup
Time Innobackupex--user=bkpuser--password=s3cret--no-timestamp--defaults-file=/etc/my.cnf/data/dbbak/full--tmpdir=/data/dbbak/full--stream=tar |gzip->/ Data/dbbak/full/full.tar.gzInnobackupex:you must Use -I--ignore-zeros) option for extraction of the tar stream.161124 Ten: the: -innobackupex:completed ok!Real0m34.934sUser0m26.500ssys 0m2.816s decompression Time tar-Ixzvf/Data/Dbbak/ Full/ Full. tar.gzReal0m27.310sUser0m12.818ssys 0m3.735s or gzip-D/Data/Dbbak/ Full/ Full. Tar.gztar-Ixvf/Data/Dbbak/ Full/ Full. TAR.GZ recommends using tar-Ixzvf/Data/Dbbak/ Full/ Full. tar.gz Decompression
6. Compare 2 types of exported file sizes
[email protected]_166_129full] 95232-rw-R--r--1 root root 48704253 Nov 10:09 full.tar.gz -rw-R--r--1 root root 48809971 Nov 10:23 full.xbstream.gz
7. Summary
Using--stream=tar Backup, compression, decompression, has been compressed after the size is better than-stream=xbstream, recommend the use of--stream=tar mode compression, decompression can also be combined with tar.
Xtrabackup using stream to output and compress backups