Configuring MySQL monitoring

Edit online

The Monitoring Agent for MySQL requires an instance name and the MySQL server user credentials. You can change the configuration settings after you create the first agent instance.

Before you begin

  • Ensure that a user is created in the MySQL database for running the agent. The user does not require any specific privileges on the MySQL database that is being monitored locally.
  • Ensure following tasks are completed if MySQL server is monitored remotely:
    • Configure the MySQL server to listen on all or a specific interface(s).
    • Grant access to the remote user.
    • Enable the MySQL port in your firewall.
  • Ensure that MySQL JDBC driver is installed before installing this agent. The path to this driver is required for agent configuration.
    • MySQL JDBC connector should be compatible with MySQL server which is being monitored.

      For example, if MySQL sever 8.0.18 is monitored, the mysql-connector-java-8.0.18.jar should be installed on agent machine.

    • MySQL JDBC connector mysql-connector-java-8.0.11 is the stable version for non-windows platform.
  • For Solaris Sparc platform local monitoring of MySQL server, ensure the lsof package is installed.
  • Review the hardware and software prerequisites. For the up-to-date system requirement information, see the Software Product Compatibility Reports (SPCR) for the MySQL agent.

About this task

The directions here are for the most current release of this agent. For information about how to check the version of an agent in your environment, see Agent version command. For detailed information about the agent version list and what's new for each version, see Change history.

The managed system name includes the instance name that you specify, for example, instance_name:host_name:pc, where pc is your two character product code. The managed system name can contain up to 32 characters. The instance name that you specify can contain up to 28 characters, excluding the length of your host name. For example, if you specify MySQL2 as your instance name, your managed system name is MySQL2:hostname:SE.
Important: If you specify a long instance name, the managed system name is truncated and the agent code is not completely displayed.