- 1 Introduction
- 2 Installation and Upgrades
- 3 MySQL Enterprise Dashboard
- 4 The What's New Page
- 5 The Settings Page
- 6 The Advisors Page
- 7 The Events Page
- 8 The Graphs Page
- 9 The Query Analyzer Page
- 10 The Replication Page
- A MySQL Enterprise Monitor Frequently Asked Questions
- B Files Associated with The MySQL Enterprise Monitor
- C Error codes
- D MySQL Enterprise Monitor Change History
- E MySQL Enterprise Monitor Reference
- F Data Collection Items
Table of Contents [+/-]
- 2.1. User Roles [+/-]
- 2.2. Service Manager Installation [+/-]
- 2.2.1. Service Manager Installation Common Parameters
- 2.2.2. Service Manager Installation on Windows
- 2.2.3. Service Manager Installation on Mac OS X
- 2.2.4. Service Manager Installation on Unix
- 2.2.5. Starting/Stopping the MySQL Enterprise Monitor Service on Windows
- 2.2.6. Starting/Stopping the MySQL Enterprise Monitor Service on Unix and Mac OS X
- 2.2.7. MySQL Enterprise Service Manager Configuration Settings and Advisor Installation
- 2.3. Monitor Agent Installation [+/-]
- 2.3.1. Creating a MySQL User Account for the Monitor Agent
- 2.3.2. Installing the Agent on Microsoft Windows
- 2.3.3. Installing the Agent on Mac OS X
- 2.3.4. Installing the Monitor Agent on Unix
- 2.3.5. Starting/Stopping the MySQL Enterprise Monitor Agent
- 2.3.6. Advanced Agent Configuration
- 2.3.7. Troubleshooting the Agent
- 2.4. Unattended Installation [+/-]
- 2.5. Post-Installation Considerations
- 2.6. Upgrading, Re-Installing or Changing Your Installation [+/-]
- 2.7. Uninstalling the MySQL Enterprise Monitor [+/-]
Note
MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.
This chapter describes the process of installing the MySQL Enterprise Monitor on all operating systems. A working installation requires the installation of a MySQL Enterprise Service Manager, the MySQL Enterprise Advisors and one or more MySQL Enterprise Monitor Agents. Simply described, the agent inspects the MySQL server it is monitoring, reports to the Service Manager, and the results are interpreted by the advisors and displayed in the MySQL Enterprise Dashboard for viewing in a web browser.
One Monitor Agent is installed for each MySQL server that is being monitored. The Monitor Agent usually runs on the same machine that hosts the monitored MySQL server but it may run on any machine that has access to both the monitored MySQL server and the MySQL Enterprise Dashboard. The agent reports its findings to the Service Manager and these results are interpreted by Advisors and displayed in the dashboard. The end user opens a web browser to view the information presented in the dashboard. The Service Manager and dashboard run on the same machine and both have access to a local MySQL server installed as part of the MySQL Enterprise Monitor. This server is known as the repository and provides storage for the data provided by the agent.
Installation is a three step process:
Install and start the Service Manager on the monitoring system. See Section 2.2, “Service Manager Installation”.
Configure the Service Manager, see Section 2.3, “Monitor Agent Installation”.
Start the MySQL Enterprise Service Manager and MySQL Enterprise Monitor Agent instances, and then use the MySQL Enterprise Dashboard to install the Advisors and complete the configuration and installation. See Section 2.2.7, “MySQL Enterprise Service Manager Configuration Settings and Advisor Installation”.
Depending on your configuration and environment, you will need to download a number of different components and files from MySQL Enterprise website available on the download page. These include:
MySQL Enterprise Service Manager and MySQL Enterprise Dashboard for the platform that you intend to execute the MySQL Enterprise Service Manager on. These are named
mysqlmonitor-, with the appropriate version and platform name. If you are performing an upgrade, download the upgrade installer, named2.1.0.1096-linux-x86_64-installer.binmysqlmonitor-.2.1.0.1096-linux-x86_64-update-installer.binOne or more MySQL Enterprise Monitor Agent, one for each MySQL Server that you want to monitor. You should download an installer package for the right platform for the MySQL server you want to manage. Agent installers are available with the name
mysqlmonitoragent-. Upgrade installers to update an existing MySQL Enterprise Monitor Agent installation are named2.1.0.1093-linux-debian3.1-powerpc-installer.binmysqlmonitoragent-.2.1.0.1093-linux-debian3.1-powerpc-update-installer.bin-
Optional
A product key file for MySQL Enterprise Service Manager. If your MySQL Enterprise Service Manager has internet connectivity, your product key can be downloaded automatically during the initial phase of configuration directly from the MySQL Enterprise website. For more information, see Section 2.2.7, “MySQL Enterprise Service Manager Configuration Settings and Advisor Installation”.
-
Optional
An advisor bundle equal to the level of your MySQL Enterprise subscriptiion (Platinum, Gold, or Silver), which is required for MySQL Enterprise Service Manager. If your MySQL Enterprise Service Manager has internet connectivity, your advisor bundle can be downloaded automatically during the initial phase of configuration directly from the MySQL Enterprise website. For more information, see Section 2.2.7, “MySQL Enterprise Service Manager Configuration Settings and Advisor Installation”.
For information on the installation requirements for different platforms, see Section E.3, “Installation Requirements”.
