We decided that the simplest way for people to experience the new version of Kontrollbase was to setup an online, fully functional demo. Now you don’t have to download and install the application to see what it offers to your database environment. The application is free, the demo is free, check it out now: http://kontrollsoft.com/software-kontrollbase#demo – while you’re there be sure to check out the comparison between Kontrollbase and other MySQL monitoring applications.

The latest release has a lot of great improvements that you’ll be sure to enjoy.

• ExtJS upgraded to version 3
• Host, User, Client, Alerts pages all updated to use GridPanels
• Documentation on the VMware Virtual Appliance added to docs
• More JSON responders to replace static page status events
• Login no longer has an “OK” on successful authentication
• New CSS UI theme – Slate

As usual you can download here: http://kontrollsoft.com/software-downloads

Kontrollbase VMware appliance is uploaded and ready for use. Get it here: http://kontrollsoft.com/software-downloads

Had to fix a service process error on the original release of the appliance. It’s now fixed and the machine export is running. I’ll have the new file uploaded and ready for use at approximately 20:00PST (GMT +8).

We’re pleased to announce that Kontrollbase 2.0.1-rev70 is available as a VMware Appliance. This means you can download it and run it with VMware Player, Vmware Server 2, or ESXi 3.5 which greatly simplifies the whole installation process. It’s configured as follows:

• CentOS 5.2 64bit
• 1024MB RAM
• 8GB partition – autosized
• Apache 2
• MySQL 5.0
• PHP 5

So, get it now by downloading here: http://kontrollsoft.com/software-downloads

Nice changes in this release. We have a lot of good changes including an advanced caching library, support for eaccelerator, support for memcached, an obfuscated client script to increase security, an optional compiled version of the client script for running on 64bit Fedora servers, as well as the usual bug fixes here and there. A full list of changes can be seen here: http://code.google.com/p/kontrollbase/source/list

As usual, you can download the new release here: http://kontrollsoft.com/software-downloads

I’ve started work on a c++ version of the Kontrollbase client script but am not as experienced in c++ as I’d like to be and don’t have the time to learn more c++ at the moment. The idea being that the client script written in perl has a lot of module dependencies and that complicates rolling out the client to large server farms. A compiled C++ script will be a drop-in solution.

So, if someone that is talented with c++ on Linux wants to help out the project and write a quick script involving a connection to mysql to run queries, and then connect to SNMP to gather system information, then export all of that to stdout as XML… let me know! I already have the MySQL part outputting XML so we just need the SNMP part and some error checking. Email me at themattreid at gmail dot com or commetnt on this post if interested. You’ll get credit on the project as a contributor.

Came across an error on the sql for the overview.php page. It wasn’t correctly displaying aggregate data on the charts. So here’s the fix for rev50 to rev51. This isn’t a deal breaker on the release but if you’re inclined to open system/application/models/model_main.php and replace one line it’s easier than waiting for our next release.

2001c2001
< $sql = "select $xval,DATE_FORMAT(Creation_time,'%m-%d %H:%i') as Date from server_statistics WHERE Creation_time BETWEEN '$sday' AND '$eday' GROUP BY DAY(Creation_time),HOUR(Creation_time) ORDER BY Creation_time";
---
> $sql = "select max($xval) as $xval,DATE_FORMAT(Creation_time,'%m-%d %H:%i') as Date from server_statistics WHERE Creation_time BETWEEN '$sday' AND '$eday' GROUP BY DAY(Creation_time),HOUR(Creation_time) ORDER BY Creation_time";

Nice changes in this release. We have a new tab on the host page for “Variables” which contains three sub tabs: “cnf file”, “global variables”, and “global status”. These tabs display the most recent information gathered from your servers in the event that you would like to see the raw data that is going on. It’s also nice to be able to refer to this data without having to login to the server to get it.

As usual, you can download the new release here: http://kontrollsoft.com/software-downloads

I’m pleased with the results of Kontrollbase so far. We’ve had 87 downloads in the last month without any official promotion other than this blog and syndication to planet.mysql.com - so thank you to all of those users that are trying out the application. I’d love to hear your thoughts.. Any feedback about the installation process, the client setup, documentation, and general usefulness would be great. So if you have used it please take a quick minute to leave a comment or send me an email. Thanks everyone, and remember you can always post improvements or bugs at the following link: http://code.google.com/p/kontrollbase/issues/entry