This section describes the prerequisites for a successful Oracle Enterprise Manager for MySQL Database installation.
Oracle Enterprise Manager Cloud Control 220.127.116.11.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: 18.104.22.168.0, and 22.214.171.124.0
MySQL 5.7 or higher.Important
Only Oracle Enterprise Manager for MySQL Database 126.96.36.199.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.Note
Currently, this plugin does not support TLS. As such, the user must not be defined with
This user requires the following privileges:
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 SchemaNote
The P_S instrument
wait/lock/metadata/sql/mdlis 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.cnffile of the monitored server:
For more information, see The metadata_locks Table