As a prerequisite for installing the MySQL Enterprise Monitor Agent on Linux systems you must have the Linux Standards Base (LSB) initialization functions installed.
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-
(where version
-installer.binversion
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/
directory.
user_name
/mysql/enterprise/agent
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 15.3.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.
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] :
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]:
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 []:
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 15.3.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.
Specify the user credentials for the MySQL server that you want to monitor:
MySQL Username []: service_agent
MySQL Password :
Re-enter :
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 Section 15.10, “The Query Analyzer Page”.
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 : ----------------------------------------------------------------------------
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
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.
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 15.3.3.5.3, “Starting/Stopping the Agent on Unix”.
User Comments
Add your own comment.