Installation of MySQL Enterprise Monitor Agent on Linux

If you are new reader, kindly note that this post contains it's first part on post  
"Installation of MySQL Enterprise Server Manager" .

As the second step as mySQL monitor installation we need to install the monitoring agent for each instance. So in order to accomplish that we first need to create a user and grant relevent permission to that user.

Create agent user on mySQL

mysql> CREATE USER 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';

mysql> GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS 

       ON *.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass'; 

mysql> GRANT CREATE, INSERT ON mysql.* TO 'mysqlagnt'@'localhost'
       IDENTIFIED BY 'agentpass';

mysql> GRANT SELECT ON mysql.inventory TO 'replicationuser'@'%'
       IDENTIFIED BY 'replication_password';

NOTE : SET SQL_LOG_BIN=0 to stop replicating the below grant to 

the slave servers.

Now it is time to check the packages required in Linux to install agent.

To check the package is available see the output of

shell> rpm -qa | grep -i lsb
(if gives a result package name then we are good to go for the installation.

Run the installation file using

shell> ./mysqlmonitoragent-version-installer.bin

Language Selection
Please select the installation language
[1] English
[2] Japanese
Please choose an option [1] :

Select the installation directory

----------------------------------------------------------------------------Welcome to the MySQL Enterprise Monitor Agent Setup Wizard.
----------------------------------------------------------------------------Please specify the directory where MySQL Enterprise Monitor Agent will be installed
Installation directory [/opt/mysql/enterprise/agent]:


Specify the mySQL server to be monitored

How will the agent connect to the database it is monitoring?
[1] TCP/IP
[2] Socket
Please choose an option [1] :

Specify the mySQL server details.

---------------------------------------------------------------------------Monitored Database Information
...
MySQL hostname or IP address [127.0.0.1]:
Validate MySQL hostname or IP address [Y/n]:
MySQL Port [3306]:

Specify the user credentials for the mySQQL Monitor

MySQL Username []: service_agent
MySQL Password :
Re-enter :

Enter the details of MySQL Server Manager

MySQL Enterprise Monitor Options
Hostname or IP address []: 172.20.1.205
Tomcat Server Port [18080]:
Tomcat SSL Port [18443]:

Specify the Agent connection

Use SSL? [y/N]:
Agent Username [agent]:
Agent Password :
Re-enter :

Setup is now ready to begin installing MySQL Enterprise Monitor Agent on your computer.
Do you want to continue? [Y/n]: y


----------------------------------------------------------------------------Please wait while Setup installs MySQL Enterprise Monitor Agent on your computer.
Installing
0% ______________ 50% ______________ 100%
#########################################
----------------------------------------------------------------------------Info to start MySQL Agent
The MySQL agent was successfully installed. To start the MySQL Agent please
invoke:
/opt/mysql/enterprise/agent/etc/init.d/mysql-monitor-agent start
Press [Enter] to continue :
----------------------------------------------------------------------------Setup has finished installing MySQL Enterprise Monitor Agent on your computer.

Finally, log on to the URL http://localhost/18080

If you can't see the server added to the Server Manager check the log using

tail /opt/mysql/enterprise/agent/mysql-monitor-agent.log

If you are getting errors, Then....

Check the connection configuration from agent to Server using,

nano /opt/mysql/enterprise/agent/etc/mysql-monitor-agent.ini

And

Check the connection configuration from Agent to Database using,

nano /opt/mysql/enterprise/agent/etc/instances/mysql/agent-instance.ini

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

If the server connected successfully then you will see your log file like,

2012-06-15 17:07:57: (critical) plugin proxy 0.8.3 started
2012-06-15 17:07:57: (critical) plugin agent 2.3.10.2152 started
2012-06-15 17:07:57: (critical) plugin aggregator 0.1.0 started
2012-06-15 17:07:57: (critical) network-io.c:324: successfully reconnected to dashboard at http://sysagent@172.20.1.205:18080/heartbeat
2012-06-15 17:07:57: (critical) agent_mysqld.c:1232: successfully connected to database at 172.20.1.205:3306 as user root (with password: YES)


Congrats........ Now you can use the Enterprise Monitor console to monitor your database.

:) :) :)