Xtrabackup-2.1.2-611 installation _ MySQL

Install bitsCN.com in 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/percona-xtrabackup-2.1.2-611.tar.gz

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] #

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.

-- Defaults-extra-file = [MY. CNF]

This option specifies what extra file to read the default MySQL

Options from before the standard defaults-file. The option accepts

String argument. It is also passed directly to xtrabackup's

-- Defaults-extra-file option. See the xtrabackup documentation

Details.

-- Encrypt = ENCRYPTION_ALGORITHM

This option instructs xtrabackup to encrypt backup copies of InnoDB

Data files using the algorithm specified in

ENCRYPTION_ALGORITHM. It is passed directly to the xtrabackup child

Process. Try 'xtrabackup -- help' for more details.

-- Encrypt-key = ENCRYPTION_KEY

This option instructs xtrabackup to use the given ENCRYPTION_KEY

When using the -- encrypt option. It is passed directly to

Xtrabackup child process. Try 'xtrabackup -- help' for more details.

-- Encrypt-key-file = ENCRYPTION_KEY_FILE

This option instructs xtrabackup to use the encryption key stored in

The given ENCRYPTION_KEY_FILE when using the -- encrypt option. It is

Passed directly to the xtrabackup child process. Try 'xtrabackup

-- Help' for more details.

-- Encrypt-threads

This option specifies the number of worker threads that will be used

For parallel encryption. It is passed directly to the xtrabackup

Child process. Try 'xtrabackup -- help' for more details.

-- Encrypt-chunk-size

This option specifies the size of the internal working buffer

Each encryption thread, measured in bytes. It is passed directly

The xtrabackup child process. Try 'xtrabackup -- help' for more

Details.

-- Export

This option is passed directly to xtrabackup's -- export option. It

Enables exporting inpidual tables for import into another server.

See the xtrabackup documentation for details.

-- Extra-lsndir = DIRECTORY

This option specifies the directory in which to save an extra copy

Of the "xtrabackup_checkpoints" file. The option accepts a string

Argument. It is passed directly to xtrabackup's -- extra-lsndir

Option. See the xtrabackup documentation for details.

-- Galera-info

This options creates the xtrabackup_galera_info file which contians

The local node state at the time of the backup. Option shocould be

Used when login Ming the backup of Percona-XtraDB-Cluster.

-- Help

This option displays a help screen and exits.

-- Host = HOST

This option specifies the host to use when connecting to

Database server with TCP/IP. The option accepts a string argument.

It is passed to the mysql child process without alteration. See

Mysql -- help for details.

-- Ibbackup = IBBACKUP-BINARY

This option specifies which xtrabackup binary shocould be used.

Option accepts a string argument. IBBACKUP-BINARY shocould be

Command used to run XtraBackup. The option can be useful if

Xtrabackup binary is not in your search path or working directory.

If this option is not specified, innobackupex attempts to determine

The binary to use automatically. By default, "xtrabackup" is

Command used. However, when option -- copy-back is specified,

"Xtrabackup_51" is the command used. And when option -- apply-log is

Specified, the binary is used whose name is in the file

"Xtrabackup_binary" in the backup directory, if that file exists.

-- Include = REGEXP