Rob Young has posted a few blog entries lately on the MySQL Enterprise monitoring software. His latest post claims that agent-based monitoring is equivalent to extensibility (MySQL Enterprise Monitor: Agent = Extensibility).
I think this is conflating two completely distinct properties of a monitoring solution. Cacti is extremely extensible, with a plugin-based architecture and [...]
Baron posted something interesting about agent vs agent-less monitoring in response to Rob.
While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.
I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?
Trivially, you need some piece of software to collect data. With munin you configure a server that triggers scripts on the monitored servers. The set of data sources is governed by what you install in the correct directory on the monitored server. Cacti relies on SNMP heavily and also …
[Read more]Baron posted something interesting about agent vs agent-less monitoring in response to Rob.
While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.
I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?
Trivially, you need some piece of software to collect data. With munin you configure a server that triggers scripts on the monitored servers. The set of data sources is governed by what you install in the correct directory on the monitored server. Cacti relies on SNMP heavily and also …
[Read more]Server monitoring is a big part of running a solid web site. As an admin, you must know what is going on your server. One of the tools most Linux/Unix admins are used to is called “top”. “top” by itself is a very powerful tool. Here is a quick guide on how to read output from top: introduction to load averages under top. It just makes sense that somebody went and created httptop to monitor http traffic.
Install perl modules:
install Term::ReadKey
install File::Tail
install Time::HiRes
Now copy paste the script below and save it in a location and set
+x attribute on it so you can execute it. On my …
I have completed a rough draft of the first chapter of "Drupal Performance and Scalability". The first chapter of this online book is divided into four sections, the first of which focuses on the importance of fully defining your performance and scalability goals, helping you to identify what you need to accomplish and how to set concrete and attainable goals. The second section discusses monitoring and measuring your ongoing progress, helping you decide what you need to monitor, and how to monitor it. The …
[Read more]I’m attempting this is be as unbiased as possible, since I write the Monolith application. This will hopefully help one decide between a free MySQL server monitoring system and paying for a per-server based licensed product. Both have strengths and weaknesses that should be pointed out before making a decision. You can infer the weaknesses based on the strengths below. That said, let’s just get into it.
Strengths of each product over the other
Monolith - MySQL DBA Console
Revision: 8 - Last Update: September 03 2008
This is the first part of a series of short articles with a how-to approach about MySQL® Performance Monitoring, Tuning & Auditing. We will see the question from a GUI prospective. In particular we will describe which monitoring-oriented features HoneyMonitor, a GUI for MySQL® currently in alpha development, implements.
I will explain how HoneyMonitor let you
We will use only the 5.1.x series of the Server as we use some Scheduled Events and the Event Scheduler has been added only in the 5.1 branch. In particular we will use MySQL® 5.1.24-rc. We will also do some tests …
[Read more]I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, “jumped” is relative; Rohit asked me at the MySQL User Conference back in April, and here it is two months later, in June. My apologies to folks for being slow.
This review is an overall review of MONyog as well as specifically reviewing the newest features released in the recent beta (Version 2.5 Beta 2). Feature requests are easily delineated with (feature request). This review is quite long, feel free to bookmark it and read it at your leisure. If you have comments please add them, even if it takes a while for you to read this entire article.
While the webyog website gives some information about what MONyog can do, it is a bit vague about what MONyog is, although there …
[Read more]In case you are attending Oracle Open World 2008, the biggest Oracle conference in the world, and interested in either (or both) MySQL or Oracle Enterprise Manager Extensibility — I posted a proposal for a new presentation:
Extending Oracle Enterprise Manager by Example — Creating MySQL Management Plug-In
I’ve started looking into Oracle extensibility several years
ago and since then I’ve seen lots of improvements in
Extensibility Guide and many new plug-ins have seen the light of
the day. However, creating a new plug-in is still considered to
be something special and not available to mere mortals.
In this presentation we will see how easy it is to create a new
plug-in. What are the steps …
It’s been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was that the plug-in was certified by Oracle and added to OTN Oracle 10g Grid Control Extensions Exchange (see at the bottom).
I think the next version is due, as a few people have come back to me with some issues. The biggest was compatibility with Windows. Since I used the command line MySQL client, *nix and Windows shell incompatibilities were a major headache to solve, and I still couldn’t make it work reliably. I wanted to use DBI and DBD:MySQL, but it required installing and compiling Perl packages, which makes the deployment process very …
[Read more]