Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

Introduction

Monyog provides monitors and advisors for MySQL database administrators, helping you to manage more database servers, tune your database infrastructure, and identify any issues with your database applications. It monitors enterprise environments and provides expert advise so that even someone new to MySQL can tighten security, optimize performance and reduce downtime of MySQL powered systems.

Features

In technical terms, Monyog is essentially a web server with a very low resource footprint. As such, it has much in common with popular web servers such as Apache, Nginx, IIS, Lighttpd and so on, but there are some important differences.

In order to access Monyog, you need a web browser that is capable of handling AJAX and Flash. This has been tested on Internet Explorer (versions 5.5 and later), Mozilla Firefox and related browsers, and all recent releases of the Opera browser.

  • Monitoring Optimization
  • Unlimited Servers Side-by-Side
  • Scripting with JavaScript
  • Agent-less Monitoring
  • Built-in High Performance Database

Monitoring Optimization

Where web servers are general purpose applications, Monyog is a more specialized server application. It is purpose built for collecting and storing information on MySQL database servers and the systems that host them. You can't use it to host your own webpages as it's locked to only display those pages that the Monyog application was designed to serve.

Monyog uses the Asynchronous JavaScript and XML (AJAX) language to communicate with the server and generate pages divided into small, independent objects that it can then individually update as required. This reduces bandwidth consumption, given that you don't need to reload the entire page for updates and allows you to display data on as many MySQL servers as you want.

Each of the HTML objects in Monyog AJAX pages refresh automatically when new data becomes available. This refresh is independent for each MySQL server being displayed on the page. Refreshes happen at the server-level.

Unlimited Servers Side-by-Side

When using Monyog Enterprise, Charts show real-time graphs of all import metrics that provide a consolidated view into the availability and performance of all the MySQL servers across the enterprise. From these real-time charts, the MySQL database administrator can instantly see:

  • The availability status of all MySQL servers,
  • Import operating system metrics that may affect MySQL,
  • Side-by-side comparison of similar servers,
  • Which MySQL servers need attention, and
  • Where and how they need to spend limited time.

Scripting with JavaScript

Monyog includes an embedded JavaScript engine, similar to most modern browsers. The entire Monyog application logic is handled through JavaScript objects, such as defining threshold values, calculating performance metrics and sending alerts. The complete source code for these JavaScript objects is available for customization, making them fully editable, extensible and configurable as your use-cases require.

Agent-less Monitoring

Typically, monitoring and advisory tools use external PHP or Java agents to allow traditional web servers to connect to MySQL. Unlike these tools, Monyog is compiled with the MySQL client code through the C API, allowing to connect directly to MySQL database servers without needing agents.

This greatly simplifies Monyog deployments, given that you don't need to install and maintain agents on each MySQl host. Instead, Monyog uses the MySQL client to connect to and retrieve database information. To retrieve operating system-level metrics it uses SSH when connecting to Linux hosts.

You install Monyog on one host and that's it. It can retrieve whatever information it needs using the same sources and methods as a database administrator.

Built-in High Performance Database

Internally, Monyog manages the data it collects using a high-performance embedded database. Whatever server parameters it retrieves from MySQL servers are also stored in this database. Various methods in displaying counters or metrics are based on the data it provides.