Tuesday, June 2, 2015

Install MySQL Enterprise Monitor Server & Agent


[root@mysql03 repo]# ./mysqlmonitor-3.0.21.3149-linux-x86_64-installer.bin
Language Selection
 
Please select the installation language
[1] English - English
[2] Japanese - 日本語
Please choose an option [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]:
 
----------------------------------------------------------------------------
Select Requirements
 
Select Requirements
 
Please indicate the scope of monitoring this installation will initially encompass so we can configure Tomcat and MySQL memory usage accordingly. The manual contains instructions for updating the configuration later, if needed. This installation will monitor a:
 
System Size
 
[1] Small system: No more than 5 to 10 MySQL Servers monitored from a laptop computer or low-end server with no more than 4 GB of RAM
[2] Medium system: Up to 100 MySQL Servers monitored from a medium-size but shared server with 4 GB to 8 GB of RAM
[3] Large system: More than 100 MySQL Servers monitored from a high-end server dedicated to MEM with more than 8 GB RAM
Please choose an option [2] : 1
 
----------------------------------------------------------------------------
Tomcat Server Options
 
Please specify the following parameters for the bundled Tomcat Server
 
Tomcat Server Port [18080]:
 
Tomcat SSL Port [18443]:
 
----------------------------------------------------------------------------
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
 
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]:
 
Password :
Re-enter :
MySQL Database Port [13306]:
 
MySQL Database Name [mem]:
 
 
 
Use SSL when connecting to the database [y/N]:
 
 
----------------------------------------------------------------------------
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
 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:
/opt/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 :

 




[mysql@mysql01 repo]$ ./mysqlmonitoragent-3.0.21.3149-linux-x86-64bit-installer.bin
Language Selection
 
Please select the installation language
[1] English - English
[2] Japanese - 日本語
Please choose an option [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 [/mysql/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] : 1
 
----------------------------------------------------------------------------
Setup is now ready to begin installing MySQL Enterprise Monitor Agent on your
computer.
 
Do you want to continue? [Y/n]:
 
----------------------------------------------------------------------------
Please wait while Setup installs MySQL Enterprise Monitor Agent on your
computer.
 
 Installing
 0% ______________ 50% ______________ 100%
 #########################################
 
----------------------------------------------------------------------------
MySQL Enterprise Monitor Options
 
Hostname or IP address []: mysql03
 
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]: emagent
 
Agent Password :
Re-enter :
----------------------------------------------------------------------------
Configuration Report
 
 
 
MySQL Enterprise Monitor Agent (Version 3.0.21.3149)
 
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: /mysql/mysql/enterprise/agent
 
MySQL Enterprise Monitor UI:
-------------------------
Hostname or IP address: mysql03
Tomcat Server Port: 18443
Use SSL: yes
 
 
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:
/mysql/mysql/enterprise/agent/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
 
[mysql@mysql01 repo]$ /mysql/mysql/enterprise/agent/etc/init.d/mysql-monitor-agent start
Starting MySQL Enterprise Agent service... SUCCESS!