安裝MySQL Enterprise Monitor

    MySQL Enterprise Monitor是專門為MySQL數據庫而設計的1款企業(yè)級監(jiān)控，能非常好地與MySQL各方面特性相結合，包括：MySQL的關鍵性能指標、主機、磁盤、備份、新特性相干和各種場景下的架構配置，并支持從單節(jié)點到海量節(jié)點部署的環(huán)境。它不但能夠全面地監(jiān)控MySQL的運行狀態(tài)，還能及時發(fā)現潛伏的問題并給出優(yōu)化建議。本文描寫了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、建立1個作為Repository獨立的MySQL數據庫，也能夠用EM自帶的
b、安裝EM
c、在每一個要監(jiān)視的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⑶.0.15.3058-linux-x86_64-update-installer.bin
-rwxrwxr-x 1 robin mysql 252M Sep 30 02:32 mysqlmonitor⑶.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⑶.0.15.3058-linux-x86_64-*.bin
[root@SZDB tools]# ./mysqlmonitor⑶.0.15.3058-linux-x86_64-installer.bin
Language Selection

Please select the installation language       #選擇安裝語言
[1] English - English
[2] Japanese - 日本

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈