1.1 Prerequisites

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

  • Oracle Enterprise Manager Cloud Control 13.2.0.0.0 with patch #25453518, 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.2.0.0, and 13.2.3.0.0

    Important

    This version requires the Oracle Enterprise Manager Extensibility Development Kit (EDK) 13.2.0.0.0 build 170321, or higher.

  • MySQL 5.5 or higher.

    Important

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

  • Supported platforms: The plug-in can be deployed on OEM Management Agents on the following Operating Systems:

    • Solaris (SPARC)

    • Solaris Operating System (x86-64)

    • 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. HP-UX, AIX, FreeBSD and Mac OS X 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. 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