Wednesday, January 2, 2013

MySQL database and host monitoring solution

More advanced MySQL database and host monitoring solutions with graphs and/or history and/or hints are:
MySQL Performance Monitor The FromDual Performance Monitor for MySQL/MariaDB is a monitoring solution based on Zabbix. It is freely available. More information about it you can find here.
MySQL Enterprise Monitor The MySQL Enterprise Monitor (aka Merlin or MEM) serves as an automated assistant for MySQL database administrators. For MySQL customers only!
cmon CMON - the Cluster Monitor for MySQL Cluster. CMON is the most comprehensive monitor for MySQL Cluster and collect all information that is possible to collect from the data nodes and management servers.
MySQL Activity Report The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.
MySQL Administrator Exterminated! Is replaced by the MySQL Workbench.
Kontrollbase Kontrollbase is a monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases. You can download it from here.
Zabbix Zabbix offers advanced monitoring, alerting and visualisation features.
Nagios Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes.
FromDual provides the following Nagios plugins for MySQL/MariaDB:
  • check_db
  • check_errorlog
  • check_repl_cnt_slave_hosts
  • check_repl_heartbeat
  • check_repl_io_thread
  • check_repl_sql_thread
  • check_repl_read_exec_pos
  • check_repl_seconds_behind_master
  • check_repl_readonly
  • perf
They can be downloaded from here. It is planned to make some more plugins for Nagios. Please make suggestions what you need next! PerfParse Add On for Nagios
Icinga Icinga (Nagios fork) is an enterprise grade open source monitoring system which keeps watch over a network and any conceivable network resource, notifies the user of errors and recoveries, and generates performance data for reporting.
Cacti Cacti is a complete network graphing solution designed to harness the power of RRDTool's data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box.
MySQL monitoring with Cacti
MRTG MRTG will monitor SNMP network devices and draw pretty pictures showing how much traffic has passed through each interface. MRTG is being used to graph all sorts of network devices as well as everything else from weather data to vending machines.
RRD RRDtool is the OpenSource industry standard, high performance data logging and graphing system for time series data.
Munin Munin is a networked resource monitoring tool that can help analyse resource trends and "what just happened to kill our performance?" problems.
Moodds moodss is a graphical monitoring application. Seems to be stalled since 2006. MySQL modules
Hobbit Monitor Hobbit is a system for monitoring servers and networks. It takes its inspiration from the Big Brother monitoring system. Hobbit is the successor to the bbgen toolkit, which has been available as an add-on to Big Brother since late 2002.
Big Sister Big Sister originally was the Big Sister network monitor. Now, multiple projects in the realm of system management and monitoring are run under the label Big Sister.
Monit Monit is a free open source utility for managing and monitoring, processes, files, directories and file systems on a UNIX system. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations.
SmokePing SmokePing keeps track of your network latency.
ksysguard KDE System Guard allows you to monitor various statistics about your computer.
GKrellM GKrellM is a single process stack of system monitors which supports applying themes to match its appearance to your window manager, Gtk, or any other theme.
Ganglia Ganglia is a scalable distributed monitoring system for high-performance computing systems such as clusters and Grids.
Hyperic Hyperic monitors the health and well-being of operating systems, VMs, app servers, web servers, databases, messaging servers, authentication systems, and more.
Uptime Software A single tool for simplifying the management of Virtual, Physical and Cloud environments. Monitor services, monitor applications, monitor servers, and monitor platforms from a unified dashboard, even across multiple datacenters.
Zenoss Zenoss assures IT service delivery to applications, business services and real-time physical, virtual, and cloud-based infrastructures.
openNMS OpenNMS is the world’s first enterprise grade network management application platform developed under the open source model.
GroundWork Monitor GroundWork Monitor Enterprise Edition is the most scalable open source system and network management software for companies with heterogeneous operating systems, application and hardware environments.
Tivoli Monitoring Monitoring software to help improve the effectiveness and efficiency of your IT department.
HP OpenView
CA Unicenter Proactively manage the performance and availability of your infrastructure including physical and virtual systems, networks, databases and applications.
Big Brother Big Brother Professional Edition (BBPE) is a simple way to measure the health of your heterogeneous IT environment at-a-glance.
Shinken
MONyog MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box" that helps MySQL DBAs manage more MySQL servers, tune their MySQL servers and fix problems with MySQL database applications.

MySQL quick poll for monitoring solutions

What monitoring software do you use? [Lit.]
Solution Votes %
none36540.240.2%
Nagios21123.323.3%
home grown solution859.49.4%
other788.68.6%
Big Brother384.24.2%
IBM Tivoli374.14.1%
HP OpenView313.43.4%
Mytop232.52.5%
CA-Unicenter151.71.7%
Ganglia141.51.5%
Moodss50.60.6%
Hyperic50.60.6%
A total of 907 votes have been cast in this poll so far. Poll opened January 24, 2005.

Linux Journal survey about Linux monitoring

What is your favourite Linux monitoring application?
Solution Votes %
Zabbix39433.233.2%
Nagios37331.431.4%
Uptime Software917.77.7%
other776.56.5%
Cacti625.25.2%
Hyperic524.433.2%
Zenoss514.34.4%
Ganglia413.53.5%
OpenNMS342.92.9%
Groundwork121.01.0%
A total of 1187 votes have been cast in this poll until April 21, 2010.

No comments:

Post a Comment