• ADADADADAD

    CentOS下使用yum方式安装percona xtrabackup步骤[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 12:13:45

    作者:文/会员上传

    简介:

    编辑/etc/yum.repos.d/Percona.repo,加入以下内容:
    #vi /etc/yum.repos.d/Percona.repo
    [percona]
    name = CentOS $releasever - Percona
    baseurl=http://repo.percona.com/

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    编辑/etc/yum.repos.d/Percona.repo,加入以下内容:
    #vi /etc/yum.repos.d/Percona.repo
    [percona]
    name = CentOS $releasever - Percona
    baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
    enabled = 1
    gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    gpgcheck = 0

    进入/etc/pki/rpm-gpg目录,新建文件RPM-GPG-KEY-percona,加入如下内容:

    [root@test rpm-gpg]# vi /etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    -----BEGIN PGP PUBLIC KEY BLOCK-----
    Version: GnuPG v1.4.9 (GNU/Linux)


    mQGiBEsm3aERBACyB1E9ixebIMRGtmD45c6c/wi2IVIa6O3G1f6cyHH4ump6ejOi
    AX63hhEs4MUCGO7KnON1hpjuNN7MQZtGTJC0iX97X2Mk+IwB1KmBYN9sS/OqhA5C
    itj2RAkug4PFHR9dy21v0flj66KjBS3GpuOadpcrZ/k0g7Zi6t7kDWV0hwCgxCa2
    f/ESC2MN3q3j9hfMTBhhDCsD/3+iOxtDAUlPMIH50MdK5yqagdj8V/sxaHJ5u/zw
    YQunRlhB9f9QUFfhfnjRn8wjeYasMARDctCde5nbx3Pc+nRIXoB4D1Z1ZxRzR/lb
    7S4i8KRr9xhommFnDv/egkx+7X1aFp1f2wN2DQ4ecGF4EAAVHwFz8H4eQgsbLsa6
    7DV3BACj1cBwCf8tckWsvFtQfCP4CiBB50Ku49MU2Nfwq7durfIiePF4IIYRDZgg
    kHKSfP3oUZBGJx00BujtTobERraaV7lIRIwETZao76MqGt9K1uIqw4NT/jAbi9ce
    rFaOmAkaujbcB11HYIyjtkAGq9mXxaVqCC3RPWGr+fqAx/akBLQ2UGVyY29uYSBN
    eVNRTCBEZXZlbG9wbWVudCBUZWFtIDxteXNxbC1kZXZAcGVyY29uYS5jb20+iGAE
    ExECACAFAksm3aECGwMGCwkIBwMCBBUCCAMEFgIDAQIeAQIXgAAKCRAcTL3NzS79
    Kpk/AKCQKSEgwX9r8jR+6tAnCVpzyUFOQwCfX+fw3OAoYeFZB3eu2oT8OBTiVYu5
    Ag0ESybdoRAIAKKUV8rbqlB8qwZdWlmrwQqg3o7OpoAJ53/QOIySDmqy5TmNEPLm
    lHkwGqEqfbFYoTbOCEEJi2yFLg9UJCSBM/sfPaqb2jGP7fc0nZBgUBnFuA9USX72
    O0PzVAF7rCnWaIz76iY+AMI6xKeRy91TxYo/yenF1nRSJ+rExwlPcHgI685GNuFG
    chAExMTgbnoPx1ka1Vqbe6iza+FnJq3f4p9luGbZdSParGdlKhGqvVUJ3FLeLTqt
    caOn5cN2ZsdakE07GzdSktVtdYPT5BNMKgOAxhXKy11IPLj2Z5C33iVYS**TelJ
    b2qHvcg9XDMhmYJyE3O4AWFh3no3Jf4ypIcABA0IAJO8ms9ov6bFqFTqA0UW2gWQ
    cKFN4Q6NPV6IW0rV61ONLUc0VFXvYDtwsRbUmUYkB/L/R9fHj4lRUDbGEQrLCoE+
    /HyYvr2rxP94PT6Bkjk/aiCCPAKZRj5CFUKRpShfDIiow9qxtqv7yVd514Qqmjb4
    eEihtcjltGAoS54+6C3lbjrHUQhLwPGqlAh8uZKzfSZq0C06kTxiEqsG6VDDYWy6
    L7qaMwOqWdQtdekKiCk8w/FoovsMYED2qlWEt0i52G+0CjoRFx2zNsN3v4dWiIhk
    ZSL00Mx+g3NA7pQ1Yo5Vhok034mP8L2fBLhhWaK3LG63jYvd0HLkUFhNG+xjkpeI
    SQQYEQIACQUCSybdoQIbDAAKCRAcTL3NzS79KlacAJ0aAkBQapIaHNvmAhtVjLPN
    wke4ZgCePe3sPPF49lBal7QaYPdjqapa1SQ=
    =qcCk
    -----END PGP PUBLIC KEY BLOCK-----
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    "RPM-GPG-KEY-percona" [New] 30L, 1710C written

    :wq保存退出。

    接下来就可以用yum进行安装了
    [root@test rpm-gpg]# yum -y install percona-xtrabackup
    Loaded plugins: fastestmirror
    Setting up Install Process
    Loading mirror speeds from cached hostfile
    * base: centos.ustc.edu.cn
    * epel: del-mirrors.extreme-ix.org
    * extras: centos.ustc.edu.cn
    * updates: centos.ustc.edu.cn
    percona| 2.9 kB 00:00
    percona/primary_db| 234 kB 00:01
    Resolving Dependencies
    --> Running transaction check
    ---> Package percona-xtrabackup.x86_64 0:2.3.10-1.el6 will be installed
    --> Processing Dependency: rsync for package: percona-xtrabackup-2.3.10-1.el6.x86_64
    --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-2.3.10-1.el6.x86_64
    --> Running transaction check
    ---> Package libev.x86_64 0:4.03-3.el6 will be installed
    ---> Package rsync.x86_64 0:3.0.6-12.el6 will be installed
    --> Finished Dependency Resolution


    Dependencies Resolved


    =============================================================================================================================================================
    Package ArchVersion RepositorySize
    =============================================================================================================================================================
    Installing:
    percona-xtrabackup x86_64 2.3.10-1.el6 percona 5.3 M
    Installing for dependencies:
    libevx86_64 4.03-3.el6epel 113 k
    rsyncx86_64 3.0.6-12.el6 base 335 k


    Transaction Summary
    =============================================================================================================================================================
    Install3 Package(s)


    Total download size: 5.8 M
    Installed size: 6.1 M
    Downloading Packages:
    (1/3): libev-4.03-3.el6.x86_64.rpm| 113 kB 00:01
    (2/3): percona-xtrabackup-2.3.10-1.el6.x86_64.rpm | 5.3 MB 00:07
    (3/3): rsync-3.0.6-12.el6.x86_64.rpm | 335 kB 00:00
    -------------------------------------------------------------------------------------------------------------------------------------------------------------
    Total531 kB/s | 5.8 MB 00:11
    warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
    Importing GPG key 0x0608B895:
    Userid : EPEL (6)
    Package: epel-release-6-8.noarch (@extras)
    From: /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
    warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    Importing GPG key 0xCD2EFD2A:
    Userid: "Percona MySQL Development Team "
    From : /etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Installing : libev-4.03-3.el6.x86_641/3
    Installing : rsync-3.0.6-12.el6.x86_64 2/3
    Installing : percona-xtrabackup-2.3.10-1.el6.x86_643/3
    Verifying : rsync-3.0.6-12.el6.x86_64 1/3
    Verifying : libev-4.03-3.el6.x86_642/3
    Verifying : percona-xtrabackup-2.3.10-1.el6.x86_643/3


    Installed:
    percona-xtrabackup.x86_64 0:2.3.10-1.el6


    Dependency Installed:
    libev.x86_64 0:4.03-3.el6rsync.x86_64 0:3.0.6-12.el6


    Complete!


    [root@test rpm-gpg]# yum -y install percona-toolkit
    Loaded plugins: fastestmirror
    Setting up Install Process
    Loading mirror speeds from cached hostfile
    * base: centos.ustc.edu.cn
    * epel: del-mirrors.extreme-ix.org
    * extras: centos.ustc.edu.cn
    * updates: centos.ustc.edu.cn
    Resolving Dependencies
    --> Running transaction check
    ---> Package percona-toolkit.x86_64 0:3.0.9-1.el6 will be installed
    --> Processing Dependency: perl(IO::Socket::SSL) for package: percona-toolkit-3.0.9-1.el6.x86_64
    --> Running transaction check
    ---> Package perl-IO-Socket-SSL.noarch 0:1.31-3.el6_8.2 will be installed
    --> Processing Dependency: perl-Net-SSLeay >= 1.35-10.el6_8.1 for package: perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch
    --> Processing Dependency: perl(Net::LibIDN) for package: perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch
    --> Running transaction check
    ---> Package perl-Net-LibIDN.x86_64 0:0.12-3.el6 will be installed
    ---> Package perl-Net-SSLeay.x86_64 0:1.35-10.el6_8.1 will be installed
    --> Finished Dependency Resolution


    Dependencies Resolved


    =============================================================================================================================================================
    Package ArchVersion RepositorySize
    =============================================================================================================================================================
    Installing:
    percona-toolkit x86_64 3.0.9-1.el6 percona 7.1 M
    Installing for dependencies:
    perl-IO-Socket-SSL noarch 1.31-3.el6_8.2base 70 k
    perl-Net-LibIDN x86_64 0.12-3.el6base 35 k
    perl-Net-SSLeay x86_64 1.35-10.el6_8.1 base 174 k


    Transaction Summary
    =============================================================================================================================================================
    Install4 Package(s)


    Total download size: 7.4 M
    Installed size: 7.9 M
    Downloading Packages:
    (1/4): percona-toolkit-3.0.9-1.el6.x86_64.rpm | 7.1 MB 00:19
    (2/4): perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch.rpm| 70 kB 00:00
    (3/4): perl-Net-LibIDN-0.12-3.el6.x86_64.rpm | 35 kB 00:00
    (4/4): perl-Net-SSLeay-1.35-10.el6_8.1.x86_64.rpm | 174 kB 00:00
    -------------------------------------------------------------------------------------------------------------------------------------------------------------
    Total352 kB/s | 7.4 MB 00:21
    Running rpm_check_debug
    Running Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Installing : perl-Net-LibIDN-0.12-3.el6.x86_64 1/4
    Installing : perl-Net-SSLeay-1.35-10.el6_8.1.x86_642/4
    Installing : perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch 3/4
    Installing : percona-toolkit-3.0.9-1.el6.x86_644/4
    Verifying : percona-toolkit-3.0.9-1.el6.x86_641/4
    Verifying : perl-Net-SSLeay-1.35-10.el6_8.1.x86_642/4
    Verifying : perl-Net-LibIDN-0.12-3.el6.x86_64 3/4
    Verifying : perl-IO-Socket-SSL-1.31-3.el6_8.2.noarch 4/4


    Installed:
    percona-toolkit.x86_64 0:3.0.9-1.el6


    Dependency Installed:
    perl-IO-Socket-SSL.noarch 0:1.31-3.el6_8.2 perl-Net-LibIDN.x86_64 0:0.12-3.el6 perl-Net-SSLeay.x86_64 0:1.35-10.el6_8.1


    Complete!


    [root@test rpm-gpg]# innobackupex --version
    innobackupex version 2.3.10 Linux (x86_64) (revision id: bd0d4403f36)

    [root@test rpm-gpg]# pt-online-schema-change --version
    pt-online-schema-change 3.0.8
    CentOS下使用yum方式安装percona xtrabackup步骤.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: centos安装percona