Skip navigation links
2.3.5 Starting/Stopping the MySQL Enterprise Monitor Agent »
Section Navigation      [Toggle]

2.3.4. Installing the Monitor Agent on Unix

As a prerequisite for installing the MySQL Enterprise Monitor Agent on Linux systems you must have the Linux Standards Base (LSB) initialization functions installed.

Note

You can check the existence of the LSB components by looking for an LSB package within your Linux package management environment. For example, on RedHat and other RPM-based distributions: 

shell> rpm -qa | grep -i lsb
redhat-lsb-3.1-19.fc8.x86_64

Under Debian/Ubuntu: 

shell> dpkg -l|grep -i lsb
ii  lsb-base                                   3.2-20ubuntu4                     
    Linux Standard Base 3.2 init script function
ii  lsb-release                                3.2-20ubuntu4
    Linux Standard Base version reporting utilit

Alternatively, you can use the lsb_release command. Existence of this command normally indicates that the current distribution is LSB compliant.

To install the agent navigate to the directory that contains the file, mysqlmonitoragent-version-installer.bin (where version indicates the three-part version number, the OS, and the architecture). Ensure that this file is executable by typing: 

shell> chmod +x mysqlmonitoragent-version-installer.bin

To install to the default directory (/opt/mysql/enterprise/agent) you need to be logged in as root. Installing as an unprivileged user installs to the /home/user_name/mysql/enterprise/agent directory.

Note

If you install the agent as an unprivileged user, it will not automatically start up on rebooting.

What follows describes installation from the command line. You may install the Monitor Agent graphically by running the installer from within a windows manager. In both cases the steps are identical. You may also install the Monitor Agent in unattended mode. This is especially useful if you are doing multiple installations. For more information on this topic see Section 2.4, “Unattended Installation”.

Begin installation from the command line by typing: 

shell> ./mysqlmonitoragent-version-installer.bin --mode text

The various options are shown in what follows. Default values are indicated by square brackets; to select them press Enter. Otherwise enter a value of your choosing.

  1. First, you must select the Language you want to use during the installation process: 

    Language Selection

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

  2. Next, specify the directory where you want the agent installed: 

    ----------------------------------------------------------------------------
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]:

  3. Specify the MySQL server that you want to monitor. First, you must specify whether you want to use a TCP/IP or socket-based connection to communicate with the MySQL Server: 

    How will the agent connect to the database it is monitoring?


[1] TCP/IP
[2] Socket
Please choose an option [1] :

    If you select TCP/IP, then you will be asked to enter the TCP/IP address and port number: 

    ----------------------------------------------------------------------------
Monitored Database Information

IMPORTANT: The agent user account specified below requires special MySQL privileges.

Visit the following URL for more information:
https://enterprise.mysql.com/docs/monitor/2.0/en/mem-install.html#mem-agent-rights

MySQL hostname or IP address [127.0.0.1]:



Validate MySQL hostname or IP address [Y/n]:


MySQL Port [3306]:

    If you select Socket, then you will be asked to provide the path name to the MySQL socket. Typical values are /tmp/mysql.sock, /var/lib/mysql.sock, or /var/run/mysql.sock. 

    ----------------------------------------------------------------------------
Monitored Database Information

IMPORTANT: The agent user account specified below requires special MySQL privileges.

Visit the following URL for more information:
https://enterprise.mysql.com/docs/monitor/2.0/en/mem-install.html#mem-agent-rights

MySQL Socket []:

    Note

    The monitor agent always associates “localhost” with the TCP/IP address 127.0.0.1, not the MySQL socket. This is in contrast to the MySQL Command Line Tool, which connects via the MySQL socket by default on Unix, if the hostname “localhost” is specified.

    If the MySQL server you wish to monitor has been started with the --skip-networking command option then you will not be able to connect to it via TCP/IP, as the server will not listen for TCP/IP connections. In this case the monitor agent will need to be configured to use the MySQL socket. This can be done during installation by selecting “socket” rather than “TCP/IP” and then specifying the MySQL socket name. This can also be configured after installation by editing the agent-instance.ini configuration file, for further information on this refer to Section 2.3.6.2, “MySQL Server (agent-instance.ini) Configuration”.

    If the MySQL server to be monitored has been started using the command option --bind-address then the server will only listen for connections on the IP address specified, that is, the IP address of the MySQL server. If the monitor agent has been started using TCP/IP networking and the default address of 127.0.0.1 it will not be able to connect to the server to be monitored. Also, if “localhost” is specified as the host name during agent configuration, a connection will not be established, as the server will be listening for connections on the address specified with the --bind-address option, not 127.0.0.1.

  4. Specify the user credentials for the MySQL server that you want to monitor: 

    MySQL Username []: service_agent

MySQL Password :

Re-enter :

  5. Select whether you want to enable Query Analyzer. If you disable the Query Analyzer during installation, you will need to manually edit the configuration file to re-enable the Query Analyzer functionality. If you enable Query Analyzer (Proxy), you must specify the port on which the agent will listen for queries. 

    ----------------------------------------------------------------------------
Query Analyzer Configuration

MySQL Proxy enables query monitoring and analysis by listening on a specified port for client connections that are then passed through to a backend MySQL database server. It is not needed for basic monitoring functionality.

Click here for more information.
 [Y/n]:

Enable Proxy (recommended) [Y/n]:


Proxy Port [6446]:

Backend Host: 127.0.0.1   (cannot be changed)

Backend Port: 3306   (cannot be changed)

    For more information on enabling Query Analyzer if you disabled it during installation, see Chapter 9, The Query Analyzer Page.

  6. Enter the details of the MySQL Enterprise Service Manager that you want to use with this agent. The configuration information required is available within the installation report generated when you installed MySQL Enterprise Service Manager 

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

MySQL Enterprise Monitor Options


Hostname or IP address []: 192.168.0.197

Tomcat Server Port [18080]:

Tomcat SSL Port [18443]:

    The agent and MySQL Enterprise Service Manager support using SSL for communication. If you want to enable SSL communication between the agent and the MySQL Enterprise Service Manager, you must reply Y to the following question. 

    Use SSL? [y/N]:

Agent Username [agent]:

Agent Password :

Re-enter :

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

  7. Before installation starts, you will be provided with a summary of the installation settings that you have specified: 

    Here are the settings you specified:

Installation directory: /opt/mysql/enterprise/agent

Monitored MySQL Database:
-------------------------
Hostname or IP address: 127.0.0.1
Port: 3306
MySQL username: mysql_user
MySQL password: password

Query Analyzer Configuration
-------------------------
Proxy Enabled: yes
Proxy Port: 6446

MySQL Enterprise Manager:
------------------------------

Hostname or IP address: 192.168.0.197

Tomcat Server Port: 18080
Tomcat SSL Port: 18443
Use SSL: 0
Agent username: agent

Press [Enter] to continue :


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

Setup is now ready to begin installing MySQL Enterprise Monitor Agent on your computer.

Do you want to continue? [Y/n]: y

  8. The installer will copy the necessary files and create the configuration file required to run the agent: 

    ----------------------------------------------------------------------------
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.

  9. Finally, you can read the supplied README file when prompted. The file is provided within the share/doc/README_en.txt file within the agent installation directory if you would like to read this file separately.

For information on starting the agent, see Section 2.3.5.3, “Starting/Stopping the Agent on Unix”.