Percona-toolkit DBA Essentials Kit Installation and conflict handling

First, the smooth installation

# Rpm-qa |grep Percona

# netstat-ntlp|grep MySQL

TCP 0 0::: 3306:::* LISTEN 2685/mysqld

# cd/tmp

# ls

Hsperfdata_hadoop ORBIT-GDM Pulse-pqj5sfdwhlew

Hsperfdata_root percona-toolkit-2.2.19-1.noarch.rpm PULSE-YGSUAXGYKMIW

# RPM-IVH percona-toolkit-2.2.19-1.noarch.rpm

Warning:percona-toolkit-2.2.19-1.noarch.rpm:header V4 dsa/sha1 Signature, key ID Cd2efd2a:nokey

error:failed dependencies:

Perl (DBI) >= 1.13 is needed by percona-toolkit-2.2.19-1.noarch

Perl (Dbd::mysql) >= 1.0 is needed by Percona-toolkit-2.2.19-1.noarch

Perl (Time::hires) is needed by Percona-toolkit-2.2.19-1.noarch

Perl (IO::SOCKET::SSL) is needed by Percona-toolkit-2.2.19-1.noarch

Perl (Term::readkey) is needed by Percona-toolkit-2.2.19-1.noarch

# yum Install percona-toolkit-2.2.19-1.noarch.rpm

Loaded Plugins:fastestmirror, Refresh-packagekit, security

Setting up Install Process

Examining Percona-toolkit-2.2.19-1.noarch.rpm:percona-toolkit-2.2.19-1.noarch

Marking percona-toolkit-2.2.19-1.noarch.rpm to be installed

Determining fastest Mirrors

Base | 4.0 KB 00:00

Resolving Dependencies

--Running Transaction check

---> Package percona-toolkit.noarch 0:2.2.19-1 'll be installed

--processing Dependency:perl (DBI) >= 1.13 for Package:percona-toolkit-2.2.19-1.noarch

--processing Dependency:perl (DBD::MYSQL) >= 1.0 for Package:percona-toolkit-2.2.19-1.noarch

--processing Dependency:perl (time::hires) for Package:percona-toolkit-2.2.19-1.noarch

--processing Dependency:perl (IO::SOCKET::SSL) for Package:percona-toolkit-2.2.19-1.noarch

--processing Dependency:perl (Term::readkey) for Package:percona-toolkit-2.2.19-1.noarch

--Running Transaction check

---> Package perl-dbd-mysql.x86_64 0:4.013-3.el6 'll be installed

---> Package perl-dbi.x86_64 0:1.609-4.el6 'll be installed

---> Package perl-io-socket-ssl.noarch 0:1.31-2.el6 'll be installed

--processing Dependency:perl (Net::ssleay) >= 1.21 for Package:perl-io-socket-ssl-1.31-2.el6.noarch

--processing Dependency:perl (NET::LIBIDN) for Package:perl-io-socket-ssl-1.31-2.el6.noarch

---> Package perl-termreadkey.x86_64 0:2.30-13.el6 'll be installed

---> Package perl-time-hires.x86_64 4:1.9721-136.el6 'll be installed

--Running Transaction check

---> Package perl-net-libidn.x86_64 0:0.12-3.el6 'll be installed

---> Package perl-net-ssleay.x86_64 0:1.35-9.el6 'll be installed

--Finished Dependency Resolution

Dependencies resolved

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

Package Arch Version Repository Size

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

Installing:

Percona-toolkit noarch 2.2.19-1/percona-toolkit-2.2.19-1.noarch 5.7 M

Installing for dependencies:

Perl-dbd-mysql x86_64 4.013-3.el6 Base 134 k

PERL-DBI x86_64 1.609-4.el6 Base 705 K

Perl-io-socket-ssl Noarch 1.31-2.el6 Base K

Perl-net-libidn x86_64 0.12-3.el6 base + k

Perl-net-ssleay x86_64 1.35-9.el6 Base 173 k

Perl-termreadkey x86_64 2.30-13.el6 Base K

Perl-time-hires x86_64 4:1.9721-136.el6 Base K

Transaction Summary

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

Install 8 Package (s)

Total size:6.8 M

Total Download size:1.2 M

Installed size:8.6 M

Is this OK [y/n]: Y

Downloading Packages:

(1/7): perl-net-libidn-0.12-3.el6.x86_64.rpm | KB 00:00

(2/7): perl-io-socket-ssl-1.31-2.el6.noarch.rpm | KB 00:00

(3/7): perl-dbd-mysql-4.013-3.el6.x86_64.rpm | 134 KB 00:00

(4/7): perl-dbi-1.609-4.el6.x86_64.rpm | 705 KB 00:00

(5/7): perl-termreadkey-2.30-13.el6.x86_64.rpm | KB 00:00

(6/7): perl-net-ssleay-1.35-9.el6.x86_64.rpm | 173 KB 00:00

(7/7): perl-time-hires-1.9721-136.el6.x86_64.rpm | KB 00:00

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

Total of MB/s | 1.2 MB 00:00

Running Rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Installing:perl-dbi-1.609-4.el6.x86_64 1/8

Installing:perl-dbd-mysql-4.013-3.el6.x86_64 2/8

Installing:4:perl-time-hires-1.9721-136.el6.x86_64 3/8

Installing:perl-net-ssleay-1.35-9.el6.x86_64 4/8

Installing:perl-termreadkey-2.30-13.el6.x86_64 5/8

Installing:perl-net-libidn-0.12-3.el6.x86_64 6/8

Installing:perl-io-socket-ssl-1.31-2.el6.noarch 7/8

Installing:percona-toolkit-2.2.19-1.noarch 8/8

Verifying:perl-net-libidn-0.12-3.el6.x86_64 1/8

Verifying:perl-io-socket-ssl-1.31-2.el6.noarch 2/8

Verifying:perl-dbd-mysql-4.013-3.el6.x86_64 3/8

Verifying:perl-dbi-1.609-4.el6.x86_64 4/8

Verifying:perl-termreadkey-2.30-13.el6.x86_64 5/8

Verifying:perl-net-ssleay-1.35-9.el6.x86_64 6/8

Verifying:4:perl-time-hires-1.9721-136.el6.x86_64 7/8

Verifying:percona-toolkit-2.2.19-1.noarch 8/8

Installed:

Percona-toolkit.noarch 0:2.2.19-1

Dependency installed:

perl-dbd-mysql.x86_64 0:4.013-3.el6 perl-dbi.x86_64 0:1.609-4.el6 perl-io-socket-ssl.noarch 0:1.31-2.el6

perl-net-libidn.x86_64 0:0.12-3.el6 perl-net-ssleay.x86_64 0:1.35-9.el6 perl-termreadkey.x86_64 0:2.30-13.el6

Perl-time-hires.x86_64 4:1.9721-136.el6

complete!

Ii. Conflict Resolution

Error

Transaction Check Error:

File/usr/share/mysql/charsets/index.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package Mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from Package mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/ascii.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package Mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from Package mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/cp1256.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from Package mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/cp1257.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from Package mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/cp850.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package Mysql-server-5.6.25-1.el6.x86_64

File/usr/share/mysql/charsets/cp852.xml from install of mysql-libs-5.1.71-1.el6.x86_64 conflicts with file from package Mysql-server-5.6.25-1.el6.x86_64

Install mysql-shared-compat-5.6.25-1.linux_glibc2.5.x86_64.rpm to resolve

Download the package, upload, install, and reinstall Percona-toolkit

# RPM-IVH mysql-shared-compat-5.6.25-1.linux_glibc2.5.x86_64.rpm

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

1:mysql-shared-compat ########################################### [100%]

# yum Install percona-toolkit-2.2.19-1.noarch.rpm

This article is from the "ROIDBA" blog, make sure to keep this source http://roidba.blog.51cto.com/12318731/1888844

Percona-toolkit DBA Essentials Kit Installation and conflict handling