Saturday, October 21, 2023

Install MySQL Enterprise Monitor on Windows

 

- Overview:

  • MySQL Enterprise Monitor provides real-time visibility into the performance and availability of all your MySQL databases.
  • MySQL Enterprise Monitor has the following components:
    • MySQL Enterprise Service Manager: analyzes, presents and stores the data collected by the agents. The data is stored in MySQL repository database. The service manager also contains a built-in agent which is used to monitor MySQL repository database and MySQL enterprise service manager host.
    • MySQL Enterprise Monitor Agent: monitors the MySQL databases instances and hosts, and collects data. The collected data is sent to MySQL enterprise service manager for analysis and presentation. The agent is installed on the same host as the monitored MySQL instances.
  •  There are two types of installation architectures:
    • MySQL Enterprise Monitor Architecture: where agents are installed on monitored hosts.


    • MySQL Enterprise Monitor Agentless Architecture: where the agent is not installed on the monitored hosts, and MySQL instances are monitored by the MySQL enterprise manager's built-in agent.



In this blog, we will demonstrate the steps to install MySQL Enterprise Monitor using the bundled MySQL repository database on Windows.

Step #1: Download MySQL Enterprise Monitor software

You can download installation software from https://edelivery.oracle.com/osdc/faces/SoftwareDelivery.  

1. Provide login credentials when asked and in search box type "MySQL Enterprise Monitor". Select "REL: MySQL Enterprise Monitor 8.0.35" product and click continue.























2. Select "Microsoft Windows x64 (64-bit) platform and click continue.








3. Accept License Agreement and click continue.
4. Select "MySQL Enterprise Monitor Service Manager" only and click download.








Step #2: Install MySQL Enterprise Monitor using GUI

- Installation overview:
  • Setup will install a bundled Tomcat server
  • Setup will create a bundled MySQL database instance to be used as a repository database. You will be asked to provide repository database information (MySQL database Repository admin user, password, MySQL database name, MySQL database port).  
  • Once setup completes Windows will create two services to manage start/stop Tomcat server and MySQL enterprise service manager.
  • MySQL Enterprise Monitor Console will be "https://localhost:18443".



1. Unzip downloaded software.
2. Run installer "mysqlmonitor-8.0.35.1504-windows64-installer.exe" and follow installation wizard as show below.




























3. Once setup completes, launch browser and connect to Monitor console "https://localhost:18443" to complete service manager installation and configuration.
- You need to enter user name and password for "manager" role user and "agent" role user.
- You can change data retention settings (default 4 weeks). I changed to 1 week in my setup.





















Thanks for reading. Hope you like it !!!. 



No comments:

Post a Comment

Oracle 23ai: Hybrid Read-Only Mode for Pluggable Databases

  - Overview: Oracle 23ai database introduces a new feature to open Pluggable database in  a new mode called hybrid read-only. Hybrid read-o...