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.
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
- Agent-less Monitoring
- Built-in High Performance Database
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.
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.
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.