How To Install Mtop (MySQL Database Server Monitoring)

To Install Mtop (MySQL Database Server Monitoring) in RHEL/CentOS 6/5, Fedora 17-12

In this article, we will learn how to install Mtop (MySQL Database Server Monitoring) in RHEL/CentOS 6/5, Fedora 17-12. First, enable RPMForge repository under your Linux machine to download and install latest version of MTOP program and Fedora user’ s need not enable any repository under Fedora box.

To Install RPMForge

Select either of the following links based on your Linux architecture, to enable RPMforge repository under your Linux box.

On RHEL/CentOS 6 32-Bit OS

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm
rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.i686.rpm

On RHEL/CentOS 6 64-Bit OS

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

To Install RPMForge on RHEL/CentOS 5

On RHEL/CentOS 5 32-Bit OS

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.i386.rpm

On RHEL/CentOS 5 64-Bit OS

wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
rpm -Uvh rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm

To Install RPMForge on 64bit /CentOS/RHEL 6

[root@linuxhelp ~]# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
--2016-03-26 17:54:42-- http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolving packages.sw.be... 78.46.17.228
Connecting to packages.sw.be|78.46.17.228|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm [following]
--2016-03-26 17:54:42-- http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolving pkgs.repoforge.org... 78.46.17.228
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: 12700 (12K) [application/x-redhat-package-manager]
Saving to: “ rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm” 

100%[================================================================================> ] 12,700 --.-K/s in 0.01s

2016-03-26 17:54:44 (856 KB/s) - “ rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm”  saved [12700/12700]

[root@linuxhelp ~]# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Preparing... ########################################### [100%]
package rpmforge-release-0.5.2-2.el6.rf.x86_64 is installed

To Import RPMForge Repository Key in RHEL/CentOS 6/5

[root@linuxhelp ~]# wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
[root@linuxhelp ~]# rpm --import RPM-GPG-KEY.dag.txt

To Install Mtop in RHEL/CentOS 6/5 and Fedora 17-12

After installing and enabling RPMForge repository, install MTOP using following command.

[root@linuxhelp ~]# yum install mtop
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* extras: centos.excellmedia.net
* rpmforge: ftp.heanet.ie
* updates: centos.excellmedia.net
Resolving Dependencies
.
.
.
.
Running Transaction
Installing : mtop-0.6.6-1.2.el6.rf.noarch 1/1
Verifying : mtop-0.6.6-1.2.el6.rf.noarch 1/1
Installed:
mtop.noarch 0:0.6.6-1.2.el6.rf

Complete!

Now the installation of Mtop is completed.

To start Mtop program

Use the following command to connect to your MySQLServer.

[root@linuxhelp ~]# mysql -u root -p

Next, create separate user called mtop and grant privileges under your MySQL server. To perform this task run the following command in MySQL shell.

mysql>  grant super, reload, process on *.* to mtop 
Query OK, 0 rows affected (0.00 sec)

mysql>  grant super, reload, process on *.* to mtop@localhost 
Query OK, 0 rows affected (0.00 sec)

mysql>  flush privileges 
Query OK, 0 rows affected (0.00 sec)
mysql>  q
Bye

To Run Mtop in RHEL/CentOS 6/5

Use the following command to start the Mtop program.

[root@linuxhelp ~]# mtop

To Monitor Remote MySQL Server using Mtop

Run the following command to monitor the remote MySQL Server.

[root@linuxhelp ~]# mtop &ndash host=remotehost &ndash dbuser=username &ndash password=password