FromDual InfoFeed (en)

On January 9th FromDual launched its Monitoring as a Service (MaaS) solution for MySQL.
This service is based on the Performance Monitor for MySQL (mpm) v0.8 and Zabbix.

The installation on customer side of the so called monitoring agent takes about 5 minutes (for installation, configuration and scheduling).

The collected performance data are sent to our service where you can view them with your web browser. Some examples you can find here.

You can download the Performance Monitor for MySQL from our download page.

To use this service a key is needed which will be provided by FromDual. To request a key please use this form.

This service is free for FromDual support and consulting customers. For all others we offer a special enterprise customer monitoring subscription.

More information about MySQL Monitoring as a Service you can find here.

You can follow discussion about the MaaS on our forum.

InnoDB and NDB module are now under GPL!

Further we have the pleasure to announce that now all modules are available under GPL. Before the InnoDB and the NDB (MySQL Cluster) module were available for FromDual customers only.

For commercial use of the FromDual Performance Monitor an Enterprise subscription is required.

The changes in the new FromDual Performance Monitor release v0.8 are:

New functionality

• Monitoring as a Service (MaaS) functionality was added to the FromDual Performance Monitor for MySQL.

Changed functionality

• The InnoDB and NDB module are now available under GPL.
• Agent lock was implemented. Only one agent can run per server now at a time. This is to prevent a system overload because of some locks or timeouts etc.
• Agent log is now touched on every call. From the timestamp it is visible now when the agent was running last.
• Cache file is now per server/device.
• Data are mostly cached in the cache file first instead of calling zabbix_sender zillions of times.
• Zabbix server port is now configurable.
• Foreign Key Error detection for InnoDB was implemented.
• Deadlock detection for InnoDB was implemented.
• XtraDB and InnoDB agents/templates were merged. There is now no more difference between GPL and commercial builds.

Fixes

• ndb_cluster_connection_pool is now reported correctly and according trigger works correctly again.
• Some templates where improved.
• Missing item to MyISAM template added.
• Missing item to Process template added.
• Fix in the mysql module (sql_mode).
• Fix in the master template (adding 20 missing items for binary log events).

If you want to stay tuned to our information, follow our Tweets on Twitter. If you like this service please let us know.

We would love to hear about your feedback.

Best Regards,

Your FromDual Team

On December 2nd 2011 FromDual released the new version v0.7.2 of its Performance Monitor for MySQL. The new version can be downloaded from here.

The Performance Monitor for MySQL is an agent which is hooked into the agent of the well known Monitoring solution called Zabbix. Zabbix is an integrated Enterprise Monitoring solution which can produce performance graphs and alerting.

The changes in the new release are:

New functionality

• A new module for Galera was added (mainly Galera 0.8).
• A new module for the MySQL Performance Monitor (mpm) was added.
• Information about InnoDB Row Locking was added (status and graph).
• Some MySQL variables were added for monitoring (customer request).
• Triggers for some of those MySQL variables are implemented (customer request).

Changed functionality

• MPM agent hook (FromDual.MySQL.check) was moved from the mysql module to the mpm module. To call the MPM agent you have to run the mpm module only once per monitored server (computer).
• Path to the MPM agent libraries is not hard coded anymore but follows $basedir/lib now. The MPM can now be located anywhere... (customer request)
• The MPM cache file is now configurable.
• The MPM agent is prepared for Deadlock and Foreign Key Error detection (customer request).
• Name collision in the server module fixed (customer bug report).
• Old style basename code replace by new Perl style.

Fixes

• Security fix in the MPM agent (password is no longer displayed in the log file).
• Some fixes in different XML templates.
• Some fixes in the ndb, memcached, aria, drbd and server module.
• Some fixes in the MPM agent.