You are here

Performance Monitor for MariaDB and MySQL (fpmmm)

Table of Contents


What is the FromDual Performance Monitor for MariaDB and MySQL (fpmmm)?

The FromDual Performance Monitor (fpmmm) for MariaDB, Galera Cluster, MySQL and Percona Server is a monitoring solution based on the enterprise class open source monitor Zabbix.

It provides all the necessary modules to monitor your MySQL/MariaDB 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.

Available modules

We currently provide the following modules:

  • Aria
  • Data (user data)
  • DRBD
  • fpmmm FromDual Performance Monitor for MariaDB and MySQL itself
  • Galera Cluster
  • MariaDB InnoDB and MySQL InnoDB
  • Master (everything master related)
  • Memcached
  • MyISAM
  • MySQL (everything NOT storage engine specific)
  • Process (Information about the database process itself)
  • Security (related information)
  • Server (additional server metrics)
  • Slave (everything Replication related)
  • Smart (S.M.A.R.T related information)
  • User specific information

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 fpmmm 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.

Monitoring as a Service (MaaS)

If you do not want to take the burden to install the Monitor yourself we offer you Monitoring as a Service.

Examples

Some snapshots...

Dashboard with Slave issues

Dashboard with Slave issues

Triggers acknowledged

Triggers acknowledged

MySQL network activity

MySQL network activity

MySQL statements sent against the server

MySQL statements sent against the server

InnoDB buffer pool and data file activity

InnoDB buffer pool and data file activity