Download link: wgetwww. percona. xtrabackup-2.1.2-611
Xtrabackup-2.1.2-611 download link: wget http://www.percona.com/downloads/XtraBackup/XtraBackup-2.1.2/binary/Linux/x86_64/perc
Xtrabackup-2.1.2-611 download link:
Wget
Install the dependent packages required for compilation
Yum install libaio-devel perl-Time-HiRes curl-devel zlib-devel openssl-devel perl cpio expat-devel gettext-devel perl-ExtUtils-MakeMaker perl-DBD-MySQL. * package-y
Tar xvf percona-xtrabackup-2.1.2-611.tar.gz
Cd/percona-xtrabackup-2.1.2/bin/
[Root @ CcTalk-DB bin] # ll
Total 112420
-Rwxr-xr-x 1 root 110729 May 18 innobackupex
Lrwxrwxrwx 1 root 12 Aug 23 13:25 innobackupex-1.5.1-> innobackupex
-Rwxr-xr-x 1 root 2211237 May 18 xbcrypt
-Rwxr-xr-x 1 root 2285672 May 18 xbstream
-Rwxr-xr-x 1 root 13033745 May 18 xtrabackup
-Rwxr-xr-x 1 root 16333506 May 18 xtrabackup_55
-Rwxr-xr-x 1 root 80988093 May 18 xtrabackup_56
[Root @ CcTalk-DB bin] #
Recommended reading:
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
3. copy files such as innobackupex and xtrabackup to the/bin and directory of the mysql program.
Cp */usr/local/mysql/bin/
4. Soft link the files in the mysql installation directory to the/usr/bin/directory. This is more convenient than variables, so deployment and installation are completed !!!
Ln-s/usr/local/mysql/bin/*/usr/bin/
5. Verification:
Run the following command and press the tab key to automatically complete the association!
[Root @ slave1 ~] # Innobackupex
Innobackupex-1.5.1 innobackupex
[Root @ slave1 ~] # Xtrabackup
Xtrabackup xtrabackup_55 xtrabackup_56
[Root @ CcTalk-DB bin] # innobackupex -- help
Options:
-- Apply-log
Prepare a backup in BACKUP-DIR by applying the transaction log file
Named "xtrabackup_logfile" located in the same directory. Also,
Create new transaction logs. The InnoDB configuration is read from
The file "backup-my.cnf ".
-- Compact
Create a compact backup with all secondary index pages omitted. This
Option is passed directly to xtrabackup. See xtrabackup
Documentation for details.
-- Compress
This option instructs xtrabackup to compress backup copies of InnoDB
Data files. It is passed directly to the xtrabackup child process.
Try 'xtrabackup -- help' for more details.
-- Compress-threads
This option specifies the number of worker threads that will be used
For parallel compression. It is passed directly to the xtrabackup
Child process. Try 'xtrabackup -- help' for more details.
-- Compress-chunk-size
This option specifies the size of the internal working buffer
Each compression thread, measured in bytes. It is passed directly
The xtrabackup child process. Try 'xtrabackup -- help' for more
Details.
-- Copy-back
Copy all the files in a previusly made backup from the backup
Directory to their original locations.
-- Databases = LIST
This option specifies the list of databases that innobackupex shocould
Back up. The option accepts a string argument or path to file that
Contains the list of databases to back up. The list is of the form
"Databasename1 [. table_name1] databasename2 [. table_name2]...". If
This option is not specified, all databases containing MyISAM and
InnoDB tables will be backed up. Please make sure that -- databases
Contains all of the InnoDB databases and tables, so that all of
Innodb. frm files are also backed up. In case the list is very long,
This can be specified in a file, and the full path of the file can
Be specified instead of the list. (See option -- tables-file .)
-- Debug-sleep-before-unlock = SECONDS
This is a debug-only option used by the XtraBackup test suite.
-- Defaults-file = [MY. CNF]
This option specifies what file to read the default MySQL options
From. The option accepts a string argument. It is also passed
Directly to xtrabackup's -- defaults-file option. See the xtrabackup
Documentation for details.