FromDual Performance Monitor for MySQL and MariaDB 0.10.1 has been released

FromDual has the pleasure to announce the release of the new version 0.10.1 of its popular Database Performance Monitor for MySQL, MariaDB, Galera Cluster and Percona Server fpmmm.

You can download fpmmm from here.

In the inconceivable case that you find a bug in fpmmm please report it to our Bug-tracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

This release contains various minor bug fixes and improvements. Mainly it was a rewrite from Perl into PHP.

New installation of fpmmm v0.10.1

Please follow our mpm installation guide. A specific fpmmm installation guide will follow with the next version.

Prerequisites

CentOS 6

# yum install php-cli php-process php-mysqli

# cat << _EOF >/etc/php.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

rpm -Uvh http://repo.zabbix.com/zabbix/2.2/rhel/6/x86_64/zabbix-release-2.2-1.el6.noarch.rpm
yum update
yum install zabbix-sender

CentOS 7

# yum install php-cli php-process php-mysqli

# cat << _EOF >/etc/php.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

rpm -Uvh http://repo.zabbix.com/zabbix/2.2/rhel/7/x86_64/zabbix-release-2.2-1.el7.noarch.rpm
yum update
yum install zabbix-sender

Ubuntu 14.04

# apt-get install php5-cli php5-mysqlnd

# cat << _EOF >/etc/php5/cli/conf.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

apt-get install zabbix-agent

OpenSuSE 13.1

# zypper install php5 php5-posix php5-mysql php5-pcntl php5-curl

#cat << _EOF >/etc/php5/conf.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

zypper addrepo http://download.opensuse.org/repositories/server:/monitoring/openSUSE_13.1 server_monitoring
zypper update
zypper install zabbix-agent

Upgrade from mpm 0.x to fpmmm 0.10.1

# cd /opt
# tar xf /download/fpmmm-0.10.1.tar.gz
# rm -f fpmmm
# ln -s fpmmm-0.10.1 fpmmm

You further have to replace all mysql_performance_monitor_agent.pl hooks (in Zabbix agent) by bin/fpmmm.

Changes in fpmmm v0.10.1

fpmmm agent

• Defaults in fpmmm.conf.template adapted.
• Item sending prepared for empty strings.
• Log of cachedData more verbose.
• zabbix_sender stuff fixed and made more robust.
• New naming convention fpmmm implemented.
• Connection problems and error catching fixed.
• NDB cluster and PBXT stuff removed and locking made more robust.
• zabbix-sender on SuSE should work now as well. Bug #149.
• exec/system replaced by my_exec.
• Debug parameter replaced by LogLevel parameter, including all templates and warning for deprecation.
• export LC_ALL=C added to all O/S calls to make it language independent.
• Usage added (--help).
• All Perl code replaced by PHP code.
• Bug fix on cache clean-up on corruption.
• Mac OSX (darwin) support added, partially.
• Changed defaults away from /tmp This is no good location for persistent things because of RedHat tmpcleaner job.
• Debugging info added for missing lock file.

fpmmm agent and MaaS

• none.

Various modules

• Regexp pattern fixed for mr_versions.

MySQL module

• Trailing / from datadir is removed.

InnoDB module

• Innodb buffer pool hit ratio rounded to 2 digits.
• Innodb_os_log_written item added.
• InnoDB hash searches item fixed.

Galera module

• Galera status now gathered with causal reads off.

Memcached module

• Memcached stuff activated.

DRBD module

• Bug report on new DRBD fixed.

fpmmm templates for Zabbix

• Security template data typo fixed.
• Templates moved from xml folder to tpl folder and other file structure and renaming.
• InnoDB Flush Log at Transaction Commit Serverity lowered from Warning to Information.

For subscriptions of commercial use of fpmmm please get in contact with us.