Not excited about paying for MySQL monitoring for your enterprise?

I think most people will agree that one of the biggest advantages of MySQL Community Server is that it’s free. Being free doesn’t get you a multi-million user community though; MySQL offers a great array of transactional engines, advanced high-availability features, robust I/O performance, and it powers many of the top-500 internet sites. When it comes to monitoring there are some great options, but many of them require a monthly service fee (sometimes on a per-server basis) or suffer from the following shortcomings: 1) lack of in-depth reporting on analytics and performance tuning, 2) high cost to feature ratio for small businesses that choose MySQL to save money, 3) have great features but require a knowledgeable sysadmin/DBA to install and manage.

The MySQL monitoring and analytics application that I write, Kontrollbase, is released as open-source software, and like MySQL it’s 100% free to own and use. It has all of the same features (and in some cases more) when compared to the pay-to-use options but without any cost. It requires that the user know how to setup SSH-keys, SNMP access, and run a Linux/Unix webserver; simple stuff for any sysadmin. However, some businesses don’t have a full time sysadmin available to do the installation and so they end up paying someone to run monitoring for them on a per-month cost basis.

I released Kontrollbase as an open-source application so that users of MySQL and small business owners would have all of the features for free that they would usually have to pay someone for. Time is not cheap but the installation of this app can be; so I’m offering installation services for a great price as well. If you need Kontrollbase installed then send me an email. I’ll get it installed and running on your company’s server for a $50 one time with an unlimited number of servers setup to be monitored and lifetime updates with no further cost. This price is limited to RHEL, CentOS, Fedora, Debian (&clones), and Ubuntu servers only. Solaris/BSD servers same cost + dependency package installation times extra. You can contact me at “contact@kontrollsoft.com” – just mention “Kontrollbase Install”.

To see how Kontrollbase compares to other monitoring solutions, check out the comparison chart on this page: http://kontrollsoft.com/software-kontrollbase#compare


Kontrollbase – new version available with improved analytics

A new version of Kontrollbase – the enterprise monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases – is available for download. There are several upgrades to the reporting code with improved alert algorithms as well as a new script for auto-archiving of the statistics table based on DATETIME – this will improve page load speeds on busy Kontrollbase servers. As usual you can access the downloads page or run “svn update” to get your new version today. http://kontrollsoft.com/software-downloads


Kontrollkit – new version available for download

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/


Kontrollbase – revision 297 fixes Reporter-CLI “alert_22″ sub-routine

Quick note to let our users know that there was an XML tag closure error on the “alert_22″ subroutine in the “bin/kontroll-reporter-cli.pl” script. This does not affect the webapp portion of Kontrollbase – only reports generated via the command line reporter script. It is not a fatal error but will cause the XML file to not validate – however you’ll still get the information in the report. If you’re interested in the code changes, you can see the diff by clicking here and scrolling to line 3110.

A simple “svn update” will fix this issue or you can wait until the next formal packaged release.


Kontrollbase – graph “no data to display” on new install has been fixed

If you have been wondering why the overview and graphs pages say “no data to display” on the graphs when you first install Kontrollbase, it’s because there’s no data in the database being returned from the queries that generate the graphs – this is because a new install has no data to graph. This has been fixed for new installs by generating blank data to display so that a new install has regular looking graphs with “.01″ data, instead of blank and confusing squares where graphs should be. You can find this change on revision 296 and up.


Having an issue with a Kontrollbase upgrade?

If you’ve noticed that your recent upgrade did not go as planned and now the application does not load – please check this page: http://wiki.kontrollsoft.com/wiki/UpgradingReleases for notes on upgrades between versions. Typically you need to execute a SQL file against the current schema to bring it up to date. If you have any questions please contact support.


Kontrollcomm – remote database and system command execution webapp

I’m pleased to announce the first release of Kontrollcomm – “The Server Command Automation Interface” is a web-based application that automates remote command execution on linux and unix based servers. There are three main areas of the application: Hosts, Templates, and Commands. The use is very simple: all of your hosts are setup in the Host Control tab, and they have templates associated with them. Templates are comprised of a list of commands that are to be run. It’s uses range from automating day to day sysadmin work, dba work, system reporting, server deployments, and any server task that benefits from automation. The application comes with default templates for MySQL master/slave servers, Tomcat, Resin, Apache, Oracle, PostgreSQL, and many other server roles. You can add an unlimited number of hosts, templates, and associated commands.

All of the client/server interaction is done over the web, with encryption and authentication (if using HTTPS and Apache AuthType), so no complex setup is needed other than to put the client script on the server. This method allows you to remotely manage command execution from a simple web interface – it automates the process of reporting (and other task executions) so that you no longer have to manually run reports and commands on the local server. Everything is managed in a centralized web based interface. Server administration and reporting is now more efficient.