as_dbserver_check checks database servers' states by trying to connect to them. If any server is down, alarm messages are emailed to your company Web administrator and to your ISP support team (if needed). When the server goes back online, you'll receive another email message about it. Multiple DB servers of multiple DB types are supported. If you have an SMS sending engine (callable from PHP), every DB server state notification can be duplicated to SMS.
check_mysql_health is a plugin for the Shinken (Nagios) software that allows you to monitor a MySQL database. Among the list of metrics are time to login, index usage, bufferpool hit rate, query cache hit rate, slow queries, temp tables on disk, table cache hit rate, connected threads, and many more. Requirements are either a DBD::mysql Perl module or a MySQL client package.
Whiskers is an educational PocketPC application that tries to exploit all the hardware available on most common PDAs providing a link between different features such as GPS-Bluetooth-Wireless. Generally, whiskers was built with radio reconnaissance in mind as help for geocachers or wardrivers, but also as a penetration and audit tool. There is support for in-depth device scanning, triggering actions based on filters when certain devices are in range, centralized GPS logging with search functions for private or public databases, and much more.
Zero RRD Framework provides a central HTTP-based service for importing into standard RRD databases and for generating graphs. A lightweight, easily extendable agent for the data sources pushes updates with minimal resource consumption to the master service using HTTP. With the introduction of VMs for the service, it's easy to test-drive the application and even the architecture (connecting agents to the service in the VM).
NOC Project is an Operation Support System (OSS) for telecom companies, service providers, and enterprise Network Operation Centers (NOC). Areas covered by NOC include fault management, performance management, service activation/provisioning, knowledge base, multi-VRF address space management (IPAM), multi-vendor configuration management, DNS provisioning, peering management, RPSL and BGP filter generation, and reporting.
ExtSQL is not a new database server. It is a significant set of independently developed software additions and patches to the existing source code of both MySQL and PostgreSQL. It provides a new set of SQL language features that make it easy for a DBA to monitor and audit activity on a busy server and account for activity by user, database, or even connecting client host. It even includes the ability to store historical usage data in amounts and time intervals specified by the DBA. It is not a separate monitoring utility, but built into the core of both servers.
The MyCAT project is a toolset for managing MySQL/Linux servers, and could be helpful for anyone managing a network of *nix servers whether running MySQL Cluster, standard replication, or not running MySQL at all. At present, it contains three programs. rcall eases use and administration of groups (clusters) of *nix servers by creating logical groupings and a single location from which to run commands on all servers while entering it only once. It requires only an SSH connection. rep_mon is a replication monitor that notifies if a server is lagging or has encountered any errors. It handles any replication topology easily. binlog_mon monitors disk space used by MySQL binary logs, purging only when disk space is needed. It checks all slaves to ensure that purged files are not still being read by slaves. It has configurable behavior in the event that a slave still needs the oldest file.
mylbhelper helps dumb load balancers do their job. It monitors a local MySQL instance by periodically issuing a query. Should the query fail, a custom script, which typically would firewall off the load balancer, is executed. Likewise, when it comes back up, another script is executed. This means you can use any load balancer capable of distributing TCP traffic rather than one natively capable of talking MySQL. mylbhelper can also act solely as a monitoring daemon.
check_oracle_health is a plugin for the Shinken (Nagios) monitoring software that allows you to monitor various metrics of an Oracle database. It includes connection time, SGA data buffer hit ratio, SGA library cache hit ratio, SGA dictionary cache hit ratio, SGA shared pool free, PGA in memory sort ratio, tablespace usage, tablespace fragmentation, tablespace I/O balance, invalid objects, and many more.