安装介绍篇

作者: 数据库信息  发布:2019-08-22

** 

Percona XtraBackup 安装介绍篇,perconaxtrabackup

** 

XtraBackup介绍

 

XtraBackup是Percona集团的开源项目,用以达成类似Innodb官方的热备份工具InnoDB Hot Backup的机能,它补助在线热备份(备份时不影响多少读写)。到近年来停止,最新的本子为Percona XtraBackup 2.4.7.

 

XtraBackup有非常多效用和优点:比如支持全备、增量备份、部分备份;补助压缩备份;备份不影响多少读写、事务等,不过也万分不足:举个例子不支持脱机备份、不支持直接备份到磁带设备、不支持Cloud Back,MyISAM的备份也会卡住。可是这么些小缺点不影响XtraBackup成为一款流行的MySQL备份工具。别的,请小心XtraBackup只援助Linux平台,不援救Windows平台。

 

上面是XtraBackup的合阿尔巴尼亚语档的介绍资料:

 

Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking

backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:

 

• Backups that complete quickly and reliably

• Uninterrupted transaction processing during backups

• Savings on disk space and network bandwidth

• Automatic backup verification

• Higher uptime due to faster restore time

 

Percona XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, and MariaDB. It performs

streaming, compressed, and incremental MySQL backups.

 

Percona XtraBackup works with MySQL, MariaDB, and Percona Server. It supports completely non-blocking backups

of InnoDB, XtraDB, and HailDB storage engines. In addition, it can back up the following storage engines by briefly

pausing writes at the end of the backup: MyISAM, Merge, and Archive, including partitioned tables, triggers, and

database options.

 

 

Percona  XtraBackup的特征:

** 

 

Features

Percona  XtraBackup

License

GPL

Pirce

Free

Streaming and encryption formats

Open source

Supported MySQL flavors

MySQL, Percona Server, MariaDB, Percona XtraDB Cluster, MariaDB Supported

Supported operating systems

Linux

Non-blocking InnoDB backups

Yes

Blocking MyISAM backups

Yes

Incremental backups

Yes

Full compressed backups

Yes

Incremental compressed backups

Yes

Fast incremental backups

Yes

Incremental backups with archived logs feature in Percona Server

Yes

Incremental backups with REDO log only

 

Backup locks

Yes

Encrypted backups

Yes

Streaming backups

Yes

Parallel local backups

Yes

Parallel compression

Yes

Parallel encryption

Yes

Parallel apply-log

Yes

Parallel copy-back

 

Partial backups

Yes

Partial backups of individual partitions

Yes

Throttling

Yes

Backup image validation

 

Point-in-time recovery support

Yes

Safe slave backups

Yes

Compact backups

Yes

Buffer pool state backups

Yes

Individual tables export

Yes

Individual partitions export

Yes

Restoring tables to a different server

Yes

Data & index file statistics

Yes

InnoDB secondary indexes defragmentation

Yes

rsync support to minimize lock time

Yes

Improved FTWRL handlin

Yes

Backup history table

 

Backup progress table

 

Backup to tape media managers

 

Cloud backups support

 

External graphical user interfaces to backup/recovery Zmanda Recovery

Zmanda Recovery Manager for MySQL

 

 

XtraBackup下载

 

XtraBackup能够从官方链接 XtraBackup Documentation相关文书档案下载。 下载的时候,注意版本与平台音信。

 

   Percona XtraBackup的源码放在Github 上,地址为

 

   Percona XtraBackup的文书档案地址:

 

       

 

       

 

       

 

 

XtraBackup安装

 

Percona XtraBackup的装置情势完全来讲有下边三种,大家下边简单的牵线一下。然后都切实都练练手。

 

Installing Percona XtraBackup from Repositories (recommended)

Installing Percona XtraBackup from Downloaded rpm or apt Packages

Compiling and Installing from Source Code

 

1:Installing Percona XtraBackup from Repositories

 

Installing Percona XtraBackup on Red Hat Enterprise Linux and CentOS

 

 

 

上面作者测量检验的条件为CentOS Linux release 7.2.1511 (Core) ,安装Percona XtraBackup 2.4为例:

 

 

步骤1: Install the Percona repository

 

[[email protected] ~]$ sudo yum install https://www.percona.com/downloads/percona-release/redhat/latest/percona-release-0.1-4.noarch.rpm

[sudo] password for test: 

/usr/local/bin/aad-login failed: exit code 1

Loaded plugins: fastestmirror, langpacks

percona-release-0.1-4.noarch.rpm                         | 6.4 kB     00:00     

Examining /var/tmp/yum-root-02R3Gm/percona-release-0.1-4.noarch.rpm: percona-release-0.1-4.noarch

Marking /var/tmp/yum-root-02R3Gm/percona-release-0.1-4.noarch.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package percona-release.noarch 0:0.1-4 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

 

================================================================================

 Package            Arch      Version    Repository                        Size

================================================================================

Installing:

 percona-release    noarch    0.1-4      /percona-release-0.1-4.noarch    5.8 k

 

Transaction Summary

================================================================================

Install  1 Package

 

Total size: 5.8 k

Installed size: 5.8 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

  Installing : percona-release-0.1-4.noarch                                 1/1 

  Verifying  : percona-release-0.1-4.noarch                                 1/1 

 

Installed:

  percona-release.noarch 0:0.1-4                                                

 

Complete!

 

猎豹CS6HEL/Centos 5不扶助从远程地方一向设置软件包,由此你供给首先下载软件包,然后用rpm手动安装

 

$ wget http://www.percona.com/downloads/percona-release/redhat/0.1-4/

percona-release-0.1-4.noarch.rpm

$ rpm -ivh percona-release-0.1-4.noarch.rpm

 

安装完毕后,你就能够在/etc/yum.repos.d 下看到二个percona-release.repo文件。

 

 

 

手续2: 测验Repository,确认保证Percona XtraBackup相关包已经在Repository中。

 

 

[[email protected] ~]$ yum list | grep percona-xtrabackup

percona-xtrabackup-24.x86_64               2.4.7-2.el7                 @percona-release-x86_64

percona-xtrabackup.x86_64                  2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-22.x86_64               2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-22-debuginfo.x86_64     2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-24-debuginfo.x86_64     2.4.7-2.el7                 percona-release-x86_64

percona-xtrabackup-debuginfo.x86_64        2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-test.x86_64             2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-test-22.x86_64          2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-test-24.x86_64          2.4.7-2.el7                 percona-release-x86_64

 

 

 

步骤3:安装Percona XtraBackup包。

 

 

[[email protected] ~]$ yum install percona-xtrabackup-24

 

[[email protected] ~]# yum install percona-xtrabackup-24

Loaded plugins: fastestmirror, langpacks

Loading mirror speeds from cached hostfile

Resolving Dependencies

--> Running transaction check

---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el7 will be installed

--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Processing Dependency: perl(Digest::MD5) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Running transaction check

---> Package libev.x86_64 0:4.15-6.el7 will be installed

---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed

---> Package perl-Digest-MD5.x86_64 0:2.52-3.el7 will be installed

--> Processing Dependency: perl(Digest::base) >= 1.00 for package: perl-Digest-MD5-2.52-3.el7.x86_64

--> Running transaction check

---> Package perl-Digest.noarch 0:1.17-245.el7 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

 

===========================================================================================

 Package                         Arch        Version        Repository                Size

===========================================================================================

Installing:

 percona-xtrabackup-24           x86_64      2.4.7-2.el7    percona-release-x86_64   7.4 M

Installing for dependencies:

 libev                           x86_64      4.15-6.el7     extras                    44 k

 perl-DBD-MySQL                  x86_64      4.023-5.el7    base                     140 k

 perl-Digest                     noarch      1.17-245.el7   base                      23 k

 perl-Digest-MD5                 x86_64      2.52-3.el7     base                      30 k

 

Transaction Summary

===========================================================================================

Install  1 Package ( 4 Dependent packages)

 

Total download size: 7.6 M

Installed size: 31 M

Is this ok [y/d/N]: y

Downloading packages:

(1/5): libev-4.15-6.el7.x86_64.rpm                                   |  44 kB  00:00:00     

(2/5): perl-Digest-1.17-245.el7.noarch.rpm                           |  23 kB  00:00:00     

(3/5): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                         | 140 kB  00:00:00     

(4/5): perl-Digest-MD5-2.52-3.el7.x86_64.rpm                         |  30 kB  00:00:00     

warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm:

 Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY=============    -  ] 1.1 MB/s | 6.0 MB  00:00:01 ETA 

Public key for percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm is not installed

(5/5): percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm                  | 7.4 MB  00:00:04     

-------------------------------------------------------   

Total                                                       1.9 MB/s | 7.6 MB  00:00:04     

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona

Importing GPG key 0xCD2EFD2A:

 Userid     : "Percona MySQL Development Team <[email protected]>"

 Fingerprint: 430b df5c 56e7 c94e 848e e60c 1c4c bdcd cd2e fd2a

 Package    : percona-release-0.1-4.noarch (@/percona-release-0.1-4.noarch)

 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona

Is this ok [y/N]: y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libev-4.15-6.el7.x86_64                                                         1/5 

  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                               2/5 

  Installing : perl-Digest-1.17-245.el7.noarch                                                 3/5 

  Installing : perl-Digest-MD5-2.52-3.el7.x86_64                                               4/5 

  Installing : percona-xtrabackup-24-2.4.7-2.el7.x86_64                                        5/5 

  Verifying  : percona-xtrabackup-24-2.4.7-2.el7.x86_64                                        1/5 

  Verifying  : perl-Digest-1.17-245.el7.noarch                                                 2/5 

  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                               3/5 

  Verifying  : perl-Digest-MD5-2.52-3.el7.x86_64                                               4/5 

  Verifying  : libev-4.15-6.el7.x86_64                                                         5/5 

 

Installed:

  percona-xtrabackup-24.x86_64 0:2.4.7-2.el7                                                                                                                                                                                                                    

 

Dependency Installed:

  libev.x86_64 0:4.15-6.el7                               

  perl-DBD-MySQL.x86_64 0:4.023-5.el7                               

  perl-Digest.noarch 0:1.17-245.el7                               

  perl-Digest-MD5.x86_64 0:2.52-3.el7                              

 

Complete!

    

                           

 

Installing Percona XtraBackup from Percona apt repository

 

 

上面小编测量试验的条件为Ubuntu 16.04.1 LTS ,安装Percona XtraBackup 2.4为例:

 

 

1:从Percona官方网址获取repository packages:

 

 

[email protected]:~$  wget -sc)_all.deb

--2017-02-28 11:57:52-- 

Resolving repo.percona.com (repo.percona.com)... 74.121.199.234

Connecting to repo.percona.com (repo.percona.com)|74.121.199.234|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 6394 (6.2K) [application/octet-stream]

Saving to: ‘percona-release_0.1-4.xenial_all.deb’

 

percona-release_0.1-4.xenial_all.deb        100%[==================>]   6.24K  --.-KB/s    in 0s     

 

2017-02-28 11:57:53 (157 MB/s) - ‘percona-release_0.1-4.xenial_all.deb’ saved [6394/6394]

 

 

2: 用dpkg安装下载的package包文件

 

 

[email protected]:~$ sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb

Selecting previously unselected package percona-release.

(Reading database ... 76835 files and directories currently installed.)

Preparing to unpack percona-release_0.1-4.xenial_all.deb ...

Unpacking percona-release (0.1-4.xenial) ...

Setting up percona-release (0.1-4.xenial) ...

[email protected]:~$

 

 

3: update the local cache

 

 

[email protected]:~$ sudo apt-get update

Hit:1 xenial InRelease

Get:2 xenial-updates InRelease [102 kB]

Get:3 xenial-backports InRelease [102 kB]

Hit:4 xenial InRelease             

Get:5 xenial-security InRelease [102 kB]    

Get:6 xenial InRelease [15.9 kB]                  

Get:7 xenial/main Sources [5,387 B]               

Get:8 xenial/main amd64 Packages [19.1 kB] 

Fetched 347 kB in 1s (212 kB/s)    

Reading package lists... Done

N: Ignoring file '50unattended-upgrades.ucf-dist' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension

[email protected]:~$

 

 

4:安装Percona XtraBackup包percona-xtrabackup-24

 

 

 

[email protected]:~$ sudo apt-get install percona-xtrabackup-24

Reading package lists... Done

Building dependency tree       

Reading state information... Done

The following additional packages will be installed:

  libdbd-mysql-perl libdbi-perl libev4 libmysqlclient20

Suggested packages:

  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl

The following NEW packages will be installed:

  libdbd-mysql-perl libdbi-perl libev4 libmysqlclient20 percona-xtrabackup-24

0 upgraded, 5 newly installed, 0 to remove and 72 not upgraded.

Need to get 6,063 kB/7,699 kB of archives.

After this operation, 39.0 MB of additional disk space will be used.

Do you want to continue? [Y/n] y

Get:1 http://azure.archive.ubuntu.com/ubuntu xenial/universe amd64 libev4 amd64 1:4.22-1 [26.3 kB]

Get:2 http://repo.percona.com/apt xenial/main amd64 percona-xtrabackup-24 amd64 2.4.6-1.xenial [6,037 kB]

Fetched 6,063 kB in 3s (1,909 kB/s)                  

N: Ignoring file '50unattended-upgrades.ucf-dist' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension

Selecting previously unselected package libdbi-perl.

(Reading database ... 76841 files and directories currently installed.)

Preparing to unpack .../libdbi-perl_1.634-1build1_amd64.deb ...

Unpacking libdbi-perl (1.634-1build1) ...

Selecting previously unselected package libmysqlclient20:amd64.

Preparing to unpack .../libmysqlclient20_5.7.17-0ubuntu0.16.04.1_amd64.deb ...

Unpacking libmysqlclient20:amd64 (5.7.17-0ubuntu0.16.04.1) ...

Selecting previously unselected package libdbd-mysql-perl.

Preparing to unpack .../libdbd-mysql-perl_4.033-1ubuntu0.1_amd64.deb ...

Unpacking libdbd-mysql-perl (4.033-1ubuntu0.1) ...

Selecting previously unselected package libev4.

Preparing to unpack .../libev4_1:4.22-1_amd64.deb ...

Unpacking libev4 (1:4.22-1) ...

Selecting previously unselected package percona-xtrabackup-24.

Preparing to unpack .../percona-xtrabackup-24_2.4.6-1.xenial_amd64.deb ...

Unpacking percona-xtrabackup-24 (2.4.6-1.xenial) ...

Processing triggers for man-db (2.7.5-1) ...

Processing triggers for libc-bin (2.23-0ubuntu5) ...

Setting up libdbi-perl (1.634-1build1) ...

Setting up libmysqlclient20:amd64 (5.7.17-0ubuntu0.16.04.1) ...

Setting up libdbd-mysql-perl (4.033-1ubuntu0.1) ...

Setting up libev4 (1:4.22-1) ...

Setting up percona-xtrabackup-24 (2.4.6-1.xenial) ...

Processing triggers for libc-bin (2.23-0ubuntu5) ...

N: Ignoring file '50unattended-upgrades.ucf-dist' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension

 

[email protected]:~$  innobackupex -v

innobackupex version 2.4.6 Linux (x86_64) (revision id: 54967d1)

 

 

2:Installing Percona XtraBackup from Downloaded rpm or apt Packages

 

 

1:使用yum localinstall package 从本机目录安装软件包

 

 

[[email protected] ~]# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/

 

> binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

 

 

 

[[email protected] ~]#yum localinstall percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

 

 

2:原始的rpm安装方式

 

 

 

 这里测量检验意况,下载的是 Percona-XtraBackup-2.2.12-r8726828-el5-x86_64-bundle.tar安装包。在安装从前最佳安装一些任何额外组件,比如perl-DBD-MySQL等。否则你会碰到一些忙乱的难点。例如

 

perl(DBD::mysql) is needed by percona-xtrabackup-2.2.12-1.el5.x86_64

 

[[email protected] tmp]# rpm -ivh percona-xtrabackup-2.2.12-1.el5.x86_64.rpm

warning: percona-xtrabackup-2.2.12-1.el5.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a

error: Failed dependencies:

        perl(DBD::mysql) is needed by percona-xtrabackup-2.2.12-1.el5.x86_64

 

 

[[email protected] ~]# yum install cmake gcc gcc-c   libaio libaio-devel automake autoconf bzr 

 

                    bison libtool ncurses5-devel

 

 

 

[[email protected] ~]# yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

 

 

 

[[email protected] tmp]# tar -xf Percona-XtraBackup-2.2.12-r8726828-el5-x86_64-bundle.tar

 

[[email protected] tmp]# rpm -ivh percona-xtrabackup-2.2.12-1.el5.x86_64.rpm 

 

warning: percona-xtrabackup-2.2.12-1.el5.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID cd2efd2a

 

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

 

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

 

[[email protected] tmp]# 

 

 

 

 

 

3:Compiling and Installing from Source Code

 

Percona Xtrabackup的源码位于github上,UHighlanderL链接为 你可以下载,也足以采纳git命令下载源码。源码安装的实际进程如下所示:

 

1:如果未有设置git,则需先安装git包

 

 

[[email protected] ~]# sudo yum install git

 

 

2:使用git clone获取相关源码

 

# git clone

 

 

# cd percona-xtrabackup/

# git checkout 2.4

 

3:安装相关重视包

 

# yum install cmake gcc gcc-c libaio libaio-devel automake autoconf

bison libtool ncurses-devel libgcrypt-devel libev-devel libcurl-devel

vim-common

 

# cmake -DBUILD_CONFIG=xtrabackup_release -DWITH_MAN_PAGES=OFF && make –j4

 

 

如上所示,在利用cmake编写翻译时,境遇了不当,能够用如下方法解决。

 

# mkdir -p /usr/local/boost

# cd /usr/local/boost

# wget

# tar -xvzf boost_1_59_0.tar.gz

# rm boost_1_59_0.tar.gz

 

后续编写翻译,扩充参数(黄色部分)

 

#cmake -DBUILD_CONFIG=xtrabackup_release

          -DWITH_MAN_PAGES=OFF

          -DWITH_BOOST=/usr/local/boost

          && make -j4

 

# make install

     

# /usr/local/xtrabackup/bin/innobackupex --version

innobackupex version 2.4.7 Linux (x86_64) (revision id: 5b42862)

 

 

XtraBackup卸载

 

 Xtrabackup的卸载相对来讲比较轻便,这里从简的牵线一下。

 

1:apt packages安装方式的卸载

 

[email protected]:~# sudo apt-get remove percona-xtrabackup-24

Reading package lists... Done

Building dependency tree      

Reading state information... Done

The following packages were automatically installed and are no longer required:

  libdbd-mysql-perl libdbi-perl libev4 libmysqlclient20

Use 'sudo apt autoremove' to remove them.

The following packages will be REMOVED:

  percona-xtrabackup-24

0 upgraded, 0 newly installed, 1 to remove and 75 not upgraded.

After this operation, 32.1 MB disk space will be freed.

Do you want to continue? [Y/n] y

(Reading database ... 77053 files and directories currently installed.)

Removing percona-xtrabackup-24 (2.4.6-1.xenial) ...

Processing triggers for man-db (2.7.5-1) ...

N: Ignoring file '50unattended-upgrades.ucf-dist' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension

 

 

2:YUM安装情势的卸载

 

 

[[email protected] ~]# yum list | grep percona

Repository base is listed more than once in the configuration

Repository updates is listed more than once in the configuration

Repository extras is listed more than once in the configuration

Repository centosplus is listed more than once in the configuration

Repository contrib is listed more than once in the configuration

percona-xtrabackup.x86_64                  2.2.12-1.el6                installed

percona-xtrabackup-debuginfo.x86_64        2.2.12-1.el6                installed

[[email protected] ~]#

 

 

[[email protected] ~]# yum remove percona-xtrabackup

Loaded plugins: fastestmirror, product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Setting up Remove Process

Resolving Dependencies

--> Running transaction check

---> Package percona-xtrabackup.x86_64 0:2.2.12-1.el6 will be erased

--> Finished Dependency Resolution

 

Dependencies Resolved

 

===================================================================================

 Package               Arch          Version          Repository             Size

===================================================================================

Removing:

 percona-xtrabackup    x86_64        2.2.12-1.el6       installed             18 M

 

Transaction Summary

====================================================================================

Remove        1 Package(s)

 

Installed size: 18 M

Is this ok [y/N]: y

Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Repository base is listed more than once in the configuration

Repository updates is listed more than once in the configuration

Repository extras is listed more than once in the configuration

Repository centosplus is listed more than once in the configuration

Repository contrib is listed more than once in the configuration

  Erasing    : percona-xtrabackup-2.2.12-1.el6.x86_64                       1/1 

Loading mirror speeds from cached hostfile

  Verifying  : percona-xtrabackup-2.2.12-1.el6.x86_64                       1/1 

 

Removed:

  percona-xtrabackup.x86_64 0:2.2.12-1.el6                                      

 

Complete!

[[email protected] ~]# 

 

[[email protected] ~]# yum remove percona-xtrabackup-debuginfo.x86_64 

Loaded plugins: fastestmirror, product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Setting up Remove Process

Resolving Dependencies

--> Running transaction check

---> Package percona-xtrabackup-debuginfo.x86_64 0:2.2.12-1.el6 will be erased

--> Finished Dependency Resolution

 

Dependencies Resolved

 

================================================================================

 Package                         Arch      Version           Repository    Size

================================================================================

Removing:

 percona-xtrabackup-debuginfo    x86_64    2.2.12-1.el6      installed     96 M

 

Transaction Summary

================================================================================

Remove        1 Package(s)

 

Installed size: 96 M

Is this ok [y/N]: y

Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Repository base is listed more than once in the configuration

Repository updates is listed more than once in the configuration

Repository extras is listed more than once in the configuration

Repository centosplus is listed more than once in the configuration

Repository contrib is listed more than once in the configuration

  Erasing    : percona-xtrabackup-debuginfo-2.2.12-1.el6.x86_64             1/1 

Loading mirror speeds from cached hostfile

  Verifying  : percona-xtrabackup-debuginfo-2.2.12-1.el6.x86_64             1/1 

 

Removed:

  percona-xtrabackup-debuginfo.x86_64 0:2.2.12-1.el6                            

 

Complete!

 

 

操作系统:CentOS Linux release 7.2.1511 (Core)

 

[[email protected] ~]# yum list installed | grep percona

 percona-release.noarch           0.1-4                          @/percona-release-0.1-4.noarch

 percona-xtrabackup-24.x86_64     2.4.7-2.el7                    @percona-release-x86_64

[[email protected] ~]# yum remove percona-xtrabackup

Loaded plugins: fastestmirror, langpacks

No Match for argument: percona-xtrabackup

No Packages marked for removal

[[email protected] ~]# yum remove percona-xtrabackup-24

[[email protected] ~]# yum list installed | grep percona

 percona-release.noarch           0.1-4                          @/percona-release-0.1-4.noarch

[[email protected] ~]# 

 

3:rpm安装情势的卸载

 

 

[[email protected] ~]# rpm -qa | grep percona

percona-xtrabackup-24-2.4.5-1.el7.x86_64

[[email protected] ~]# rpm -ev percona-xtrabackup-24-2.4.5-1.el7.x86_64

 

 

4:Source Code安装形式的卸载

 

 

[[email protected] ~]# ls -lrt /usr/local/xtrabackup/

 

total 8

 

drwxr-xr-x.  2 root root 4096 Jun  2 03:04 bin

 

drwxr-xr-x. 14 root root 4096 Jun  2 03:06 xtrabackup-test

 

[[email protected] ~]# whereis xtrabackup

 

xtrabackup: /usr/local/xtrabackup

 

[[email protected] ~]# rm -rf /usr/local/xtrabackup/

 

[[email protected] ~]# whereis xtrabackup

 

 

 

Percona XtraBackup的设置、卸载、以及介绍篇就写到那,假如急需明白更加多细节,提出参谋官方文书档案,举例Percona-XtraBackup-2.4.6.pdf,后续将打开介绍XtraBackup备份还原篇、原理分析篇。

XtraBackup 安装介绍篇,perconaxtrabackup XtraBackup介绍 XtraBackup是Percona企业的开源项目,用以完成类似Innodb官方的热备份工具InnoDB Hot Backu...

XtraBackup介绍

 

XtraBackup是Percona集团的开源项目,用以实现类似Innodb官方的热备份工具InnoDB Hot Backup的意义,它帮忙在线热备份(备份时不影响多少读写)。到这段时间停止,最新的本子为Percona XtraBackup 2.4.7.

 

XtraBackup有广大作用和亮点:举个例子帮助全备、增量备份、部分备份;辅助压缩备份;备份不影响多少读写、事务等,不过也许有弱点不足:比如不协理脱机备份、不帮助直接备份到磁带设备、不支持Cloud Back,MyISAM的备份也会堵塞。但是那几个小破绽不影响XtraBackup成为一款流行的MySQL备份工具。其他,请细心XtraBackup只帮衬Linux平台,不援救Windows平台。

 

上面是XtraBackup的官方文书档案的牵线资料:

 

Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking

backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits:

 

• Backups that complete quickly and reliably

• Uninterrupted transaction processing during backups

• Savings on disk space and network bandwidth

• Automatic backup verification

• Higher uptime due to faster restore time

 

Percona XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, and MariaDB. It performs

streaming, compressed, and incremental MySQL backups.

 

Percona XtraBackup works with MySQL, MariaDB, and Percona Server. It supports completely non-blocking backups

of InnoDB, XtraDB, and HailDB storage engines. In addition, it can back up the following storage engines by briefly

pausing writes at the end of the backup: MyISAM, Merge, and Archive, including partitioned tables, triggers, and

database options.

 

 

Percona  XtraBackup的特征:

** 

 

Features

Percona  XtraBackup

License

GPL

Pirce

Free

Streaming and encryption formats

Open source

Supported MySQL flavors

MySQL, Percona Server, MariaDB, Percona XtraDB Cluster, MariaDB Supported

Supported operating systems

Linux

Non-blocking InnoDB backups

Yes

Blocking MyISAM backups

Yes

Incremental backups

Yes

Full compressed backups

Yes

Incremental compressed backups

Yes

Fast incremental backups

Yes

Incremental backups with archived logs feature in Percona Server

Yes

Incremental backups with REDO log only

 

Backup locks

Yes

Encrypted backups

Yes

Streaming backups

Yes

Parallel local backups

Yes

Parallel compression

Yes

Parallel encryption

Yes

Parallel apply-log

Yes

Parallel copy-back

 

Partial backups

Yes

Partial backups of individual partitions

Yes

Throttling

Yes

Backup image validation

 

Point-in-time recovery support

Yes

Safe slave backups

Yes

Compact backups

Yes

Buffer pool state backups

Yes

Individual tables export

Yes

Individual partitions export

Yes

Restoring tables to a different server

Yes

Data & index file statistics

Yes

InnoDB secondary indexes defragmentation

Yes

rsync support to minimize lock time

Yes

Improved FTWRL handlin

Yes

Backup history table

 

Backup progress table

 

Backup to tape media managers

 

Cloud backups support

 

External graphical user interfaces to backup/recovery Zmanda Recovery

Zmanda Recovery Manager for MySQL

 

 

XtraBackup下载

 

XtraBackup能够从官方链接 XtraBackup Documentation相关文书档案下载。 下载的时候,注意版本与平台消息。

 

   Percona XtraBackup的源码放在Github 上,地址为

 

   Percona XtraBackup的文档地址:

 

       

 

       

 

       

 

 

XtraBackup安装

 

Percona XtraBackup的安装格局完全来说有上面三种,我们下边轻便的牵线一下。然后都言之有物都练练手。

 

Installing Percona XtraBackup from Repositories (recommended)

Installing Percona XtraBackup from Downloaded rpm or apt Packages

Compiling and Installing from Source Code

 

1:Installing Percona XtraBackup from Repositories

 

Installing Percona XtraBackup on Red Hat Enterprise Linux and CentOS

 

 

 

下边笔者测量试验的条件为CentOS Linux release 7.2.1511 (Core) ,安装Percona XtraBackup 2.4为例:

 

 

步骤1: Install the Percona repository

 

[test@mylnx06 ~]$ sudo yum install https://www.percona.com/downloads/percona-release/redhat/latest/percona-release-0.1-4.noarch.rpm

[sudo] password for test: 

/usr/local/bin/aad-login failed: exit code 1

Loaded plugins: fastestmirror, langpacks

percona-release-0.1-4.noarch.rpm                         | 6.4 kB     00:00     

Examining /var/tmp/yum-root-02R3Gm/percona-release-0.1-4.noarch.rpm: percona-release-0.1-4.noarch

Marking /var/tmp/yum-root-02R3Gm/percona-release-0.1-4.noarch.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package percona-release.noarch 0:0.1-4 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

 

================================================================================

 Package            Arch      Version    Repository                        Size

================================================================================

Installing:

 percona-release    noarch    0.1-4      /percona-release-0.1-4.noarch    5.8 k

 

Transaction Summary

================================================================================

Install  1 Package

 

Total size: 5.8 k

Installed size: 5.8 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

  Installing : percona-release-0.1-4.noarch                                 1/1 

  Verifying  : percona-release-0.1-4.noarch                                 1/1 

 

Installed:

  percona-release.noarch 0:0.1-4                                                

 

Complete!

 

LacrosseHEL/Centos 5不扶助从远程地点向来设置软件包,由此你必要首先下载软件包,然后用rpm手动安装

 

$ wget http://www.percona.com/downloads/percona-release/redhat/0.1-4/

percona-release-0.1-4.noarch.rpm

$ rpm -ivh percona-release-0.1-4.noarch.rpm

 

安装落成后,你就能够在/etc/yum.repos.d 下看到三个percona-release.repo文件。

 

 

 

手续2: 测验Repository,确定保障Percona XtraBackup相关包已经在Repository中。

 

 

[test@mylnx06 ~]$ yum list | grep percona-xtrabackup

percona-xtrabackup-24.x86_64               2.4.7-2.el7                 @percona-release-x86_64

percona-xtrabackup.x86_64                  2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-22.x86_64               2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-22-debuginfo.x86_64     2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-24-debuginfo.x86_64     2.4.7-2.el7                 percona-release-x86_64

percona-xtrabackup-debuginfo.x86_64        2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-test.x86_64             2.3.8-1.el7                 percona-release-x86_64

percona-xtrabackup-test-22.x86_64          2.2.13-1.el7                percona-release-x86_64

percona-xtrabackup-test-24.x86_64          2.4.7-2.el7                 percona-release-x86_64

 

 

 

步骤3:安装Percona XtraBackup包。

 

 

[test@mylnx06 ~]$ yum install percona-xtrabackup-24

 

[root@GETAZDEVLNX005 ~]# yum install percona-xtrabackup-24

Loaded plugins: fastestmirror, langpacks

Loading mirror speeds from cached hostfile

Resolving Dependencies

--> Running transaction check

---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el7 will be installed

--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Processing Dependency: perl(Digest::MD5) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el7.x86_64

--> Running transaction check

---> Package libev.x86_64 0:4.15-6.el7 will be installed

---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed

---> Package perl-Digest-MD5.x86_64 0:2.52-3.el7 will be installed

--> Processing Dependency: perl(Digest::base) >= 1.00 for package: perl-Digest-MD5-2.52-3.el7.x86_64

--> Running transaction check

---> Package perl-Digest.noarch 0:1.17-245.el7 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

 

===========================================================================================

 Package                         Arch        Version        Repository                Size

===========================================================================================

Installing:

 percona-xtrabackup-24           x86_64      2.4.7-2.el7    percona-release-x86_64   7.4 M

Installing for dependencies:

 libev                           x86_64      4.15-6.el7     extras                    44 k

 perl-DBD-MySQL                  x86_64      4.023-5.el7    base                     140 k

 perl-Digest                     noarch      1.17-245.el7   base                      23 k

 perl-Digest-MD5                 x86_64      2.52-3.el7     base                      30 k

 

Transaction Summary

===========================================================================================

Install  1 Package ( 4 Dependent packages)

 

Total download size: 7.6 M

Installed size: 31 M

Is this ok [y/d/N]: y

Downloading packages:

(1/5): libev-4.15-6.el7.x86_64.rpm                                   |  44 kB  00:00:00     

(2/5): perl-Digest-1.17-245.el7.noarch.rpm                           |  23 kB  00:00:00     

(3/5): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                         | 140 kB  00:00:00     

(4/5): perl-Digest-MD5-2.52-3.el7.x86_64.rpm                         |  30 kB  00:00:00     

warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm:

 Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY=============    -  ] 1.1 MB/s | 6.0 MB  00:00:01 ETA 

Public key for percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm is not installed

(5/5): percona-xtrabackup-24-2.4.7-2.el7.x86_64.rpm                  | 7.4 MB  00:00:04     

-------------------------------------------------------   

Total                                                       1.9 MB/s | 7.6 MB  00:00:04     

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona

Importing GPG key 0xCD2EFD2A:

 Userid     : "Percona MySQL Development Team <mysql-dev@percona.com>"

 Fingerprint: 430b df5c 56e7 c94e 848e e60c 1c4c bdcd cd2e fd2a

 Package    : percona-release-0.1-4.noarch (@/percona-release-0.1-4.noarch)

 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona

Is this ok [y/N]: y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libev-4.15-6.el7.x86_64                                                         1/5 

  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                               2/5 

  Installing : perl-Digest-1.17-245.el7.noarch                                                 3/5 

  Installing : perl-Digest-MD5-2.52-3.el7.x86_64                                               4/5 

  Installing : percona-xtrabackup-24-2.4.7-2.el7.x86_64                                        5/5 

  Verifying  : percona-xtrabackup-24-2.4.7-2.el7.x86_64                                        1/5 

  Verifying  : perl-Digest-1.17-245.el7.noarch                                                 2/5 

  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                               3/5 

  Verifying  : perl-Digest-MD5-2.52-3.el7.x86_64                                               4/5 

  Verifying  : libev-4.15-6.el7.x86_64                                                         5/5 

 

Installed:

  percona-xtrabackup-24.x86_64 0:2.4.7-2.el7                                                                                                                                                                                                                    

 

Dependency Installed:

  libev.x86_64 0:4.15-6.el7                               

  perl-DBD-MySQL.x86_64 0:4.023-5.el7                               

  perl-Digest.noarch 0:1.17-245.el7                               

  perl-Digest-MD5.x86_64 0:2.52-3.el7                              

 

Complete!

    

                           

 

Installing Percona XtraBackup from Percona apt repository

 

 

上面小编测验的条件为Ubuntu 16.04.1 LTS ,安装Percona XtraBackup 2.4为例:

 

 

1:从Percona官方网址获取repository packages:

 

 

  wget -sc)_all.deb

--2017-02-28 11:57:52-- 

Resolving repo.percona.com (repo.percona.com)... 74.121.199.234

Connecting to repo.percona.com (repo.percona.com)|74.121.199.234|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 6394 (6.2K) [application/octet-stream]

Saving to: ‘percona-release_0.1-4.xenial_all.deb’

 

percona-release_0.1-4.xenial_all.deb        100%[==================>]   6.24K  --.-KB/s    in 0s     

 

2017-02-28 11:57:53 (157 MB/s) - ‘percona-release_0.1-4.xenial_all.deb’ saved [6394/6394]

 

 

2: 用dpkg安装下载的package包文件

 

 

mylnx02@mylnx02:~$ sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb

Selecting previously unselected package percona-release.

(Reading database ... 76835 files and directories currently installed.)

Preparing to unpack percona-release_0.1-4.xenial_all.deb ...

Unpacking percona-release (0.1-4.xenial) ...

Setting up percona-release (0.1-4.xenial) ...

 

 

3: update the local cache

 

 

mylnx02@mylnx02:~$ sudo apt-get update

Hit:1 xenial InRelease

Get:2 xenial-updates InRelease [102 kB]

Get:3 xenial-backports InRelease [102 kB]

Hit:4 xenial InRelease             

Get:5 xenial-security InRelease [102 kB]    

Get:6 xenial InRelease [15.9 kB]                  

Get:7 xenial/main Sources [5,387 B]               

Get:8 xenial/main amd64 Packages [19.1 kB] 

Fetched 347 kB in 1s (212 kB/s)    

Reading package lists... Done

N: Ignoring file '50unattended-upgrades.ucf-dist' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension

mylnx02@azrlnx02:~$

 

 

4:安装Percona XtraBackup包percona-xtrabackup-24

 

 

 

本文由金沙澳门官网发布于数据库信息,转载请注明出处:安装介绍篇

关键词: 金沙澳门官网

上一篇:18字符集配置
下一篇:没有了