1.1 Prerequisites

This section describes the prerequisites for a successful Oracle Enterprise Manager for MySQL Database installation.

• Oracle Enterprise Manager Cloud Control 13.5.0.0.0, or higher. Ensure the agent can successfully communicate with your Oracle Management Service and can upload data.

  Note

  The plugin is installed on the OMS, then deployed to the management agents. In an upgrade, the current version is installed and communicating with older versions of the plugin, until the plugins deployed on the agents can be upgraded. The current version of the plugin, on the OMS, is backward compatible with the following agent-deployed versions of the plugin: 13.2.3.0.0, and 13.2.4.0.0

• MySQL 5.7 or higher.

  Important

  Only Oracle Enterprise Manager for MySQL Database 13.2.4.0.0, or higher, supports MySQL 8.0.

  Amazon RDS supports MySQL 5.7 and MySQL 8.0.

• Supported platforms: The plugin can be deployed on OEM Management Agents on the following operating systems:

  • Linux x86-64 (64-bit), glib2.4 or higher

  • Microsoft Windows x86-64 (64-bit)

  Important

  Consult the MySQL Supported Platforms list for more information. Solaris, HP-UX, AIX, FreeBSD, and macOS are not supported.

• The user installing the Management Agent must, at least, belong to the MySQL user group of the monitored database.

• The Management Agent requires a user on the monitored MySQL instance.

  Note

  Currently, this plugin does not support TLS. As such, the user must not be defined with REQUIRE SSL.

  This user requires the following privileges:

  • SELECT

  • REPLICATION CLIENT

  • SHOW DATABASES

  • PROCESS

  • EXECUTE

  The following example shows how to grant these rights to an existing user named monitoring, assuming a local agent with a socket connection:

  GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, PROCESS, EXECUTE ON *.*
     TO  'monitoring'@'localhost' IDENTIFIED BY 'password';

• For optimal performance, ensure that the monitored MySQL database is on a different machine from the OMS and Enterprise Manager Repository.

• Ensure the MyOracle Support credentials are set up using the SYSMAN user.

• Ensure that the Software Library (also known as the local store) is configured. Updates are downloaded to the local store before they are deployed.

• To monitor metrics based on sys schema views, ensure the sys schema is installed on the monitored MySQL server. sys schema version 1.5.1 or higher is required.

  For more information on sys schema, see MySQL sys Schema

  Note

  The P_S instrument wait/lock/metadata/sql/mdl is also required and must be enabled to use the Sys Schema Table Metadata Lock Waits metric. It is disabled by default. To enable this instrument, add the following to the my.cnf file of the monitored server:

  [mysqld]
  performance-schema-instrument='wait/lock/metadata/sql/mdl=ON'

  For more information, see The metadata_locks Table