Chapter 1 Installing Oracle Enterprise Manager for MySQL Database

Table of Contents

1.1 Prerequisites
1.2 Obtaining and Installing the Plugin
1.3 Configuring a MySQL Target
1.4 Modifying Target Credentials and Properties
1.5 Oracle MySQL Discovery
1.6 Deleting a Target
1.7 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:

  • Query Analyzer

  • 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 commercially licensed and is available in MySQL Enterprise Edition and select Commercial Editions. Learn more at http://www.mysql.com/products/.

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

To install and deploy the plug-in, 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 plug-in 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 12.1.0.4 (or higher).

    • 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, “Configuring a MySQL Target”.