Monyog is the best out-of-the-box GUI monitoring tool for MySQL that I have seen. It “just works.” As promised, getting up and running quickly is easy, and having a centralized location for monitoring is very useful. The graphs are beautiful and the statistics that are graphed are useful time-savers.
The biggest difference between MySQL’s Enterprise Monitor and Monyog is that Monyog is agentless. At Pythian, we have many clients with differing security requirements. Requiring a daemon process to be running is not something we currently do, and it might be a hard sell for some clients. Even if every client was amenable to it, making sure the daemon is up and running on each MySQL server is tedious. Note that agentless operation works for every feature, including log analysis as well as operating system statistics.
We are an IT Consulting Company that supports many clients with data intensive applications and it is extremely crucial for us to store and secure data of our customers/ clients through managing large databases to ensure a seamless user experience.
Monyog has greatly assisted in the monitoring of our MySQL database servers. We primarily use it for our Point-Of-Sale system where we have several database servers running 24/7. With Monyog, we have the ability to refresh the processlist every second to see if at any point one or more servers are overloaded.
The sniffer mode allows the team to get information of User & Host for a query that is getting executed which is otherwise not possible with Performance Schema. This simplified the entire process for monitoring each query and finding the count of a query which is being executed, total time for which the query is running, and so on.
When we detect an issue, it makes for a quick response to remove the offending server from the cluster. We plan to use Monyog MySQL monitor for this feature for many more years.