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

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  ]

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏游戏杂谈

多线程中避免使用信号量

项目中遇到一个bug,因为接入了几家越狱平台:91、同步推、PP助手,在设备上安装了三个应用,启用其中任意一个,另外二个启动后无法创建发送socket消息,从而...

1823
来自专栏Gaussic

使用IntelliJ IDEA开发SpringMVC网站(三)数据库配置 顶

访问GitHub下载最新源码:https://github.com/gaussic/SpringMVCDemo

882
来自专栏小筱月

SSM整合开发

controller:作为请求转发,调用service接口处理逻辑,页面所有路径的访问方法:控制层的命名空间+@RequestMapping的value ser...

3471
来自专栏腾讯数据库技术

一个ext4的Bug分析过程

8272
来自专栏happyJared

Python中的ORM工具:Peewee

上一篇文章介绍了Pyhton中的ORM工具:SQLAlchemy。本文延续之前的风格,介绍另一个ORM模块:Peewee,希望通过简单的CRUD示例可以帮助大家...

3294
来自专栏XAI

SpringMVC+MongoDB+Maven整合(微信回调Oauth授权)

个人小程序。里面是基于百度大脑 腾讯优图做的人脸检测。是关于人工智能的哦。 2017年第一篇自己在工作中的总结文档。土豪可以打赏哦。 https://git.o...

8197
来自专栏java思维导图

mybatis-plus思维导图,让mybatis-plus不再难懂

 Mybatis 是一款优秀的持久层框架,它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果...

1.3K18
来自专栏二进制文集

Netty 之传统 BIO、NIO 编程

系列文章:http://www.jianshu.com/p/594441fb9c9e

1316
来自专栏高性能服务器开发

(五)如何编写高性能日志

一、服务器端日志与客户端日志的区别 在正式讲解之前,我们先来看一个日志类的实现方法,这个日志类也是代表着大多数客户端日志的主流写法: /** *@desc:...

4048
来自专栏黑泽君的专栏

day32_Hibernate学习笔记_04

  缓存(Cache):是计算机领域非常通用的概念。它介于应用程序和永久性数据存储源(如硬盘上的文件或者数据库)之间,其作用是降低应用程序直接读写硬盘(永久性数...

982

扫码关注云+社区

领取腾讯云代金券