Chapter 1 Installing Oracle Enterprise Manager for MySQL Database

Table of Contents

1.1 Prerequisites

1.2 Obtaining and Installing the Plugin

1.3 Adding MySQL Targets

1.3.1 Adding Targets Manually

1.3.2 Adding Targets Using Autodiscovery

1.4 Modifying Target Credentials and Properties

1.5 Deleting a Target

1.6 Logging

Oracle Enterprise Manager for MySQL Database extends Oracle Enterprise Manager to enable monitoring of MySQL servers.

Note

Although Oracle Enterprise Manager for MySQL Database is based on MySQL Enterprise Monitor, it does not contain the following MySQL Enterprise Monitor functionality:

• Support for monitoring MySQL Cluster

• All Advisors and graphs. Oracle Enterprise Manager for MySQL Database contains a subset of the MySQL Enterprise Monitor Advisors and graphs.

• Replication topology diagrams.

Important

Oracle Enterprise Manager for MySQL Database is included with both the MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition at no additional cost. To use Oracle Enterprise Manager for MySQL Database with the MySQL Community Edition, you must purchase licensing for either the MySQL Enterprise Edition or MySQL Cluster Carrier Grade Edition.

This chapter describes how to install Oracle Enterprise Manager for MySQL Database.

To install and deploy the plugin, you must do the following:

1. Ensure the prerequisites are installed and correctly configured. For more information, see Section 1.1, “Prerequisites”.

2. Download the plugin and deploy it on the OMS and Management Agent as described in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

   Oracle Enterprise Manager for MySQL Database is available from the following locations:

   • The Self Update section of Oracle Enterprise Manager.

   • Oracle Software Delivery Cloud - available in the MySQL Database Product Pack.

   • My Oracle Support - download from the Patches/Updates tab. (Product: Enterprise Manager for MySQL Database)

3. Configure a MySQL target in OMS. Adding a target triggers the collection of metrics from the Management Agent. A subset of the collected data is displayed in the target homepage. For more information, see Section 1.3, “Adding MySQL Targets”.

To view the user interface, you must use one of the following browser versions:

• Google Chrome 63, or higher.

• Mozilla Firefox 57, or higher.

• Microsoft Edge 41, or higher.