Skip navigation links
MySQL Enterprise Monitor 2.1 :: 2 Installation and Upgrades :: 2.3 Monitor Agent Installation :: 2.3.2 Installing the Agent on Microsoft Windows
2.3.3 Installing the Agent on Mac OS X »
Section Navigation      [Toggle]

2.3.2. Installing the Agent on Microsoft Windows

To install the MySQL Enterprise Monitor Agent on Windows, double-click the mysqlmonitoragent-version-windows-installer.exe (where version indicates the three-part version number) installer.

Note

In order to install the agent as a Windows service, you must do the installation as a privileged user.

On Windows Vista, if user account control is on, an operating system dialog box requests confirmation of the installation.

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

  1. First, select the language for the MySQL Enterprise Monitor Agent installation. Click OK to continue installation.

    Figure 2.12. MySQL Enterprise Monitor: Installing Agent on Windows: Language Selection

    MySQL Enterprise Monitor: Installing Agent on Windows: Language Selection

  2. Click Next to start the installation process.

  3. Select the installation directory. The default installation directory is C:\Program Files\MySQL\Enterprise\Agent. Select the installation directory, or type the new directory location. Click Next to continue the installation process.

    Figure 2.13. MySQL Enterprise Monitor: Installing Agent on Windows: Installation Directory

    MySQL Enterprise Monitor: Installing Agent on Windows: Installation Directory

  4. You need to specify the information about the MySQL server that you want to monitor. You must enter the IP address or host name of the host you want to monitor, and the port, user name and password that you will use to connect to the MySQL server. If you want to confirm that the MySQL server is currently reachable using the information, ensure that the Validate MySQL host name or IP address checkbox is selected.

    Note

    Currently, on Windows, the monitor agent only includes support for connecting to the server to be monitored via TCP/IP, so if the server has been started with --skip-networking it cannot be monitored.

    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.

    Figure 2.14. MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information

    MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information

    Click Next to continue the installation.

  5. If you want to use Query Analyzer, then you need to enable the MySQL Enterprise Monitor Agent Proxy. The Proxy is enabled by default. If you disable the Proxy during installation, you will need to enable it later before you are able to use Query Analyzer. For more information on Query Analyzer, see Chapter 9, The Query Analyzer Page.

    When Proxy is enabled, MySQL Enterprise Monitor Agent listens on a network port for client applications, and forwards the connections to the backend MySQL server. You can change the port number that MySQL Enterprise Monitor Agent listens for connections.

    The default port is 6446.

    Figure 2.15. MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer Configuration

    MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer Configuration

  6. The MySQL Enterprise Service Manager that you want to use must be configured during installation. The host name, port and agent authentication information must be entered. If you have already installed MySQL Enterprise Service Manager then you can locate the information in the installation report file created during installation. Enter the required information and then click Next to continue.

    Figure 2.16. MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager Options

    MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager Options

  7. You will be provided with a Configuration Report containing the information that you have entered during the installation. Check the information provided in the report. If you see a problem, use Back to go back to the configuration screen and change the information. If the information is correct, click Next to continue.

  8. You are given a final opportunity to change the installation parameters. Click Next to start the installation process.

  9. Once the agent has been installed, you will get a confirmation message. Click Next to finalize the installation.

  10. You can start the MySQL Enterprise Monitor Agent automatically now the installation has been completed. To allow the agent to be started, leave the checkbox selected. To start the agent separately, uncheck the checkbox. Click Finish to exit the installation.

Once the Monitor Agent is installed, it needs to be started. For information on how to start and stop the Agent, see Section 2.3.5.1, “Starting/Stopping the Agent on Windows”.