安装MySQL Enterprise Monitor

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架构图及安装步骤

安装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  :

----------------------------------------------------------------------------
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.

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/eb2881fb1faf58ad46e27d0dd3ea2e02.html