Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 7 modules, such as the new myerrorlog and myhealth modules, are available.
This version adds the new *myerrorlog* module, which allows monitoring the error log of a database server, local or remote. The messages are displayed in a table, refreshed at a settable interval. Messages are regrouped, sorted according to their importance level and time of arrival. Thresholds can be set so that the administrators may be warned when new errors occur. This module is important and extremely useful, and required quite a large amount of work: importance levels have been determined for more than 350 messages that can be generated by the MySQL server in its error log. For example, it is now possible to alert several administrators with an email when a critical message appears in any database server in your enterprise. Or you could easily visualize an error log summary on a specific server, with all messages sorted by importance level, date and number of occurrences, in an easy to read table, printable for reports. Of course, you may use this module along with any other moodss module, to monitor any number of servers. I suggest making a dashboard monitoring all you enterprise database servers, using the myhealth and myerrorlog modules. This module was designed with the extremely valuable suggestions and help of Sinisa Milivojevic <[EMAIL PROTECTED]>, whom I wish to sincerely thank for his input. More examples and documentation can be found in the module help file, at http://jfontain.free.fr/myerrorlog/myerrorlog.htm, various screenshots and other modules for MySQL (myhealth, mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/ . Main features of moodss and its MySQL modules: * monitor as many servers (such as replicated) as you wish, on the same dashboard * threshold alerts forwarded by email to the administrators * performance, statistics (graphs, pies, ...) and errors monitoring * background monitoring with the moomps daemon * monitor servers residing on any MySQL supported platforms (UNIX, Windows, ...) * can be combined with server system monitoring (cpustats, memstats, mounts, ...), network monitoring (snmp, snmptrap, ...) and web server monitoring (apache, apachex, ...) to construct a site wide monitoring station * critical errors and warnings reporting directly from the MySQL error log, even on remote machines * native connection to the database servers or via ODBC * Windows support (except for the myerrorlog module at this time) Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Watch this space for new modules... Downloads: http://jfontain.free.fr/moodss-15.7.tar.bz2 http://jfontain.free.fr/moodss-15.7.zip http://jfontain.free.fr/moodss-15.7-1.i386.rpm http://jfontain.free.fr/moomps-1.3-1.i386.rpm http://jfontain.free.fr/moodss-15.7-1.spec Enjoy! -- Jean-Luc Fontaine --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php