3.4.3 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

To install the agent as a Windows service, you must do the installation as a privileged user.

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

You can install the Monitor Agent in unattended mode, for example, to do multiple installations. For more information on this topic, see Section 3.5, “Unattended Installation”.

Note

To install multiple agents on the same machine, use the agentservicename option with the installer to install each agent with a unique service name. For more information, see installer_agentservicename If the installer identifies an existing installation and you do not specify an alternative service name, the installer stops.

The Agent Installer for Microsoft Windows is only built using the 32-bit architecture. Installing a 32-bit Agent on a 64-bit version of Microsoft Windows is expected, although the default path will include "Program Files (x86)" instead of "Program Files". For website usability reasons, an Agent Installer binary may list a "-64-" in the filename, but note that it is a 32-bit build.

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

  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.

  4. Choose either Host only or Host and database. You can set up MySQL instances for monitoring from the MySQL Enterprise Monitor User Interface, and also define a MySQL instance to start monitoring right away.

    Figure 3.6 MySQL Enterprise Monitor: Installing Agent on Windows: Host options

    MySQL Enterprise Monitor: Installing Agent on Windows: Host options

    Note

    The Auto-discovery process, which automatically scans a system for MySQL instances to monitor, does not function on Microsoft Windows. You must configure them manually, either via the command-line or from the MySQL Enterprise Monitor User Interface.

  5. The host name, port and Agent authentication information must be entered. Enter the required information, as defined when installing the MySQL Enterprise Service Manager, and then click Next to continue.

    Note

    This is the user that connects the Agent to the Service Manager. It is defined by the Service Manager, and Agent users can be modified under Settings, Manage Users. Their role is defined as "agent".

    Figure 3.7 MySQL Enterprise Monitor: Installing Agent on Windows: Agent Authentication

    MySQL Enterprise Monitor: Installing Agent on Windows: Agent Authentication

  6. If you chose Host and database, specify the information about the MySQL server that you want to monitor. Enter the IP address or host name of the host you want to monitor, and the port. 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. The optional Monitor Group determines the custom group that this MySQL instance will be listed under, as defined in the Service Manager.

    Note

    A single Agent can monitor multiple MySQL instances, which can be defined later.

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

    MySQL Enterprise Monitor: Monitored Database Information

    Note

    Currently, on Windows, the monitor agent only includes support for connecting to the server to be monitored via TCP/IP, so you cannot monitor a server running with the --skip-networking.

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

    Click Next to define the optional General and Limited users for the monitored MySQL instance.

  7. Optionally, define the less privileged users for your monitored MySQL instance. Checking Auto-Create Less Privileged Users will automatically create the General and Limited users for you, using the username/password information that you provide. Unchecking this option requires you to manually create the users yourself, before proceeding with the Agent installation. For more information, see Section 3.4.1, “Creating a MySQL User Account for the Monitor Agent”.

    Figure 3.9 MySQL Enterprise Monitor: Installing Agent on Windows: Additional Agent Users

    MySQL Enterprise Monitor: Additional Agent Users

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

  9. You have a final opportunity to change the installation parameters. Click Next to start the installation process.

  10. Once the agent is installed, you get a confirmation message. Click Next to finalize the installation.

  11. You can start the MySQL Enterprise Monitor Agent automatically now that the installation is complete. To start the agent now, leave the checkbox selected. To start the agent separately, uncheck the checkbox. Click Finish to exit the installation.

Once the Monitor Agent is installed, you must start it. For information on how to start and stop the Agent, see Section 3.4.6.1, “Starting/Stopping the Agent on Windows”.