MySQL Enterprise Monitor是专门为MySQL数据库而设计的一款企业级监控，能非常好地与MySQL各方面特性相结合，包括：MySQL的关键性能指标、主机、磁盘、备份、新特性相关以及各种场景下的架构配置，并支持从单节点到海量节点部署的环境。它不仅能够全面地监控MySQL的运行状态，还能及时发现潜在的问题并给出优化建议。本文描述了MySQL Enterprise Monitor的安装过程。
1、安装需求
General Platform Recommendations
The following are recommended:
? Ensure that your Service Manager and Agent hosts are synchronized to the same time server. It is important that all times are properly synchronized.
? Ensure that your Service Manager and Agent hosts use different SSH host keys before installing.
MySQL Requirements
This section describes the MYSQL Server requirements for MySQL Enterprise Monitor installation.
? The Enterprise Server Manager repository requires MySQL Server 5.6.14 or higher.
? The Monitoring Agent can monitor any version of MySQL Server from version 5.0 onwards.
Ensure the following:
? The MySQL Server version is 5.6.14 or higher.
? The InnoDB storage engine is available.
? SSL is enabled.
You must ensure the following in the MySQL Server configuration:
? Query Cache must not be enabled.
? Set innodb_file_per_table=1.
? Set innodb_file_format=Barracuda.
? On Linux/Unix hosts, ensure innodb_flush_method=O_Direct, except on Solaris if ZFS is used.
If using ZFS, comment out this parameter.
? It is recommended to set innodb_log_file_size=2048M.
2、MySQL Enterprise Monitor架构图及安装步骤
a、建立一个作为Repository独立的MySQL数据库，也可以用EM自带的
3、安装MySQL Enterprise Monitor
[root@SZDB tools]# ls -hltr
Please select the installation language #选择安装语言
----------------------------------------------------------------------------
Installation directory [/opt/mysql/enterprise/monitor]: /dbdata/mysql/enterprise/monitor
----------------------------------------------------------------------------
Please specify the following parameters for the bundled Tomcat Server
Tomcat Server Port [18080]: #Author: Leshami
Tomcat SSL Port [18443]: #Blog : http://blod.csdn.net/leshami
----------------------------------------------------------------------------
You are installing as root, but it's not good practice for the Service Manager
User Account [mysqlmem]:
----------------------------------------------------------------------------
Please select which database configuration you wish to use
[1] I wish to use the bundled MySQL database
* We will validate the version of your existing MySQL database server during the
Important: MySQL Enterprise Monitor 2.3 and 3.0 cannot share a Repository. If
Visit the following URL for more information:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-install-server.html
----------------------------------------------------------------------------
Please specify the following parameters for the bundled MySQL server
Repository Username [service_manager]: #Repository用户名及密码
Password :
Use SSL when connecting to the database [y/N]: y
----------------------------------------------------------------------------
Do you want to continue? [Y/n]: y
----------------------------------------------------------------------------
Installing #开始安装mysql enterprise monitor
----------------------------------------------------------------------------
Setup has completed installing the MySQL Enterprise Monitor files on your
Uninstalling the MySQL Enterprise Monitor files can be done by invoking:
To complete the installation, launch th