MySQL Enterprise Monitor

MySQL Enterprise Monitor merupakan tools monitoring database mysql yang disediakan MySQL untuk customernya yang telah membeli support & service MySQL Enterprise paket Silver, Gold, atau Platinum, tools ini sangat berguna untuk seorang DBA MySQL yang memonitor banyak server mysql database dengan replikasi maupun cluster

kali ini gw install mysql monitor versi trial 30-hari di mesin Linux CentOS:
[root@bizgres2 david]# uname -a
Linux bizgres2.solusi247.com 2.6.9-55.0.6.EL #1 Tue Sep 4 21:10:58 EDT 2007 i686 athlon i386 GNU/Linux
[root@bizgres2 david]# cat /etc/redhat-release
CentOS release 4.5 (Final)

untuk dapat men-download & meng-install MySQL Enterprise Monitor sebelumnya anda harus mengisi form disini http://mysql.com/trials/trymysql dan setelah selesai daftar, check account email anda saat daftar, dan download source: mysql_monitoring_service.key, mysqlmonitor-1.3.2.9126-linux-x86-installer.bin, mysqlserviceagent-1.3.2.9118-linux-x86-glib

c2.3-installer.bin disini https://enterprise.mysql.com/monitoring/download.php

Install mysqlmonitor-1.3.2.9126-linux-x86-installer.bin :

[root@bizgres2 david]# wget http://10.1.80.243/aankblog/mysqlmonito … taller.bin
–09:38:03– http://10.1.80.243/aankblog/mysqlmonito … taller.bin
=> `mysqlmonitor-1.3.2.9126-linux-x86-installer.bin’
Connecting to 10.1.80.243:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 84,384,601 (80M) [application/octet-stream]

100%[====================================>] 84,384,601 3.87M/s ETA 00:00

09:38:28 (3.27 MB/s) – `mysqlmonitor-1.3.2.9126-linux-x86-installer.bin’ saved [84384601/84384601]

[root@bizgres2 david]# chmod +x mysqlmonitor-1.3.2.9126-linux-x86-installer.bin
[root@bizgres2 david]# ./mysqlmonitor-1.3.2.9126-linux-x86-installer.bin –mode text
Language Selection

Please select the installation language
[1] English
[2] Japanese
Please choose an option [1] : 1
—————————————————————————-
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]:

—————————————————————————-
Repository Configuration

Please specify the following parameters for the bundled MySQL server

Repository Username [service_manager]:

Password :
Re-enter :
Bundled MySQL Database Port [13306]:

—————————————————————————-
Configuration Report

Note:

The settings you specified will be saved here:
/opt/mysql/enterprise/monitor/configuration_report.txt

IMPORTANT: This configuration report includes passwords stored in plain text; it
is intended to help you install and configure your agents. We strongly advise
you to secure or delete this text file immediately after installation

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 and product activation information. 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.

Info: To configure the MySQL Enterprise Monitor please visit the following page:
http://localhost:18080/merlin/Auth.action
Press [Enter] to continue :
[root@bizgres2 david]#

Install mysqlserviceagent-1.3.2.9118-linux-x86-glibc2.3-installer.bin :

[root@bizgres2 david]# wget http://10.1.80.243/aankblog/mysqlservic … taller.bin
–10:13:06– http://10.1.80.243/aankblog/mysqlservic … taller.bin
=> `mysqlserviceagent-1.3.2.9118-linux-x86-glibc2.3-installer.bin’
Connecting to 10.1.80.243:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 5,369,860 (5.1M) [application/octet-stream]

100%[====================================>] 5,369,860 2.31M/s

10:13:09 (2.30 MB/s) – `mysqlserviceagent-1.3.2.9118-linux-x86-glibc2.3-installer.bin’ saved [5369860/5369860]

[root@bizgres2 david]# chmod +x mysqlserviceagent-1.3.2.9118-linux-x86-glibc2.3-installer.bin
[root@bizgres2 david]# ./mysqlserviceagent-1.3.2.9118-linux-x86-glibc2.3-installer.bin –mode text
Language Selection

Please select the installation language
[1] English
[2] Japanese
Please choose an option [1] : 1
—————————————————————————-
Welcome to the MySQL Enterprise Service Agent Setup Wizard.

—————————————————————————-
Please specify the directory where MySQL Enterprise Service Agent will be installed

Installation directory [/opt/mysql/enterprise/agent]:

—————————————————————————-
Monitored Database Information

MySQL hostname or IP address [127.0.0.1]: 10.1.80.4

Validate MySQL hostname or IP address [Y/n]: Y

Hostname to display (optional) []: MySQL4.1_on_10.1.80.4

MySQL Port [3306]:

MySQL Username []: david

MySQL Password :
Re-enter :
—————————————————————————-
MySQL Enterprise Monitor Options

Hostname or IP address []: 127.0.0.1

Port [18080]:

Agent Username [agent]: david

Agent Password :
Re-enter :
—————————————————————————-
Configuration Report

Here are the settings you specified:

Installation directory: /opt/mysql/enterprise/agent

Monitored MySQL Database:
————————-
Hostname or IP address: 10.1.80.4
Hostname to display: MySQL4.1_on_10.1.80.4
Port: 3306
MySQL username: david
MySQL password: password

MySQL Enterprise Monitor:
————————-
Hostname or IP address: 127.0.0.1
Port: 18080
Agent username: david

Press [Enter] to continue :

—————————————————————————-
Setup is now ready to begin installing MySQL Enterprise Service Agent on your computer.

Do you want to continue? [Y/n]: Y

—————————————————————————-
Please wait while Setup installs MySQL Enterprise Service Agent on your computer.

Installing
0% ______________ 50% ______________ 100%
#########################################

—————————————————————————-
Start MySQL Enterprise Service Agent

Info to start MySQL Enterprise Service Agent

The MySQL Service Agent was successfully installed. To start the MySQL Agent
please invoke:
/opt/mysql/enterprise/agent/etc/init.d/mysql-service-agent start
Press [Enter] to continue :

—————————————————————————-
Setup has finished installing MySQL Enterprise Service Agent on your computer.

[root@bizgres2 david]#

[root@bizgres2 david]# /opt/mysql/enterprise/agent/etc/init.d/mysql-service-agent start
Starting MySQL Enterprise agent service… [ OK ]

[root@bizgres2 david]# cd /opt/mysql/enterprise/agent/etc/init.d/

[root@bizgres2 init.d]# ./mysql-service-agent status
MySQL Enterprise agent is running
[root@bizgres2 init.d]#

Referensi:
https://enterprise.mysql.com/docs/monitor/1.3/en/

semoga bermanfaat…

Advertisements

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer. View all posts by davidand

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: