MySQL Enterprise Service Manager

Since Oracle bought MySQL lots of new products have been released and "MySQL Enterprise Service Manager" is one of these.

There is a license to pay if you decide to use in a production environment. However, there is also a trial period of 30 days too.

Let's try it out, shall we ?

The binary that is necessary to install is : mysqlmonitor-2.3.13.2193-linux-x86_64-installer.bin and is available on the following link "http://dev.mysql.com/downloads/"

A completed MySQL database installation is also necessary before installing the "Enterprise Service Manager", see the November's blog at "http://alessiodba.blogspot.it/2013/11/mysql-56-e-oracle-linux-64.html" for further information.

Keep in mind that "MySQL Enterprise Database" also requires a license but a trial period exists too.

Let's start, shall we ?

1) Create the em_agent user in the MySQL database. This user is going to be used during the installation of the "MySQL Enterprise Service Manager"

    MSQL>grant all on *.* to 'em_agent'@'127.0.0.1' identified by 'pwd';
    MSQL>grant all on *.* to 'em_agent'@'localhost' identified by 'pwd';

Be careful ! Since I haven't got time right now I won't look the correct grant up in the reference manual but don't do so in a production environment !

2) Execute the command : mysqlmonitor-2.3.13.2193-linux-x86_64-installer.bin

Following you'll find the output of the command and what's more all the answers of the prompt.

[root@SERVER_TEST] > ./mysqlmonitor-2.3.13.2193-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]:

----------------------------------------------------------------------------
Tomcat Server Options

Please specify the following parameters for the bundled Tomcat Server

Tomcat Server Port [18080]:

Tomcat Shutdown Port [18005]:

Tomcat SSL Port [18443]:

Is SSL support required?           [y/N]: N

----------------------------------------------------------------------------
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] : 2

* Please note that the Enterprise Monitor requires a specific version of the
MySQL server for its own data repository in order to operate correctly. We will
validate the version of your existing server during the installation. See the
documentation for details based on the version of the Enterprise Monitor you are
installing.

Visit the following URL for more information:
http://dev.mysql.com/doc/mysql-monitor/2.3/en/mem-server-install-generic.html
----------------------------------------------------------------------------
Repository Configuration
Please specify the following parameters for the existing MySQL server
Repository Username [service_manager]: em_agent
Password :xxxx
Re-enter :xxxx

MySQL Hostname or IP address [127.0.0.1]:
MySQL Database Port [3306]:
Use SSL when connecting to the database [y/N]: N----------------------------------------------------------------------------
Configuration Report

You have not installed the MySQL Enterprise Monitor as the root user. Therefore
it could not be configured to auto-start on reboot. See the Installation section
of the MySQL Enterprise Monitor documentation for instructions on how to do this
manually.

Press [Enter] to continue :
----------------------------------------------------------------------------
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 Dashboard and complete
the initial setup. Refer to the readme file for additional information and a
list of known issues.

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:
http://localhost:18080
Press [Enter] to continue :

3) A web service will be started and it'll be available at the following link :"http://localhost:18080"

4) Using the web page of the previous link create a new user "em_dba". This user will be used to access the EM console.

That's all.


Following you'll find other handy commands :

1) To start and stop EM console :  /opt/mysql/enterprise/monitor/mysqlmonitorctl.sh [stop|start]

2) To obtain the status of the EM console :     /opt/mysql/enterprise/monitor/mysqlmonitorctl.sh status
        MySQL Enterprise MySQL is running
        MySQL Enterprise Tomcat is running

3) To debug the EM console :
    /opt/mysql/enterprise/monitor/apache-tomcat/logs/mysql-monitor.log
    /opt/mysql/enterprise/monitor/configuration_report.txt


Pretty soon I'll tell you how to install the MySQL agent so keep in touch with the blog.

See you soon !

Byee