How to install Percona MySQL tools

Persona has lots of tools to analyses MySQL data and very useful information can be extracted from them.

Installing via Yum:
[root@ip-10-0-1-220 ravi]# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Retrieving http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Preparing...                ########################################### [100%]
   1:percona-release        ########################################### [100%]
[root@ip-10-0-1-220 ravi]# yum install percona-toolkit
Loaded plugins: auto-update-debuginfo, priorities, update-motd, upgrade-helper
1123 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package percona-toolkit.noarch 0:2.2.18-1 will be installed
--> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.2.18-1.noarch
--> Processing Dependency: perl(DBI) >= 1.13 for package: percona-toolkit-2.2.18-1.noarch
--> Running transaction check
---> Package perl-DBD-MySQL55.x86_64 0:4.023-5.23.amzn1 will be installed
---> Package perl-DBI.x86_64 0:1.627-4.8.amzn1 will be installed
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.8.amzn1.x86_64
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.8.amzn1.x86_64
--> Running transaction check
---> Package perl-PlRPC.noarch 0:0.2020-14.7.amzn1 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.7.amzn1.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.7.amzn1.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.7.amzn1.noarch
--> Running transaction check
---> Package perl-Net-Daemon.noarch 0:0.48-5.5.amzn1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================
 Package               Arch        Version                  Repository                   Size
==============================================================================================
Installing:
 percona-toolkit       noarch      2.2.18-1                 percona-release-noarch      1.7 M
Installing for dependencies:
 perl-DBD-MySQL55      x86_64      4.023-5.23.amzn1         amzn-main                   149 k
 perl-DBI              x86_64      1.627-4.8.amzn1          amzn-main                   855 k
 perl-Net-Daemon       noarch      0.48-5.5.amzn1           amzn-main                    58 k
 perl-PlRPC            noarch      0.2020-14.7.amzn1        amzn-main                    39 k

Transaction Summary
==============================================================================================
Install  1 Package (+4 Dependent packages)

Total download size: 2.7 M
Installed size: 4.1 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/latest/percona-release-noarch/packages/percona-toolkit-2.2.18-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Public key for percona-toolkit-2.2.18-1.noarch.rpm is not installed
(1/5): percona-toolkit-2.2.18-1.noarch.rpm                             | 1.7 MB     00:01     
(2/5): perl-DBD-MySQL55-4.023-5.23.amzn1.x86_64.rpm                    | 149 kB     00:00     
(3/5): perl-DBI-1.627-4.8.amzn1.x86_64.rpm                             | 855 kB     00:00     
(4/5): perl-Net-Daemon-0.48-5.5.amzn1.noarch.rpm                       |  58 kB     00:00     
(5/5): perl-PlRPC-0.2020-14.7.amzn1.noarch.rpm                         |  39 kB     00:00     
----------------------------------------------------------------------------------------------
Total                                                         1.3 MB/s | 2.7 MB  00:00:02     
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-3.noarch (@/percona-release-0.1-3.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 : perl-Net-Daemon-0.48-5.5.amzn1.noarch                                      1/5 
  Installing : perl-PlRPC-0.2020-14.7.amzn1.noarch                                        2/5 
  Installing : perl-DBI-1.627-4.8.amzn1.x86_64                                            3/5 
  Installing : perl-DBD-MySQL55-4.023-5.23.amzn1.x86_64                                   4/5 
  Installing : percona-toolkit-2.2.18-1.noarch                                            5/5 
  Verifying  : percona-toolkit-2.2.18-1.noarch                                            1/5 
  Verifying  : perl-DBD-MySQL55-4.023-5.23.amzn1.x86_64                                   2/5 
  Verifying  : perl-PlRPC-0.2020-14.7.amzn1.noarch                                        3/5 
  Verifying  : perl-Net-Daemon-0.48-5.5.amzn1.noarch                                      4/5 
  Verifying  : perl-DBI-1.627-4.8.amzn1.x86_64                                            5/5 

Installed:
  percona-toolkit.noarch 0:2.2.18-1                                                           

Dependency Installed:
  perl-DBD-MySQL55.x86_64 0:4.023-5.23.amzn1       perl-DBI.x86_64 0:1.627-4.8.amzn1          
  perl-Net-Daemon.noarch 0:0.48-5.5.amzn1          perl-PlRPC.noarch 0:0.2020-14.7.amzn1      

Complete!

If you want to install via RPM go to following link and download the latest version  and install via rpm -ivh package name.

Comments

Popular posts from this blog

Script to create daily AMI of AWS server and delete AMI older than n no of days..

How to delete multiple user in linux

How to create users from ansible with public key and password.