Install MySQL Enterprise Monitor

Install MySQL Enterprise Monitor

MySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key performance indicators, hosts, disks, backups, new features, and architecture configurations in various scenarios. It also supports environments deployed from a single node to a massive number of nodes. It not only comprehensively monitors the running status of MySQL, but also promptly discovers potential problems and provides optimization suggestions. This document describes how to install MySQL Enterprise Monitor.

1. Installation Requirements

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, kernel t on Solaris if ZFS is used.

If using ZFS, comment out this parameter.

• It is recommended to set innodb_log_file_size = 2048 M.

 

2. MySQL Enterprise Monitor architecture and Installation Steps

A. Create a MySQL database independent of the Repository, or use
B. Install EM
C. Hold down the EM agent on each MySQL server to be monitored.

 

3. Install MySQL Enterprise Monitor

[Root @ SZDB tools] # ls-hltr
Total 999 M
-Rwxrwxr-x 1 robin mysql 252 M Sep 30 mysqlmonitor-3.0.15.3058-linux-x86_64-update-installer.bin
-Rwxrwxr-x 1 robin mysql 252 M Sep 30 mysqlmonitor-3.0.15.3058-linux-x86_64-installer.bin
-Rw-r -- 1 robin mysql 13 K Sep 30 05:09 README_en.txt
-Rw-rwxr -- 1 robin mysql 13 K Sep 30 05:09 READ_ME_ja.txt
-Rw-r -- 1 robin mysql 495 M Nov 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 # select the installation language
[1] English-English
[2] Japan-Japan region
Please choose an option [1]: 1
Info: During the installation process you will be asked to enter usernames and
Passwords for varous 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 # select the installation path

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: l

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

Please specify the following parameters for the bundled MySQL server

Repository Username [service_manager]: # Repository Username and password

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 instils MySQL Enterprise Monitor on your computer.

Installing # Start to install 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 wrongly ded when
Service Manager is installed, it is likely that your browser will display
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. Install the client
[Robin @ TESTDB ~] $ Rpm-qa | grep-I lsb # confirm that the following RedHat-lsb package has been installed
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] Japan-Japan region
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]: # select the Installation path

How will the agent connect to the database it is monitoring? # Select connection protocol

[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]: # select to monitor both the host and database

----------------------------------------------------------------------------
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 instils MySQL Enterprise Monitor Agent on your
Computer.

Installing # Install the agent
0% ______________ 50% ______________ 100%
######################################## #

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

Hostname or IP address []: 172.16.10.198 # IP address of Enterprise Monitor DB
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]: # enter the user name and password defined for installing 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]: # Set the IP address and port of the monitored Database

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 # create a user to capture database and other related monitoring information

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

# Start the agent in the following sections. After installation, you can log on to the GUI for monitoring.
[Root @ TESTDB opt] #/etc/init. d/mysql-monitor-agent start
Starting MySQL Enterprise Agent service... [OK]

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: