程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> 安裝MySQLEnterpriseMonitor

安裝MySQLEnterpriseMonitor

編輯:MySQL綜合教程

安裝MySQLEnterpriseMonitor


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 the MySQL Enterprise Monitor UI and

Press [Enter] to continue :

WARNING: To improve security, all communication with the Service Manager uses

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

----------------------------------------------------------------------------

View Readme File [Y/n]: n

Info: To configure the MySQL Enterprise Monitor please visit the following page:

4、安裝客戶端

Please select the installation language

Please specify the directory where MySQL Enterprise Monitor Agent will be

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

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

[1] TCP/IP

You can configure the Agent to monitor this host (file systems, CPU, RAM, etc.)

Visit the following URL for more information:

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.

----------------------------------------------------------------------------

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

Installing #安裝agent

----------------------------------------------------------------------------

Hostname or IP address []: 172.16.10.198 #Enterprise Monitor DB 的IP

Agent Username [agent]: #輸入安裝Enterprise Monitor是定義的用戶名及密碼

IMPORTANT: The Admin user account specified below requires special MySQL

Visit the following URL for more information:

MySQL hostname or IP address [localhost]: #被監控數據庫的IP及端口設置

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

MySQL Port [3306]:

Admin User []: root

Admin Password :

----------------------------------------------------------------------------

IMPORTANT: Less privileged accounts can be used to enhance monitoring security,

Visit the following URL for more information:

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

General Username []: general #以下部分創建用戶捕獲數據庫等相關的監控信息

General Password :

Limited Password :

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,

Installation directory: /opt/mysql/enterprise/agent

MySQL Enterprise Monitor UI:

Monitored MySQL Database:

Press [Enter] to continue :

Info to start the MySQL Enterprise Monitor Agent

The MySQL Enterprise Monitor Agent was successfully installed. To start the

View Agent Readme File [Y/n]: n

#以下部分啟動agent,至此安裝完畢,可以登陸到GUI界面進行監控

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved