Oracle Enterprise Manager for MySQL Database
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.
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.
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)
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.
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.
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.