FromDual InfoFeed (en)

The FOSDEM 2016 in Brussels (Belgium) January 29/30 is over and was very interesting and IMHO a big success.

For all those who could not participate at FOSDEM 2016 our presentation slides about PERFORMANCE_SCHEMA and sys schema are available here:

PERFORMANCE_SCHEMA and sys schema - What can we do with it? (PDF, 406 kbyte)

Taxonomy upgrade extras: sysperformance_schemaslides

FromDual has the pleasure to announce the release of the new version 0.3 of the FromDual Ops Center for MySQL and MariaDB.

The FromDual Ops Center for MySQL and MariaDB (focmm) is an application for DBA's and system administrators to manage MySQL and MariaDB database farms.

The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks.

More information about FromDual Ops Center you can find here.

Download

The new FromDual Ops Center can be downloaded here.

In the inconceivable case that you find a bug in the FromDual Ops Center please report it to our bug tracker.

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

Installation of Ops Center

A complete guide on how to install FromDual Ops Center you can find in the Ops Center User Guide.

Upgrade from 0.2 to 0.3

An upgrade path from Ops-Center v0.2 to v0.3 is currently not supported. Please also check Upgrading.

Changes in Ops Center 0.3

• Ops Center repository database was changed from Sqlite to MySQL/MariaDB.
• Structure and schema comparison introduced.
• Variables comparison introduced.
• Processlist tool introduced.
• VIP is checked over crontab now.
• Debugging facility improved.
• Some configuration rules/checks implemented.
• User management implemented for multiple-instances.
• Clone user implemented.
• Database backup implemented.
• Jab handling implemented.
• Blocking backup implemented for MyISAM tables.
• Skip Slave with GTID works now.

Taxonomy upgrade extras: OperationsreleaseBackupfailoverfocmmFromDual Ops Center

FromDual has the pleasure to announce the release of the new version 0.3 of the FromDual Ops Center for MySQL and MariaDB.

The FromDual Ops Center for MySQL and MariaDB (focmm) is an application for DBA's and system administrators to manage MySQL and MariaDB database farms.

The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks.

More information about FromDual Ops Center you can find here.

Download

The new FromDual Ops Center can be downloaded here.

In the inconceivable case that you find a bug in the FromDual Ops Center please report it to our bug tracker.

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

Installation of Ops Center

A complete guide on how to install FromDual Ops Center you can find in the Ops Center User Guide.

Upgrade from 0.2 to 0.3

An upgrade path from Ops-Center v0.2 to v0.3 is currently not supported. Please also check Upgrading.

Changes in Ops Center 0.3

• Ops Center repository database was changed from Sqlite to MySQL/MariaDB.
• Structure and schema comparison introduced.
• Variables comparison introduced.
• Processlist tool introduced.
• VIP is checked over crontab now.
• Debugging facility improved.
• Some configuration rules/checks implemented.
• User management implemented for multiple-instances.
• Clone user implemented.
• Database backup implemented.
• Jab handling implemented.
• Blocking backup implemented for MyISAM tables.
• Skip Slave with GTID works now.

Taxonomy upgrade extras: operationOperationsreleaseBackupfailover

FromDual has the pleasure to announce the release of the new version 0.3 of the FromDual Ops Center for MySQL and MariaDB.

The FromDual Ops Center for MySQL and MariaDB (focmm) is an application for DBA's and system administrators to manage MySQL and MariaDB database farms.

The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks.

More information about FromDual Ops Center you can find here.

Download

The new FromDual Ops Center can be downloaded here.

In the inconceivable case that you find a bug in the FromDual Ops Center please report it to our bug tracker.

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

Installation of Ops Center

A complete guide on how to install FromDual Ops Center you can find in the Ops Center User Guide.

Upgrade from 0.2 to 0.3

An upgrade path from Ops-Center v0.2 to v0.3 is currently not supported. Please also check Upgrading.

Changes in Ops Center 0.3

• Ops Center repository database was changed from Sqlite to MySQL/MariaDB.
• Structure and schema comparison introduced.
• Variables comparison introduced.
• Processlist tool introduced.
• VIP is checked over crontab now.
• Debugging facility improved.
• Some configuration rules/checks implemented.
• User management implemented for multiple-instances.
• Clone user implemented.
• Database backup implemented.
• Jab handling implemented.
• Blocking backup implemented for MyISAM tables.
• Skip Slave with GTID works now.

Taxonomy upgrade extras: operationOperationsreleaseBackupfailover

FromDual has the pleasure to announce the release of the new version 1.3.0 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x or higher to 1.3.0 # cd ${HOME}/product # tar xf /download/myenv-1.3.0.tar.gz # rm -f myenv # ln -s myenv-1.3.0 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.3.0 MyEnv

• NDB Cluster stuff was removed and cleaned-up.
• my.cnf template was slightly adapted to new requirements (query_cache_size, innodb_buffer_pool_instances, binlog_stmt_cache_size, wsrep_sst_method and wsrep_sst_auth).
• Cgroups stuff was fixed and made more verbose in case of configuration errors.
• Cgroups template (tpl/cgroups.conf) was extended.
• Some warnings made more clear.
• Too verbose error message in case of missing my.cnf was redirected to debug logging.

MyEnv Installer

• Preparation work for Mac OSX was done.
• Installation deletion can be automatized now.
• Installer made ready for 5.7
• Tags angel and default are not attached to each section any more.
• Schema sys was added to hideschema variable

MyEnv Utilities

• Script insert_test.sh host tag added.
• ORDER BY added to GROUP BY (in query_bench.php) to make it working the same in the future.
• rc bug fixed in block_galera_node.sh

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

Taxonomy upgrade extras: MyEnvoperationMySQL Operationsmulti instanceconsolidationtestingreleasecloudcgroupscontainer

FromDual has the pleasure to announce the release of the new version 1.3.0 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x or higher to 1.3.0 # cd ${HOME}/product # tar xf /download/myenv-1.3.0.tar.gz # rm -f myenv # ln -s myenv-1.3.0 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.3.0 MyEnv

• NDB Cluster stuff was removed and cleaned-up.
• my.cnf template was slightly adapted to new requirements (query_cache_size, innodb_buffer_pool_instances, binlog_stmt_cache_size, wsrep_sst_method and wsrep_sst_auth).
• Cgroups stuff was fixed and made more verbose in case of configuration errors.
• Cgroups template (tpl/cgroups.conf) was extended.
• Some warnings made more clear.
• Too verbose error message in case of missing my.cnf was redirected to debug logging.

MyEnv Installer

• Preparation work for Mac OSX was done.
• Installation deletion can be automatized now.
• Installer made ready for 5.7
• Tags angel and default are not attached to each section any more.
• Schema sys was added to hideschema variable

MyEnv Utilities

• Script insert_test.sh host tag added.
• ORDER BY added to GROUP BY (in query_bench.php) to make it working the same in the future.
• rc bug fixed in block_galera_node.sh

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

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgradereleasecloudcgroupscontainer

FromDual has the pleasure to announce the release of the new version 1.3.0 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x or higher to 1.3.0 # cd ${HOME}/product # tar xf /download/myenv-1.3.0.tar.gz # rm -f myenv # ln -s myenv-1.3.0 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.3.0 MyEnv

• NDB Cluster stuff was removed and cleaned-up.
• my.cnf template was slightly adapted to new requirements (query_cache_size, innodb_buffer_pool_instances, binlog_stmt_cache_size, wsrep_sst_method and wsrep_sst_auth).
• Cgroups stuff was fixed and made more verbose in case of configuration errors.
• Cgroups template (tpl/cgroups.conf) was extended.
• Some warnings made more clear.
• Too verbose error message in case of missing my.cnf was redirected to debug logging.

MyEnv Installer

• Preparation work for Mac OSX was done.
• Installation deletion can be automatized now.
• Installer made ready for 5.7
• Tags angel and default are not attached to each section any more.
• Schema sys was added to hideschema variable

MyEnv Utilities

• Script insert_test.sh host tag added.
• ORDER BY added to GROUP BY (in query_bench.php) to make it working the same in the future.
• rc bug fixed in block_galera_node.sh

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

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgradereleasecloudcgroupscontainer

FromDual has the pleasure to announce the release of the new version 1.2.2 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.2 # cd ${HOME}/product # tar xf /download/myenv-1.2.2.tar.gz # rm -f myenv # ln -s myenv-1.2.2 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.2 MyEnv

• IP addresses are shown in up.
• All values from [default] section should be inherited to [dbname] section.
• Configuration file parser made more robust.
• Empty my.cnf is caught correctly now.

MyEnv Installer

• Mac OSX findings fixed in installer.
• Fixed suppressed mysql_install_db error output problem.
• Missing libaio library is found in installer now.
• Check for missing /var/run/mysqld directory added.
• Installation script mysql_install_db is called with --no-defaults now to avoid interference with other configuration files.

MyEnv Utilities

• Script log_maintenance.php will not abort when having a problem with one log file but continue.
• Help examples and template improved for log_maintenance.php.
• Function check for mb_strlen added for log_maintenance.php.
• Script option --truncate with too many lines leads to out of memory and takes ages. Fixed this by limiting lines to 10000 in log_maintenance.php.
• But in drop_partition.php was fixed.

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

Taxonomy upgrade extras: MyEnvoperationMySQL Operationsmulti instanceconsolidationtestingrelease

FromDual has the pleasure to announce the release of the new version 1.2.2 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.2 # cd ${HOME}/product # tar xf /download/myenv-1.2.2.tar.gz # rm -f myenv # ln -s myenv-1.2.2 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.2 MyEnv

• IP addresses are shown in up.
• All values from [default] section should be inherited to [dbname] section.
• Configuration file parser made more robust.
• Empty my.cnf is caught correctly now.

MyEnv Installer

• Mac OSX findings fixed in installer.
• Fixed suppressed mysql_install_db error output problem.
• Missing libaio library is found in installer now.
• Check for missing /var/run/mysqld directory added.
• Installation script mysql_install_db is called with --no-defaults now to avoid interference with other configuration files.

MyEnv Utilities

• Script log_maintenance.php will not abort when having a problem with one log file but continue.
• Help examples and template improved for log_maintenance.php.
• Function check for mb_strlen added for log_maintenance.php.
• Script option --truncate with too many lines leads to out of memory and takes ages. Fixed this by limiting lines to 10000 in log_maintenance.php.
• But in drop_partition.php was fixed.

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

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgraderelease

FromDual has the pleasure to announce the release of the new version 1.2.2 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.2 # cd ${HOME}/product # tar xf /download/myenv-1.2.2.tar.gz # rm -f myenv # ln -s myenv-1.2.2 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.2 MyEnv

• IP addresses are shown in up.
• All values from [default] section should be inherited to [dbname] section.
• Configuration file parser made more robust.
• Empty my.cnf is caught correctly now.

MyEnv Installer

• Mac OSX findings fixed in installer.
• Fixed suppressed mysql_install_db error output problem.
• Missing libaio library is found in installer now.
• Check for missing /var/run/mysqld directory added.
• Installation script mysql_install_db is called with --no-defaults now to avoid interference with other configuration files.

MyEnv Utilities

• Skript log_maintenance.php will not abort when having a problem with one log file but continue.
• Help examples and template improved for log_maintenance.php.
• Function check for mb_strlen added for log_maintenance.php.
• Skript option --truncate with too many lines leads to out of memory and takes ages. Fixed this by limiting lines to 10000 in log_maintenance.php.
• But in drop_partition.php was fixed.

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

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgrade

FromDual has the pleasure to announce the release of the new version 0.10.5 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 bug fixes and improvements. The previous release had some major bugs so we recommend to upgrade...

New installation of fpmmm v0.10.5

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 php5-curl # 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 fpmmm 0.10.x to fpmmm 0.10.5 # cd /opt # tar xf /download/fpmmm-0.10.5.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.5 fpmmm

The following templates in your Zabbix monitor should be replaced. Before you replace the templates it is a good idea to first delete all triggers...

• tpl/Template_FromDual.MySQL.fpmmm.xml
• tpl/Template_FromDual.MySQL.innodb.xml
• tpl/Template_FromDual.MySQL.master.xml
• tpl/Template_FromDual.MySQL.myisam.xml
• tpl/Template_FromDual.MySQL.mysql.xml
• tpl/Template_FromDual.MySQL.server.xml
• tpl/Template_FromDual.MySQL.slave.xml

Changes in fpmmm v0.10.5 fpmmm agent

• Better and more verbose error handling in various modules.
• Directory for log file is created automatically if it does not exist yet.
• All broken SQL queries (from 0.10.4) fixed again.
• Add delay for not so frequent changing data.
• Several triggers which complained after restart are fixed now.
• Connections to database were now reduced to the minimum.
• Links for templates fixed.
• Innodb_flush_log_at_trx_commit, log_queries_not_using_indexes and character_set_server triggers disabled by default.
• Also sendCachedData is now checked for too big cache file. Bug from swd.

Slave module

• Slave error messages are caught and sent to the monitor.
• Warning is written to the log file if slave module is configured without being a slave.
• New slave status is reported correctly now.
• Seconds_behind_master is now only sent when running.

Master module

• New trigger for binlog_format = MIXED and replication filtering added.
• Severity increased on STATEMENT based filtering added.
• Regexp bug fixed.
• Master without binary log fixed.

MySQL module

• Old broken triggers fixed.

Server module

• IOPS graph added.
• Device sda5 removed.
• I/O statistics calculation improved.
• I/O r/w wait experimental items implemented.
• CPU count added.
• NUMA and virtualization information added.

InnoDB module

• innodb_flush_method item added.
• Trigger for innodb_flush_method added.
• innodb_force_recovery trigger severity increased.
• innodb_log_files_in_group item added for log traffic threshold.
• InnoDB transaction log traffic trigger and graph added.

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

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitormpmrelease

FromDual has the pleasure to announce the release of the new version 0.10.5 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 bug fixes and improvements. The previous release had some major bugs so we recommend to upgrade...

New installation of fpmmm v0.10.5

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 php5-curl # 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 fpmmm 0.10.x to fpmmm 0.10.5 # cd /opt # tar xf /download/fpmmm-0.10.5.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.5 fpmmm

The following templates in your Zabbix monitor should be replaced. Before you replace the templates it is a good idea to first delete all triggers...

• tpl/Template_FromDual.MySQL.fpmmm.xml
• tpl/Template_FromDual.MySQL.innodb.xml
• tpl/Template_FromDual.MySQL.master.xml
• tpl/Template_FromDual.MySQL.myisam.xml
• tpl/Template_FromDual.MySQL.mysql.xml
• tpl/Template_FromDual.MySQL.server.xml
• tpl/Template_FromDual.MySQL.slave.xml

Changes in fpmmm v0.10.5 fpmmm agent

• Better and more verbose error handling in various modules.
• Directory for log file is created automatically if it does not exist yet.
• All broken SQL queries (from 0.10.4) fixed again.
• Add delay for not so frequent changing data.
• Several triggers which complained after restart are fixed now.
• Connections to database were now reduced to the minimum.
• Links for templates fixed.
• Innodb_flush_log_at_trx_commit, log_queries_not_using_indexes and character_set_server triggers disabled by default.
• Also sendCachedData is now checked for too big cache file. Bug from swd.

Slave module

• Slave error messages are caught and sent to the monitor.
• Warning is written to the log file if slave module is configured without being a slave.
• New slave status is reported correctly now.
• Seconds_behind_master is now only sent when running.

Master module

• New trigger for binlog_format = MIXED and replication filtering added.
• Severity increased on STATEMENT based filtering added.
• Regexp bug fixed.
• Master without binary log fixed.

MySQL module

• Old broken triggers fixed.

Server module

• IOPS graph added.
• Device sda5 removed.
• I/O statistics calculation improved.
• I/O r/w wait experimental items implemented.
• CPU count added.
• NUMA and virtualization information added.

InnoDB module

• innodb_flush_method item added.
• Trigger for innodb_flush_method added.
• innodb_force_recovery trigger severity increased.
• innodb_log_files_in_group item added for log traffic threshold.
• InnoDB transaction log traffic trigger and graph added.

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

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitormpmrelease

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitormpm

FromDual has the pleasure to announce the release of the new version 0.10.5 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 bug fixes and improvements. The previous release had some major bugs so we recommend to upgrade...

New installation of fpmmm v0.10.5

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 php5-curl # 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 fpmmm 0.10.x to fpmmm 0.10.5 # cd /opt # tar xf /download/fpmmm-0.10.5.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.5 fpmmm

The following templates in your Zabbix monitor should be replaced. Before you replace the templates it is a good idea to first delete all triggers...

• tpl/Template_FromDual.MySQL.fpmmm.xml
• tpl/Template_FromDual.MySQL.innodb.xml
• tpl/Template_FromDual.MySQL.master.xml
• tpl/Template_FromDual.MySQL.myisam.xml
• tpl/Template_FromDual.MySQL.mysql.xml
• tpl/Template_FromDual.MySQL.server.xml
• tpl/Template_FromDual.MySQL.slave.xml

Changes in fpmmm v0.10.5 fpmmm agent

• Better and more verbose error handling in various modules.
• Directory for log file is created automatically if it does not exist yet.
• All broken SQL queries (from 0.10.4) fixed again.
• Add delay for not so frequent changing data.
• Several triggers which complained after restart are fixed now.
• Connections to database were now reduced to the minimum.
• Links for templates fixed.
• Innodb_flush_log_at_trx_commit, log_queries_not_using_indexes and character_set_server triggers disabled by default.
• Also sendCachedData is now checked for too big cache file. Bug from swd.

Slave module

• Slave error messages are caught and sent to the monitor.
• Warning is written to the log file if slave module is configured without being a slave.
• New slave status is reported correctly now.
• Seconds_behind_master is now only sent when running.

Master module

• New trigger for binlog_format = MIXED and replication filtering added.
• Severity increased on STATEMENT based filtering added.
• Regexp bug fixed.
• Master without binary log fixed.

MySQL module

• Old broken triggers fixed.

Server module

• IOPS graph added.
• Device sda5 removed.
• I/O statistics calculation improved.
• I/O r/w wait experimental items implemented.
• CPU count added.
• NUMA and virtualization information added.

InnoDB module

• innodb_flush_method item added.
• Trigger for innodb_flush_method added.
• innodb_force_recovery trigger severity increased.
• innodb_log_files_in_group item added for log traffic threshold.
• InnoDB transaction log traffic trigger and graph added.

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

FromDual has the pleasure to announce the release of the new version 1.2.1 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.1 # cd ${HOME}/product # tar xf /download/myenv-1.2.1.tar.gz # rm -f myenv # ln -s myenv-1.2.1 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.1 MyEnv

• Bug in myenv.server fixed (chmod user:).
• Distribution check for CentOS 7.1 fixed (bug report Jörg).
• Directory /var/run/mysqld is created by myenv.server
• Missing function output added.
• Output changes unified, execute with LC_ALL=C made language independent.

MyEnv Installer

• Template my.cnf extended by hostname and instance name.
• Skip in init script implemented, (bug report Jörg).
• MyEnv my.cnf.template merged with website.
• Template AUTO_INCREMENT values fixed.
• Galera Cluster variable causal read in my.cnf template updated.
• Functions separated into own library.
• All templates moved from etc to tpl.
• my.cnf template provided with hostname tag.

MyEnv Utilities

• Skript alter_engine.php now supports socket.
• Check in alter_engine.php for Primary Key length of 767 bytes was removed because it was wrong.
• Skript decrypt_mylogin_cnf.php added.
• Script log_maintenance.php added.
• Usage and --help added to block_galera_node.sh.

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

Taxonomy upgrade extras: MyEnvoperationMySQL Operationsmulti instanceconsolidationtestingrelease

FromDual has the pleasure to announce the release of the new version 1.2.1 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.1 # cd ${HOME}/product # tar xf /download/myenv-1.2.1.tar.gz # rm -f myenv # ln -s myenv-1.2.1 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.1 MyEnv

• Bug in myenv.server fixed (chmod user:).
• Distribution check for CentOS 7.1 fixed (bug report Jörg).
• Directory /var/run/mysqld is created by myenv.server
• Missing function output added.
• Output changes unified, execute with LC_ALL=C made language independent.

MyEnv Installer

• Template my.cnf extended by hostname and instance name.
• Skip in init script implemented, (bug report Jörg).
• MyEnv my.cnf.template merged with website.
• Template AUTO_INCREMENT values fixed.
• Galera Cluster variable causal read in my.cnf template updated.
• Functions separated into own library.
• All templates moved from etc to tpl.
• my.cnf template provided with hostname tag.

MyEnv Utilities

• Skript alter_engine.php now supports socket.
• Check in alter_engine.php for Primary Key length of 767 bytes was removed because it was wrong.
• Skript decrypt_mylogin_cnf.php added.
• Script log_maintenance.php added.
• Usage and --help added to block_galera_node.sh.

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

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgraderelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationtestingupgrade

FromDual has the pleasure to announce the release of the new version 1.2.1 of its popular MySQL, Galera Cluster, MariaDB and Percona Server multi-instance environment MyEnv.

The new MyEnv can be downloaded here.

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

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

Upgrade from 1.1.x to 1.2.1 # cd ${HOME}/product # tar xf /download/myenv-1.2.1.tar.gz # rm -f myenv # ln -s myenv-1.2.1 myenv

If you are using plug-ins for showMyEnvStatus create all the links in the new directory structure:

cd ${HOME}/product/myenv ln -s ../../utl/oem_agent.php plg/showMyEnvStatus/
Changes in MyEnv 1.2.1 MyEnv

• Bug in myenv.server fixed (chmod user:).
• Distribution check for CentOS 7.1 fixed (bug report Jörg).
• Directory /var/run/mysqld is created by myenv.server
• Missing function output added.
• Output changes unified, execute with LC_ALL=C made language independent.

MyEnv Installer

• Template my.cnf extended by hostname and instance name.
• Skip in init script implemented, (bug report Jörg).
• MyEnv my.cnf.template merged with website.
• Template AUTO_INCREMENT values fixed.
• Galera Cluster variable causal read in my.cnf template updated.
• Functions separated into own library.
• All templates moved from etc to tpl.
• my.cnf template provided with hostname tag.

MyEnv Utilities

• Skript alter_engine.php now supports socket.
• Check in alter_engine.php for Primary Key length of 767 bytes was removed because it was wrong.
• Skript decrypt_mylogin_cnf.php added.
• Script log_maintenance.php added.
• Usage and --help added to block_galera_node.sh.

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

FromDual has the pleasure to announce the release of the new version 0.10.4 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.

New installation of fpmmm v0.10.4

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 php5-curl # 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 fpmmm 0.10.x to fpmmm 0.10.4 # cd /opt # tar xf /download/fpmmm-0.10.4.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.4 fpmmm
Changes in fpmmm v0.10.4 Security module

• Privilege problem in security module caught and error message written.

Changes in fpmmm v0.10.3 fpmmm agent

• preg_replace error fixed (FromDualMySQLagent.inc).

Master module

• Bug in master module fixed.

InnoDB module

• Deadlock and foreign key error files move from /tmp to cacheBase.
• Deadlock and foreign key error catching fixed (bug #162).

Changes in fpmmm v0.10.2 fpmmm agent

• fpmmm version check added in template.
• fpmmm templates upgrade to Zabbix version 2.0.9. This means, they do not work with Zabix 1.8 any more!
• zabbix_sender return code 0 caught correctly now.
• Minor bug fixes and typos fixed.
• Bug in caching data fixed.

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

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitorrelease

FromDual has the pleasure to announce the release of the new version 0.10.4 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.

New installation of fpmmm v0.10.4

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 php5-curl # 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 fpmmm 0.10.x to fpmmm 0.10.4 # cd /opt # tar xf /download/fpmmm-0.10.4.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.4 fpmmm
Changes in fpmmm v0.10.4 Security module

• Privilege problem in security module caught and error message written.

Changes in fpmmm v0.10.3 fpmmm agent

• preg_replace error fixed (FromDualMySQLagent.inc).

Master module

• Bug in master module fixed.

InnoDB module

• Deadlock and foreign key error files move from /tmp to cacheBase.
• Deadlock and foreign key error catching fixed (bug #162).

Changes in fpmmm v0.10.2 fpmmm agent

• fpmmm version check added in template.
• fpmmm templates upgrade to Zabbix version 2.0.9. This means, they do not work with Zabix 1.8 any more!
• zabbix_sender return code 0 caught correctly now.
• Minor bug fixes and typos fixed.
• Bug in caching data fixed.

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

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitorrelease

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitormpm

FromDual has the pleasure to announce the release of the new version 0.10.4 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.

New installation of fpmmm v0.10.4

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 fpmmm 0.10.x to fpmmm 0.10.4 # cd /opt # tar xf /download/fpmmm-0.10.4.tar.gz # rm -f fpmmm # ln -s fpmmm-0.10.4 fpmmm
Changes in fpmmm v0.10.4 Security module

• Privilege problem in security module caught and error message written.

Changes in fpmmm v0.10.3 fpmmm agent

• preg_replace error fixed (FromDualMySQLagent.inc).

Master module

• Bug in master module fixed.

InnoDB module

• Deadlock and foreign key error files move from /tmp to cacheBase.
• Deadlock and foreign key error catching fixed (bug #162).

Changes in fpmmm v0.10.2 fpmmm agent

• fpmmm version check added in template.
• fpmmm templates upgrade to Zabbix version 2.0.9. This means, they do not work with Zabix 1.8 any more!
• zabbix_sender return code 0 caught correctly now.
• Minor bug fixes and typos fixed.
• Bug in caching data fixed.

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

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.

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitorrelease