Announcement

Announcement Module
Collapse
No announcement yet.

toolkit and xtrabackup packages require 5.1?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • toolkit and xtrabackup packages require 5.1?

    I'm building a new set of servers with XtraDB 5.5, and using the Yum repository to get the packages. But when I go to install the percona-toolkit package or the xtrabackup package, it downloads and tries to install the shared 5.1 package, which fails on installation.

    I tried hand-linking libmysqlclient.so.18.0.0 -> libmysqlclient.so.16, but yum looks right past it. Other than doing an rpm-based install (which I don't want to do), how do I install the toolkit?

  • #2
    Hi,

    You can visit http://www.percona.com/downloads/percona-toolkit/LATEST/ for downloading latest version of Percona Toolkit. If you don't want to use yum/rpm based installation than you can download binary files (tar.gz) i.e

    shell> wget percona.com/get/percona-toolkit.tar.gz

    and install it. If you want to install individual tools rather than whole toolkit, you can download and run it like

    shell> wget percona.com/get/pt-summary
    --2012-09-11 10:22:40-- http://percona.com/get/pt-summary
    Resolving percona.com (percona.com)... 74.121.199.234
    ......
    Saving to: `pt-summary'

    100%[================================================== ===== ============================================== >] 85,727 49.2K/s in 1.7s

    2012-09-11 10:22:43 (49.2 KB/s) - `pt-summary' saved [85727/85727]

    shell> ll pt-summary
    -rw-rw-r-- 1 root root 85727 Aug 4 00:19 pt-summary
    shell> chmod +x pt-summary
    shell> ll pt-summary
    -rwxrwxr-x 1 root root 85727 Aug 4 00:19 pt-summary*
    shell> ./pt-summary
    # Percona Toolkit System Summary Report ######################
    Date | 2012-09-11 04:53:08 UTC (local TZ: IST +0530)
    .....

    Comment


    • #3
      I specifically do want to use the packages, as I much prefer packages for version management. I'm just trying to understand why the toolkit and xtrabackup have a dependency for MySQL 5.1 instead of 5.5, or why there isn't a version for each.

      Comment


      • #4
        Here's how I got it to work while still mostly using yum:

        # Here are all the currently installed percona packages.

        [root@db-2 ~]# rpm -qa | grep -i percona
        Percona-Server-server-55-5.5.27-rel28.1.296.rhel6.x86_64
        percona-release-0.0-1.x86_64
        Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64
        Percona-Server-client-55-5.5.27-rel28.1.296.rhel6.x86_64

        # Try to directly install the toolkit from yum, it errors out with a package overlap.

        [root@db-2 ~]# yum install percona-toolkit
        Loaded plugins: fastestmirror, presto, security
        Loading mirror speeds from cached hostfile
        * base: mirror.us.leaseweb.net
        * epel: fedora-epel.mirror.lstn.net
        * extras: centos.vipernetworksystems.com
        * updates: bay.uchicago.edu
        Setting up Install Process
        Resolving Dependencies
        --> Running transaction check
        ---> Package percona-toolkit.noarch 0:2.1.3-2 will be installed
        --> Processing Dependency: perl(Term::ReadKey) >= 2.10 for package: percona-toolkit-2.1.3-2.noarch
        --> Processing Dependency: perl(DBI) >= 1.13 for package: percona-toolkit-2.1.3-2.noarch
        --> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.1.3-2.noarch
        --> Running transaction check
        ---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
        --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
        --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
        ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
        ---> Package perl-TermReadKey.x86_64 0:2.30-13.el6 will be installed
        --> Running transaction check
        ---> Package Percona-Server-shared-51.x86_64 0:5.1.65-rel14.0.475.rhel6 will be installed
        --> Finished Dependency Resolution

        Dependencies Resolved

        ================================================== ========== ========================================
        Package Arch Version Repository Size
        ================================================== ========== ========================================
        Installing:
        percona-toolkit noarch 2.1.3-2 percona 1.5 M
        Installing for dependencies:
        Percona-Server-shared-51 x86_64 5.1.65-rel14.0.475.rhel6 percona 2.8 M
        perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
        perl-DBI x86_64 1.609-4.el6 base 705 k
        perl-TermReadKey x86_64 2.30-13.el6 base 31 k

        Transaction Summary
        ================================================== ========== ========================================
        Install 5 Package(s)

        Total download size: 5.1 M
        Installed size: 15 M
        Is this ok [y/N]: y
        Downloading Packages:
        Setting up and reading Presto delta metadata
        Processing delta metadata
        Package(s) data still to download: 5.1 M
        (1/5): Percona-Server-shared-51-5.1.65-rel14.0.475.rhel6.x86_64.rpm | 2.8 MB 00:11
        (2/5): percona-toolkit-2.1.3-2.noarch.rpm | 1.5 MB 00:04
        (3/5): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
        (4/5): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:03
        (5/5): perl-TermReadKey-2.30-13.el6.x86_64.rpm | 31 kB 00:00
        ------------------------------------------------------------ ----------------------------------------
        Total 172 kB/s | 5.1 MB 00:30
        Running rpm_check_debug
        Running Transaction Test


        Transaction Check Error:
        file /usr/lib64/libmysqlclient.so from install of Percona-Server-shared-51-5.1.65-rel14.0.475.rhel6.x86_64 conflicts with file from package Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64
        file /usr/lib64/libmysqlclient_r.so from install of Percona-Server-shared-51-5.1.65-rel14.0.475.rhel6.x86_64 conflicts with file from package Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64

        Error Summary
        -------------

        # Looking at the yum output, it is spinning the dependency from perl-DBD-MySQL needing libmysqlclient.so.16, so I create a softlink to libmysqlclient.so.18.0.0.

        [root@db-2 ~]# cd /usr/lib64/

        [root@db-2 ~]# ls -l libmysqlclient*
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so -> libmysqlclient.so
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so.18 -> libmysqlclient.so
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
        lrwxrwxrwx 1 root root 20 Sep 12 22:30 libmysqlclient.so -> libmysqlclient.so.18
        lrwxrwxrwx 1 root root 24 Sep 12 22:30 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
        -rwxr-xr-x 1 root root 3531072 Sep 3 16:46 libmysqlclient.so.18.0.0

        [root@db-2 lib64]# ln -s libmysqlclient.so.18.0.0 libmysqlclient.so.16

        [root@db-2 lib64]# ls -l libmysql*
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so -> libmysqlclient.so
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so.18 -> libmysqlclient.so
        lrwxrwxrwx 1 root root 17 Sep 12 22:30 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
        lrwxrwxrwx 1 root root 20 Sep 12 22:30 libmysqlclient.so -> libmysqlclient.so.18
        lrwxrwxrwx 1 root root 24 Sep 13 10:45 libmysqlclient.so.16 -> libmysqlclient.so.18.0.0
        lrwxrwxrwx 1 root root 24 Sep 12 22:30 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
        -rwxr-xr-x 1 root root 3531072 Sep 3 16:46 libmysqlclient.so.18.0.0

        # Then install the other dependencies that don't cause yum to install the package that fails.

        [root@db-2 lib64]# yum install perl-DBI perl-TermReadKey
        Loaded plugins: fastestmirror, presto, security
        Loading mirror speeds from cached hostfile
        * base: mirror.us.leaseweb.net
        * epel: mirror.us.leaseweb.net
        * extras: centos.vipernetworksystems.com
        * updates: bay.uchicago.edu
        Setting up Install Process
        Resolving Dependencies
        --> Running transaction check
        ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
        ---> Package perl-TermReadKey.x86_64 0:2.30-13.el6 will be installed
        --> Finished Dependency Resolution

        Dependencies Resolved

        ================================================== ========== ========================================
        Package Arch Version Repository Size
        ================================================== ========== ========================================
        Installing:
        perl-DBI x86_64 1.609-4.el6 base 705 k
        perl-TermReadKey x86_64 2.30-13.el6 base 31 k

        Transaction Summary
        ================================================== ========== ========================================
        Install 2 Package(s)

        Total size: 736 k
        Installed size: 1.7 M
        Is this ok [y/N]: y
        Downloading Packages:
        Running rpm_check_debug
        Running Transaction Test
        Transaction Test Succeeded
        Running Transaction
        Installing : perl-DBI-1.609-4.el6.x86_64 1/2
        Installing : perl-TermReadKey-2.30-13.el6.x86_64 2/2
        Verifying : perl-TermReadKey-2.30-13.el6.x86_64 1/2
        Verifying : perl-DBI-1.609-4.el6.x86_64 2/2

        Installed:
        perl-DBI.x86_64 0:1.609-4.el6 perl-TermReadKey.x86_64 0:2.30-13.el6

        Complete!

        # Since yum caches the rpm's and rpm can ignore the dependencies, find the cached rpm and install.

        [root@db-2 lib64]# find /var -mount -name \*.rpm
        /var/cache/yum/x86_64/6/percona/packages/percona-toolkit-2.1 .3-2.noarch.rpm
        /var/cache/yum/x86_64/6/percona/packages/Percona-Server-shar ed-51-5.1.65-rel14.0.475.rhel6.x86_64.rpm
        /var/cache/yum/x86_64/6/base/packages/perl-DBD-MySQL-4.013-3 .el6.x86_64.rpm

        [root@db-2 lib64]# rpm -ivh --nodeps /var/cache/yum/x86_64/6/base/packages/perl-DBD-MySQL-4.013-3 .el6.x86_64.rpm
        Preparing... ########################################### [100%]
        1erl-DBD-MySQL ########################################### [100%]

        # Now that the specific dependencies are taken care of, install the toolkit.

        [root@db-2 lib64]# yum install percona-toolkit
        Loaded plugins: fastestmirror, presto, security
        Loading mirror speeds from cached hostfile
        * base: mirror.us.leaseweb.net
        * epel: fedora-epel.mirror.lstn.net
        * extras: centos.vipernetworksystems.com
        * updates: bay.uchicago.edu
        Setting up Install Process
        Resolving Dependencies
        --> Running transaction check
        ---> Package percona-toolkit.noarch 0:2.1.3-2 will be installed
        --> Finished Dependency Resolution

        Dependencies Resolved

        ================================================== ========== ========================================
        Package Arch Version Repository Size
        ================================================== ========== ========================================
        Installing:
        percona-toolkit noarch 2.1.3-2 percona 1.5 M

        Transaction Summary
        ================================================== ========== ========================================
        Install 1 Package(s)

        Total size: 1.5 M
        Installed size: 5.0 M
        Is this ok [y/N]: y
        Downloading Packages:
        Running rpm_check_debug
        Running Transaction Test
        Transaction Test Succeeded
        Running Transaction
        Warning: RPMDB altered outside of yum.
        ** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
        perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
        perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
        Installing : percona-toolkit-2.1.3-2.noarch 1/1
        Verifying : percona-toolkit-2.1.3-2.noarch 1/1

        Installed:
        percona-toolkit.noarch 0:2.1.3-2

        Complete!

        Comment

        Working...
        X