Fun With MySQL: Performance Monitor for MySQL?

Performance Monitor for MySQL?

The FromDual Performance Monitor (mpm) for MySQL, Galera Cluster/MySQL, Percona Server and MariaDB is a Monitoring Solution based on the Enterprise open source Monitor Zabbix.
It provides all the necessary modules to monitor MySQL performance metrics in detail an let you display them graphically.

Thus it is a good alternative to the MySQL Enterprise Monitor which is only available for paying Oracle/MySQL customers.

For more details see also our presentation at the OpenSQL Camp / FrOSCon 2010.
To stay tuned about the progress of the MySQL Performance Monitor follow us on Twitter.
We currently provide the following modules:

Aria (ex. Maria SE)
DRBD
Galera
MPM FromDual Performance Monitor itself
InnoDB and XtraDB
Memcached (will come soon)
MyISAM
MySQL (everything NOT storage engine specific)
MySQL Replication
NDB (MySQL Cluster)
PBXT
Process (Information about the database process itself)
Server (for additional server metrics)
Sphinx SE (will come soon)

Further modules are available on request...

Prerequisites

On the Server where you want to install your monitoring service you need PHP, Apache and a database back-end (MySQL, PostgreSQL, Oracle or SQLite) installed.
Further you need a compile server to compile the Zabbix software.
On the Servers where you have your MySQL databases installed you need Perl and DBD::MySQL installed.

Download and Install

The most recent FromDual Performance Monitor for MySQL you can download from here...
This installation documentation should guide you through the installation process. It does NOT cover the installation of Zabbix. For installing Zabbix go through this installation guidelines first.
For more information and discussions about the mpm go to our Forum.

Considerations

Be careful using this Monitoring Software on production systems. We are not aware of any problem but its impact on MySQL databases is not know very well yet. Try it on testing systems first before using it in production.

Enterprise subscription and Support

For commercial use you have to purchase an Enterprise Subscription for the FromDual Performance Monitor. This subscription includes:

Notice of available updates for all modules.
Access to newest Releases of the MySQL Performance Monitor.
Best effort email support for all the FromDual modules. Contact our contact for getting support.
Opportunity to suggest enhancement requests.

The Enterprise subscription can be purchased here. This support does NOT contain Zabbix Support! Commercial support for Zabbix you can get from Zabbix directly.
If the installation of the MySQL Performance Monitor is part of a consulting engagement, the support for the first year is free.