kontrollbase
Kontrollbase is a monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases. It is an enterprise grade application that is built on the open-source software model and features advanced frameworks (CodeIgniter, ExtJS) to provide you with the tools to automate the administration of hundreds and even thousands of database servers. It offers the same, and in many cases more, features than the commercial software offerings but without the hefty price tag for support or licensing. MySQL has always been a free relational database — shouldn’t the monitoring software be free too? Try Kontrollbase and see why enterprises all over the world are praising this open-source application.
Download Kontrollbase Now.
Kontrollbase Documentation
Kontrollbase Screenshots Page
 |  |  |
Want to demo Kontrollbase online?
Demo Server Offline Temporarily
Use the folllowing to login – username: “demo”, password: “password”
This is a demo account with standard tier privileges. You can view everything but are not allowed to edit system settings or add new users, clients, or hosts as you would with the administrator account. This demo will give you an idea of the graphing, reporting, and current features of the product.
Do you need Kontrollbase?
You do if you want the following:
- You want a powerful monitoring system that is specifically designed for MySQL.
- You need in-depth analysis and performance-tuning recommendations for your servers.
- You need a large range of performance graphs for historical data analysis and data correlation.
- You need a large range of alerts so you are always kept up to date on your server’s health.
- You need a monitoring system that is secure and has code that is available for anyone to audit.
- You want an application that will run on the LAMP stack, use minimal resources, and is intuitive to use.
- You want multi-tier authentication so that DBAs, managers, engineers, and hosting/SaaS clients can access reports and data.
- You do not want to pay for a service contract or license agreement just to manage your servers.
- You want a consistent release cycle that responds to user input and feature requests.
- You want a personal response to support questions, a knowledgeable user community, and a quality product.
Comparison of popular MySQL Monitoring Applications
| Kontrollbase | MySQL Enterprise | MonYog / SysYog | |
|---|---|---|---|
License+Support cost for full application feature set | FREE | $4999 | $999 |
| Free to own and use |  | ||
| Support available for free | | ||
| Runs as an enterprise grade server application with multi-user experience | | | |
| Runs as a desktop only application | |
||
| Supports MySQL 5.0 and 5.1 | | | |
| Runs on the LAMP stack | | ||
| Support for Memcached | | ||
| Support for eAccellerator | | ||
| Support for query distribution scaling | | ||
| Open Source code | | ||
| SVG based graphing | | ||
| Supports 32bit and 64bit servers | | | |
| Works on Linux, Solaris, BSD, OSX | | | |
| Monitor unlimited number of hosts | | | |
Polling agent runs centrally or on each remote host | your choice | all host | central |
| Customizable data collection timings | | ||
| Default method for database connection uses insecure 'root' user acces |  |
||
| Client does not require root access to database or OS | | | |
| Monitors database accounts for security | | | |
| Real-time performance tuning reports with variable setting suggestions | | ||
| Secure SSH connections with hosts | | | enterprise only |
| Collects cnf file from server for historical analysis | | ||
| Historical data gathering and analysis | | | |
| Alerts with solutions and documentation links | | ||
| Over 50 graphs with date range analysis | | ||
| Online documentation | | |
|
| Utilizes advanced AJAX UI | | | |
| Multi-tier authentication | | | |
| Ideal for Hosting/SaaS industry without added cost to clients | | ||
| Ideal for Hosting/SaaS industry if cost is absorbed by clients | | |
|
| Support available via email, irc, aim, yim, jabber | | ||
| Replication monitoring and alerting | | | |
| U.S. based company, support team, application developers | | ||
| check: number of connection failures | | | |
| check: number of connections errors | | | |
| check: binary logging not enabled | | ||
| check: sync_binlog not set | | ||
| check: max_used_connections too high | | | |
| check: query cache size too small/large | | | |
| check: memory usage over 85% of system ram | | ||
| check: table scans excessive | | | |
| check: tmp table to disk ratio too high | | | |
| check: innodb buffer too small/large | | | |
| check: key buffer too small/large | | | |
| check: sort buffer too small/large | | | |
| check: join buffer too small/large | | | |
| check: open_files_limit ratio too small | | | |
| check: table locks too high | | | |
| check: table cache too small/large | | | |
| check: thread cache too small/large | | | |
| check: binlog size too small | | | |
| check: excessive disk tmp table usage | | | |
| check: flush time not zero value | | | |
| check: indexes not being utilized properly | | ||
| check: innodb doublewrite buffer enabled | | | |
| check: innodb flush method not properly set | | ||
| check: innodb isolation not set for ACID | | ||
| check: innodb log wait time too high | | | |
| check: conncurrent insert not set correctly | | ||
| check: query cache not enabled | | | |
| check: table locks too high | | | |
| check: thread cache not enabled | | | |
| check: concurrent queries too high (threshold) | | ||
| check: binary logs not set to auto-purge | | ||
| check: binary logging not enabled | | ||
| check: slave not active if server is set to slave | | | |
| check: slave sql thread stopped | | | |
| check: slave io thread stopped | | | |
| check: slave behind master too long (threshold) | | | |
| check: slave not set as read-only | | ||
| check: slave relay logs not automatically purged | | ||
| check: account has global privs | | | |
| check: account set to old_password | | | |
| check: accounts able to be added with empty password | | ||
| check: account has grant option | | ||
| check: root can login remotely | | | |
| check: root has no password | | | |
| check: blank username detected | | | |
| check: test database exists | | | |
| check: usage user exists | | ||
| check: general query log enabled | | ||
| check: CPU usage over threshold | | | |
check: innodb_flush_method setting ideal for data storage medium | coming soon | ||
| check: Load Average over threshold | | |
* Competitor’s feature list items are based on data from MySQL and MonYog company websites at the time of this page creation.
donate to the cause]
