安裝MySQL Enterprise Monitor，mysqlenterprise

安裝MySQL Enterprise Monitor，mysqlenterprise

    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內建的
b、安裝EM
c、在每個要監視的MySQL server上按住EM agent

 

3、安裝MySQL Enterprise Monitor

[root@SZDB tools]# ls -hltr
total 999M
-rwxrwxr-x 1 robin mysql 252M Sep 30 02:32 mysqlmonitor-3.0.15.3058-linux-x86_64-update-installer.bin
-rwxrwxr-x 1 robin mysql 252M Sep 30 02:32 mysqlmonitor-3.0.15.3058-linux-x86_64-installer.bin
-rw-r--r-- 1 robin mysql  13K Sep 30 05:09 README_en.txt
-rw-rwxr-- 1 robin mysql  13K Sep 30 05:09 READ_ME_ja.txt
-rw-r--r-- 1 robin mysql 495M Nov 11 08:11 MySQLmem3015.zip
[root@SZDB tools]# chmod u+x mysqlmonitor-3.0.15.3058-linux-x86_64-*.bin
[root@SZDB tools]# ./mysqlmonitor-3.0.15.3058-linux-x86_64-installer.bin
Language Selection

Please select the installation language       #選擇安裝語言
[1] English - English
[2] Japanese - 日本語
Please choose an option [1] : 1
Info: During the installation process you will be asked to enter usernames and
passwords for various pieces of the Enterprise Monitor. Please be sure to make
note of these in a secure location so you can recover them in case they are
forgotten.
Press [Enter] to continue :
----------------------------------------------------------------------------
Welcome to the setup wizard for the MySQL Enterprise Monitor

----------------------------------------------------------------------------
Please specify the directory where the MySQL Enterprise Monitor will be
installed              #選擇安裝路徑 

Installation directory [/opt/mysql/enterprise/monitor]: /dbdata/mysql/enterprise/monitor

----------------------------------------------------------------------------
Tomcat Server Options

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

----------------------------------------------------------------------------
Service Manager User Account

You are installing as root, but it's not good practice for the Service Manager
to run under the root user account.  Please specify the name of a user account
to use for the Service Manager below.  Note that this user account will be
created for you if it doesn't already exist.

User Account [mysqlmem]:

----------------------------------------------------------------------------
Database Installation   #選擇已存在的MySQL資料用於Repository還是建立一個

Please select which database configuration you wish to use

[1] I wish to use the bundled MySQL database
[2] I wish to use an existing MySQL database *
Please choose an option [1] :

* We will validate the version of your existing MySQL database server during the
installation. See documentation for minimum version requirements.

Important: MySQL Enterprise Monitor 2.3 and 3.0 cannot share a Repository. If
you're not using the bundled Repository and will be running both versions in
your environment, you must set up and maintain separate repositories for them.

Visit the following URL for more information:

http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-install-server.html

----------------------------------------------------------------------------
Repository Configuration

Please specify the following parameters for the bundled MySQL server

Repository Username [service_manager]: #Repository使用者名稱及密碼

Password :
Re-enter :
MySQL Database Port [13306]:

Use SSL when connecting to the database [y/N]: y

----------------------------------------------------------------------------
Setup is now ready to install MySQL Enterprise Monitor on your computer.

Do you want to continue? [Y/n]: y

----------------------------------------------------------------------------
Please wait while Setup installs MySQL Enterprise Monitor on your computer.

 Installing       #開始安裝mysql enterprise monitor                        
 0% ______________ 50% ______________ 100%
 #########################################

----------------------------------------------------------------------------
Completed installing files

Setup has completed installing the MySQL Enterprise Monitor files on your
computer

Uninstalling the MySQL Enterprise Monitor files can be done by invoking:
/dbdata/mysql/enterprise/monitor/uninstall

To complete the installation, launch the MySQL Enterprise Monitor UI and
complete the initial setup. Refer to the readme file for additional information
and a list of known issues.

Press [Enter] to continue :
----------------------------------------------------------------------------
Completed installing files

WARNING: To improve security, all communication with the Service Manager uses
SSL. Because only a basic self-signed security certificate is included when the
Service Manager is installed, it is likely that your browser will display a
warning about an untrusted connection. Please either install your own
certificate or add a security exception for the Service Manager URL to your
browser. See the documentation for more information.

http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-install-server.html
Press [Enter] to continue :

----------------------------------------------------------------------------
Setup has finished installing MySQL Enterprise Monitor on your computer.

View Readme File [Y/n]: n

Info: To configure the MySQL Enterprise Monitor please visit the following page:
https://localhost:18443
Press [Enter] to continue :
You have new mail in /var/spool/mail/root
[root@SZDB tools]#

 

4、安裝用戶端
[robin@TESTDB ~]$ rpm -qa | grep -i lsb  #確認已安裝下列redhat-lsb包
redhat-lsb-4.0-2.1.4.el5
[root@TESTDB opt]# /home/robin/mysqlmonitoragent-3.0.15.3058-linux-x86-64bit-installer.bin
Language Selection

Please select the installation language
[1] English - English
[2] Japanese - 日本語
Please choose an option [1] : 1
----------------------------------------------------------------------------
Welcome to the MySQL Enterprise Monitor Agent Setup Wizard.
----------------------------------------------------------------------------
Installation directory

Please specify the directory where MySQL Enterprise Monitor Agent will be
installed

Installation directory [/opt/mysql/enterprise/agent]:  #選擇安裝路徑

How will the agent connect to the database it is monitoring? #選擇連線協定

[1] TCP/IP
[2] Socket
Please choose an option [1] : 
----------------------------------------------------------------------------
Monitoring Options

You can configure the Agent to monitor this host (file systems, CPU, RAM, etc.)
and then use the Monitor UI to furnish connection parameters for all current and
future running MySQL Instances. This can be automated or done manually for each
MySQL Instance discovered by the Agent. (Note: scanning for running MySQL
processes is not available on Windows, but you can manually add new connections
and parameters from the Monitor UI as well.)

Visit the following URL for more information:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-qanal-using-feeding.html

Monitoring options:

[1] Host only: Configure the Agent to monitor this host and then use the Monitor UI to furnish connection parameters for current and future running MySQL Instances.
[2] Host and database: Configure the Agent to monitor this host and furnish connection parameters for a specific MySQL Instance now. This process may be scripted. Once installed, this Agent will also continuously look for new MySQL Instances to monitor as described above.
Please choose an option [2] :   #這裡選擇同時監控主機和資料庫

----------------------------------------------------------------------------
Setup is now ready to begin installing MySQL Enterprise Monitor Agent on your
computer.

Do you want to continue? [Y/n]: y
----------------------------------------------------------------------------
Please wait while Setup installs MySQL Enterprise Monitor Agent on your
computer.

 Installing    #安裝agent
 0% ______________ 50% ______________ 100%
 #########################################

----------------------------------------------------------------------------
MySQL Enterprise Monitor Options

Hostname or IP address []: 172.16.10.198  #Enterprise Monitor DB 的IP
Tomcat SSL Port [18443]:
The following are the username and password that the Agent will use to connect
to the Monitor.  They were defined when you installed the Monitor.  They can be
modified under Settings, Manage Users.  Their role is defined as "agent".

Agent Username [agent]:   #輸入安裝Enterprise Monitor是定義的使用者名稱及密碼
Agent Password :
Re-enter :
----------------------------------------------------------------------------
Monitored Database Information

IMPORTANT: The Admin user account specified below requires special MySQL
privileges.

Visit the following URL for more information:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-agent-rights.html

MySQL hostname or IP address [localhost]:   #被監控資料庫的IP及連接埠設定

Validate MySQL hostname or IP address [Y/n]: y

MySQL Port [3306]:

Admin User []: root

Admin Password :
Re-enter Password :
Monitor Group []: Prod

----------------------------------------------------------------------------
Agent User Account Creation

IMPORTANT: Less privileged accounts can be used to enhance monitoring security,
and can even be created for you if the Admin account has GRANT privileges.

Visit the following URL for more information:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-agent-rights.html

Auto-Create Less Privileged Users [Y/n]: y

General Username []: general       #以下部分建立使用者捕獲資料庫等相關的監控資訊

General Password :
Re-enter Password :
Limited Username []: limited

Limited Password :
Re-enter Password :
----------------------------------------------------------------------------
Configuration Report

MySQL Enterprise Monitor Agent (Version 3.0.15.3058 : 3.0.15.3058)

The settings you specified are listed below.

Note that if you are using a Connector to collect Query Analyzer data,
you will need some of these settings to configure the Connector. See
the following for more information:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-qanal-using-feeding.html

Installation directory: /opt/mysql/enterprise/agent

MySQL Enterprise Monitor UI:
-------------------------
Hostname or IP address: 172.16.10.198
Tomcat Server Port: 18443
Use SSL: yes

Monitored MySQL Database:
-------------------------
Hostname or IP address: localhost
Port: 3306
Press [Enter] to continue :

Press [Enter] to continue :
----------------------------------------------------------------------------
Start MySQL Enterprise Monitor Agent

Info to start the MySQL Enterprise Monitor Agent

The MySQL Enterprise Monitor Agent was successfully installed. To start the
Agent please invoke:
/etc/init.d/mysql-monitor-agent start
Press [Enter] to continue :
----------------------------------------------------------------------------
Setup has finished installing MySQL Enterprise Monitor Agent on your computer.

View Agent Readme File [Y/n]: n

#以下部分啟動agent，至此安裝完畢，可以登陸到GUI介面進行監控
[root@TESTDB opt]# /etc/init.d/mysql-monitor-agent start
Starting MySQL Enterprise Agent service...[  OK  ]