sorted by: recent | see : popular

Content Tagged with enterprise + monitoring

After last week’s post on agents versus agentless monitoring systems, I got a lot of email. One, from a customer whose name I am not permitted to mention, sent me the following action shot (posted with permission):

Over half a gigabyte; more than twice what MySQL itself is using. So, that raises an interesting question. How much memory would you say your server’s MySQL Enterprise Monitor agent uses? No bashing allowed, tell the truth. And please post if your agent runs in a small amount of memory, too.

Another thing I’m interested in: what factors contribute to the high memory usage? Under what conditions does it use a lot or a little? What can you expect, generally speaking?

On another note, I think it’s almost unfair not to mention the competition, so I will: I was playing with MONyog 2.6 recently and it started to use a lot of CPU. I think it might be architecture-specific (amd64 Ubuntu) but I can’t be sure. It was using 170% CPU on my dual-core system to monitor 2 instances.

monitoring, MONyog, mysql, MySQL Enterprise Monitor

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

• presents overall database size, index size, data size, number of schema per server, and aggregate statistics for all monitored servers
• runs mysql server backups remotely and reports on backup state execution
• collects cnf files from each server during the talkback script execution for historical viewing
• built on the LAMP stack, no need for tomcat/jboss knowlege
• provides overall server report, and change control documentation with recommended actions for tuning the server(s)
• application can run under Redhat Cluster Services for high availability
• comes with XML export API for off-application data processing and trending
• compatible with Visual Mining
• is FREE software, GPL licensed, costs absolutely nothing to the user

MySQL Enterprise Dashboard

• customizable alerting instead of fixed alerts
• fine tuned date range graphing (from date to date instead of last X days)
• support for bug tracking that utilizes hooks into bugs.mysql.com
• uses local server agent for information gathering, allows CPU and OS memory to be reported on
• presentation design is arguably more easy on the eyes
• comes with the MySQL Enterprise Server software, and thus a support contract from MySQL/Sun.
• customizable organization of server list instead of organization by client name

Feel free to post your viewpoints on each if you have used both products. I’m always interested in what users have to say.

You can get Monolith here: http://sourceforge.net/projects/monolith-mysql

You can get MySQL Enterprise here: http://www.mysql.com/products/enterprise/ 

Enterprise Scalable Realtime Graphing

The Zenoss system brings together many types of monitoring and management information. The information is available through a standard web browser. In fact all aspects of the system are accessed though the web there is no need to edit configuration files.

You want IT management software that works for you, not software that makes you work. You wish you could have it... without spending a fortune. Your wish is granted.

openQRM is an open source systems management platform that automates enterprise data centers and keeps them running