FromDual.en

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

Taxonomy upgrade extras: mysqlperformancemonitormonitoringfpmmmmaasperformance monitormpm

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.

FromDual has the pleasure to announce the release of the new version 1.2.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 to 1.2.0 # cd ${HOME}/product # tar xf /download/myenv-1.2.0.tar.gz # rm -f myenv # ln -s myenv-1.2.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.2.0 MyEnv

• Some minor fixes on init script.
• Introduction of states production, quality, testing and development.
• Colored prompt added for stage production databases.
• All /tmp/*sock moved to /var/run/mysqld.
• up output prepared for bind-address awareness.
• lsb_release dummy implemented.

MyEnv Installer

• Advice for 2 sudo commands in row was wrong.
• Port conflict resolution more verbose.
• Init script replacement check added. Replace init script is distribution aware and auto executable.
• Installer made mode modular and prepared for automatization.
• Installer allows now to run as other user than mysql.
• Bugs in preparing myenv.conf fixed and instance name removed.
• Install routine made more distribution aware.

MyEnv Utilities

• Split partition (split_partition.php) improved.
• Fix of DROP PARTITION (drop_partition.php) was executed in wrong order (new before old).
• Alter Engine script rewritten into PHP (alter_engine.php).
• Alter Engine script handles ROW_FORMAT=FIXED problem correctly now.
• Alter Engine script handles too large Primary Key better.
• Alter Engine script recognizes tables with AUTO_INCREMENT column not at 1st position.
• Purge Binary Log rewritten into PHP (purge_binary_log.php).
• compare_status_files.pl added to compare output of 2 SHOW GLOBAL STATUS.

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.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 to 1.2.0 # cd ${HOME}/product # tar xf /download/myenv-1.2.0.tar.gz # rm -f myenv # ln -s myenv-1.2.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.2.0 MyEnv

• Some minor fixes on init script.
• Introduction of states production, quality, testing and development.
• Colored prompt added for stage production databases.
• All /tmp/*sock moved to /var/run/mysqld.
• up output prepared for bind-address awareness.
• lsb_release dummy implemented.

MyEnv Installer

• Advice for 2 sudo commands in row was wrong.
• Port conflict resolution more verbose.
• Init script replacement check added. Replace init script is distribution aware and auto executable.
• Installer made mode modular and prepared for automatization.
• Installer allows now to run as other user than mysql.
• Bugs in preparing myenv.conf fixed and instance name removed.
• Install routine made more distribution aware.

MyEnv Utilities

• Split partition (split_partition.php) improved.
• Fix of DROP PARTITION (drop_partition.php) was executed in wrong order (new before old).
• Alter Engine script rewritten into PHP (alter_engine.php).
• Alter Engine script handles ROW_FORMAT=FIXED problem correctly now.
• Alter Engine script handles too large Primary Key better.
• Alter Engine script recognizes tables with AUTO_INCREMENT column not at 1st position.
• Purge Binary Log rewritten into PHP (purge_binary_log.php).
• compare_status_files.pl added to compare output of 2 SHOW GLOBAL STATUS.

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.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 to 1.2.0 # cd ${HOME}/product # tar xf /download/myenv-1.2.0.tar.gz # rm -f myenv # ln -s myenv-1.2.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.2.0 MyEnv

• Some minor fixes on init script.
• Introduction of states production, quality, testing and development.
• Colored prompt added for stage production databases.
• All /tmp/*sock moved to /var/run/mysqld.
• up output prepared for bind-address awareness.
• lsb_release dummy implemented.

MyEnv Installer

• Advice for 2 sudo commands in row was wrong.
• Port conflict resolution more verbose.
• Init script replacement check added. Replace init script is distribution aware and auto executable.
• Installer made mode modular and prepared for automatization.
• Installer allows now to run as other user than mysql.
• Bugs in preparing myenv.conf fixed and instance name removed.
• Install routine made more distribution aware.

MyEnv Utilities

• Split partition (split_partition.php) improved.
• Fix of DROP PARTITION (drop_partition.php) was executed in wrong order (new before old).
• Alter Engine script rewritten into PHP (alter_engine.php).
• Alter Engine script handles ROW_FORMAT=FIXED problem correctly now.
• Alter Engine script handles too large Primary Key better.
• Alter Engine script recognizes tables with AUTO_INCREMENT column not at 1st position.
• Purge Binary Log rewritten into PHP (purge_binary_log.php).
• compare_status_files.pl added to compare output of 2 SHOW GLOBAL STATUS.

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

FromDual is pleased to announce the release of a new version 1.0.0 of the Nagios and Icinga plug-ins for MySQL, MariaDB, Percona Server and Galera Cluster.

Any information about the changes and the new functions of the Nagios and Icinga plug-ins you can find here.

If you have any problems with the new version you can reach us by e-mail at: contact@fromdual.com or by phone on +41 44 500 58 20.

Your FromDual Team

Taxonomy upgrade extras: nagiosicingaplug-inmysqlmariadbpercona serverGalera Clusterrelease

FromDual is pleased to announce the release of a new version 1.0.0 of the Nagios and Icinga plug-ins for MySQL, MariaDB, Percona Server and Galera Cluster.

Any information about the changes and the new functions of the Nagios and Icinga plug-ins you can find here.

If you have any problems with the new version you can reach us by e-mail at: contact@fromdual.com or by phone on +41 44 500 58 20.

Your FromDual Team

Taxonomy upgrade extras: nagiosicingaplug-inmysqlmariadbpercona serverGalera Clusterrelease

Taxonomy upgrade extras: nagiosicingaplug-inmysqlmariadbpercona serverGalera Clusterrelease

FromDual is pleased to announce the release of a new version 1.0.0 of the Nagios and Icinga plug-ins for MySQL, MariaDB, Percona Server and Galera Cluster.

Any information about the changes and the new functions of the Nagios and Icinga plug-ins you can find here.

If you have any problems with the new version you can reach us by e-mail at: contact@fromdual.com or by phone on +41 44 940 24 82.

Your FromDual Team

FromDual has the pleasure to announce the release of the new version 1.1.4 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.1.4 # cd ${HOME}/product # tar xf /download/myenv-1.1.4.tar.gz # rm -f myenv # ln -s myenv-1.1.4 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.1.4

Because an ugly but non-dangerous bugs we skipped the announcement of version 1.1.3.

All changes since MyEnv 1.1.2 are listed here. We recommend to skip version 1.1.3

MyEnv

• Error messages are sent to stderr instead of stdout, start error messages are tested after up test.
• Error message if wrong user wants to stop database.
• MyEnv init script slightly improved.
• False positive error message in start fixed.
• Variable parsing in my.cnf made more robust.
• Error messages and warnings made more verbose/clear.
• Bug during stopping database with dummy instance fixed (MGB).
• Cgroups functionality added.
• PHP debug message is now just displayed in debug mode.

MyEnv Installer

• installMyEnv cleans up my.cnf in basedir if it did not exists before to avoid nasty warning message.
• Move [client] and [mysqldump] section to top to not forget them later.
• Bug with empty myenv.conf fixed (KN).
• Install advice for SuSE was wrong for runlevels for MyEnv.
• my.cnf template updated.
• /tmp as location for socket removed because of RedHat tmpcleaner.
• datadir redundancy removed.
• lost+found folder was added to hideschema.
• installMyEnv.sh replaced by installMyEnv.

MyEnv Utilities

• Partitioning tools error output is now written to stderr correctly.
• log_maintenance.sh script contribution added (TS).
• HAproxy check added.
• purge_binary_log.py added.
• insert_test.sh improved.
• lb.monitor skript added.

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.1.4 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.1.4 # cd ${HOME}/product # tar xf /download/myenv-1.1.4.tar.gz # rm -f myenv # ln -s myenv-1.1.4 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.1.4

Because an ugly but non-dangerous bugs we skipped the announcement of version 1.1.3.

All changes since MyEnv 1.1.2 are listed here. We recommend to skip version 1.1.3

MyEnv

• Error messages are sent to stderr instead of stdout, start error messages are tested after up test.
• Error message if wrong user wants to stop database.
• MyEnv init script slightly improved.
• False positive error message in start fixed.
• Variable parsing in my.cnf made more robust.
• Error messages and warnings made more verbose/clear.
• Bug during stopping database with dummy instance fixed (MGB).
• Cgroups functionality added.
• PHP debug message is now just displayed in debug mode.

MyEnv Installer

• installMyEnv cleans up my.cnf in basedir if it did not exists before to avoid nasty warning message.
• Move [client] and [mysqldump] section to top to not forget them later.
• Bug with empty myenv.conf fixed (KN).
• Install advice for SuSE was wrong for runlevels for MyEnv.
• my.cnf template updated.
• /tmp as location for socket removed because of RedHat tmpcleaner.
• datadir redundancy removed.
• lost+found folder was added to hideschema.
• installMyEnv.sh replaced by installMyEnv.

MyEnv Utilities

• Partitioning tools error output is now written to stderr correctly.
• log_maintenance.sh script contribution added (TS).
• HAproxy check added.
• purge_binary_log.py added.
• insert_test.sh improved.
• lb.monitor skript added.

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.1.4 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.1.4 # cd ${HOME}/product # tar xf /download/myenv-1.1.4.tar.gz # rm -f myenv # ln -s myenv-1.1.4 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.1.4

Because an ugly but non-dangerous bugs we skipped the announcement of version 1.1.3.

All changes since MyEnv 1.1.2 are listed here. We recommend to skip version 1.1.3

MyEnv

• Error messages are sent to stderr instead of stdout, start error messages are tested after up test.
• Error message if wrong user wants to stop database.
• MyEnv init script slightly improved.
• False positive error message in start fixed.
• Variable parsing in my.cnf made more robust.
• Error messages and warnings made more verbose/clear.
• Bug during stopping database with dummy instance fixed (MGB).
• Cgroups functionality added.
• PHP debug message is now just displayed in debug mode.

MyEnv Installer

• installMyEnv cleans up my.cnf in basedir if it did not exists before to avoid nasty warning message.
• Move [client] and [mysqldump] section to top to not forget them later.
• Bug with empty myenv.conf fixed (KN).
• Install advice for SuSE was wrong for runlevels for MyEnv.
• my.cnf template updated.
• /tmp as location for socket removed because of RedHat tmpcleaner.
• datadir redundancy removed.
• lost+found folder was added to hideschema.
• installMyEnv.sh replaced by installMyEnv.

MyEnv Utilities

• Partitioning tools error output is now written to stderr correctly.
• log_maintenance.sh script contribution added (TS).
• HAproxy check added.
• purge_binary_log.py added.
• insert_test.sh improved.
• lb.monitor skript added.

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 1.2.1 of the popular Backup and Recovery Manager for MySQL and MariaDB (fromdual_bman).

You can download the FromDual Backup and Recovery Manager from here.

In the inconceivable case that you find a bug in the Backup and Recovery Manager please report it to our Bugtracker.

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

Upgrade from 1.2.0 to 1.2.1 # cd ${HOME}/product # tar xf /download/fromdual_brman-1.2.1.tar.gz # rm -f fromdual_brman # ln -s fromdual_brman-1.2.1 fromdual_brman
Changes in FromDual Backup Manager 1.2.1 FromDual Backup Manager

It contains mainly one very critical bug fix, one bug fix for using FromDual Backup Manger in combination with MariaDB and xtrabackup and several minor bug fixes and small improvements.

We STRONGLY RECOMMEND to upgrade immediately to v1.2.1 if you are using FromDual Backup Manager v1.2.0-RC1 and newer. In these versions errors of mysqldump in combination with the --direct-compress option are not handled correctly and a return code of 0 is returned which can be wrong. This leads to incomplete backups and loss of data during the restore.

You can verify your current FromDual Backup Manager version with the following command:

fromdual_bman --version

• Merges of myEnv.inc with the one of MyEnv.
• Bug with MariaDB using xtrabackup fixed (PM).
• Lock file handling improved.
• Very important: max_allowed_packet bug fixed which was introduced in v1.2.0-RC1.
• Schema names with special characters are now handled properly.
• Log directory is automatically created if it does not exist.
• Error comment for --blocking-backup improved.

Taxonomy upgrade extras: BackupRestoreRecoverypitrfromdual_brmanreleasebrmanbmanrman

FromDual has the pleasure to announce the release of the new version 1.2.1 of the popular Backup and Recovery Manager for MySQL and MariaDB (fromdual_bman).

You can download the FromDual Backup and Recovery Manager from here.

In the inconceivable case that you find a bug in the Backup and Recovery Manager please report it to our Bugtracker.

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

Upgrade from 1.2.0 to 1.2.1 # cd ${HOME}/product # tar xf /download/fromdual_brman-1.2.1.tar.gz # rm -f fromdual_brman # ln -s fromdual_brman-1.2.1 fromdual_brman
Changes in FromDual Backup Manager 1.2.1 FromDual Backup Manager

It contains mainly one very critical bug fix, one bug fix for using FromDual Backup Manger in combination with MariaDB and xtrabackup and several minor bug fixes and small improvements.

We STRONGLY RECOMMEND to upgrade immediately to v1.2.1 if you are using FromDual Backup Manager v1.2.0-RC1 and newer. In these versions errors of mysqldump in combination with the --direct-compress option are not handled correctly and a return code of 0 is returned which can be wrong. This leads to incomplete backups and loss of data during the restore.

You can verify your current FromDual Backup Manager version with the following command:

fromdual_bman --version

• Merges of myEnv.inc with the one of MyEnv.
• Bug with MariaDB using xtrabackup fixed (PM).
• Lock file handling improved.
• Very important: max_allowed_packet bug fixed which was introduced in v1.2.0-RC1.
• Schema names with special characters are now handled properly.
• Log directory is automatically created if it does not exist.
• Error comment for --blocking-backup improved.

Taxonomy upgrade extras: BackupRestoreRecoverypitrfromdual_brmanreleasebrmanbmanrman

Taxonomy upgrade extras: BackupRestoreRecoveryfromdual_brmanmysql_bman

FromDual has the pleasure to announce the release of the new version 1.2.1 of the popular Backup Manager for MySQL and MariaDB (fromdual_bman).

You can download the FromDual Backup Manager from here.

In the inconceivable case that you find a bug in the Backup Manager please report it to our Bugtracker.

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

Upgrade from 1.2.0 to 1.2.1 # cd ${HOME}/product # tar xf /download/fromdual_brman-1.2.1.tar.gz # rm -f fromdual_brman # ln -s fromdual_brman-1.2.1 fromdual_brman
Changes in FromDual Backup Manager 1.2.1 FromDual Backup Manager

It contains mainly one very critical bug fix, one bug fix for using FromDual Backup Manger in combination with MariaDB and xtrabackup and several minor bug fixes and small improvements.

We STRONGLY RECOMMEND to upgrade immediately to v1.2.1 if you are using FromDual Backup Manager v1.2.0-RC1 and newer. In these versions errors of mysqldump in combination with the --direct-compress option are not handled correctly and a return code of 0 is returned which can be wrong. This leads to incomplete backups and loss of data during the restore.

You can verify your current FromDual Backup Manager version with the following command:

fromdual_bman --version

• Merges of myEnv.inc with the one of MyEnv.
• Bug with MariaDB using xtrabackup fixed (PM).
• Lock file handling improved.
• Very important: max_allowed_packet bug fixed which was introduced in v1.2.0-RC1.
• Schema names with special characters are now handled properly.
• Log directory is automatically created if it does not exist.
• Error comment for --blocking-backup improved.

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

You can download MyEnv from here.

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

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

Upgrade from 1.1.1 to 1.1.2 # cd ${HOME}/product # tar xf /download/myenv-1.1.2.tar.gz # rm -f myenv # ln -s myenv-1.1.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.1.2 MyEnv

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.
• OEM Agent is checked now based on process list and not oemagentctl status any more. Makes it much faster.
• Alias cdc for NDB Cluster directory removed. NDB Cluster is not supported any more.
• Deprecate alias v and replace by V.
• Error unlink(/var/lock/subsys/mysql): Permission denied is caught more nicely now.
• Unknown version in up guessing is improved.
• MD5 checksum made portable for Darwin OS (Mac OSX).

MyEnv Installer

• innodb_flush_log_at_trx_commit default in template changed.
• Version guessing improved for installer.
• Better download support for Percona Server and MariaDB added.
• mkdir bug fixed.
• Version check for RedHat made better.
• Check for lsb_release and SELinux/AppArmor check added for faster finding problems during MySQL installation.
• Template my.cnf from website is used for creating an intance.
• Option hideschema is automatically added to the myenv.conf file now.
• Check and warning implemented if non mysql user is used.
• Error is caught when wrong user is used.
• mysql_install_db output made more verbose in case of errors for debugging.
• Default option changes from Add to Save after instance was changed.
• Missing users HOME directory is caught now.
• Question done? can be answered with y now.
• Comment about waiting during instance installation added.

MyEnv Utilities

• Table offline/online scripts integrated into MyEnv utilities.
• alter_engine.pl does hide views from Primary Key check now.

MySQL Backup Manager

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalogrelease

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

You can download MyEnv from here.

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

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

Upgrade from 1.1.1 to 1.1.2 # cd ${HOME}/product # tar xf /download/myenv-1.1.2.tar.gz # rm -f myenv # ln -s myenv-1.1.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.1.2 MyEnv

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.
• OEM Agent is checked now based on process list and not oemagentctl status any more. Makes it much faster.
• Alias cdc for NDB Cluster directory removed. NDB Cluster is not supported any more.
• Deprecate alias v and replace by V.
• Error unlink(/var/lock/subsys/mysql): Permission denied is caught more nicely now.
• Unknown version in up guessing is improved.
• MD5 checksum made portable for Darwin OS (Mac OSX).

MyEnv Installer

• innodb_flush_log_at_trx_commit default in template changed.
• Version guessing improved for installer.
• Better download support for Percona Server and MariaDB added.
• mkdir bug fixed.
• Version check for RedHat made better.
• Check for lsb_release and SELinux/AppArmor check added for faster finding problems during MySQL installation.
• Template my.cnf from website is used for creating an intance.
• Option hideschema is automatically added to the myenv.conf file now.
• Check and warning implemented if non mysql user is used.
• Error is caught when wrong user is used.
• mysql_install_db output made more verbose in case of errors for debugging.
• Default option changes from Add to Save after instance was changed.
• Missing users HOME directory is caught now.
• Question done? can be answered with y now.
• Comment about waiting during instance installation added.

MyEnv Utilities

• Table offline/online scripts integrated into MyEnv utilities.
• alter_engine.pl does hide views from Primary Key check now.

MySQL Backup Manager

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalogrelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalog

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

You can download MyEnv from here.

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

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

Upgrade from 1.1.1 to 1.1.2 # cd ${HOME}/product # tar xf /download/myenv-1.1.2.tar.gz # rm -f myenv # ln -s myenv-1.1.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.1.2 MyEnv

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.
• OEM Agent is checked now based on process list and not oemagentctl status any more. Makes it much faster.
• Alias cdc for NDB Cluster directory removed. NDB Cluster is not supported any more.
• Deprecate alias v and replace by V.
• Error unlink(/var/lock/subsys/mysql): Permission denied is caught more nicely now.
• Unknown version in up guessing is improved.
• MD5 checksum made portable for Darwin OS (Mac OSX).

MyEnv Installer

• innodb_flush_log_at_trx_commit default in template changed.
• Version guessing improved for installer.
• Better download support for Percona Server and MariaDB added.
• mkdir bug fixed.
• Version check for RedHat made better.
• Check for lsb_release and SELinux/AppArmor check added for faster finding problems during MySQL installation.
• Template my.cnf from website is used for creating an intance.
• Option hideschema is automatically added to the myenv.conf file now.
• Check and warning implemented if non mysql user is used.
• Error is caught when wrong user is used.
• mysql_install_db output made more verbose in case of errors for debugging.
• Default option changes from Add to Save after instance was changed.
• Missing users HOME directory is caught now.
• Question done? can be answered with y now.
• Comment about waiting during instance installation added.

MyEnv Utilities

• Table offline/online scripts integrated into MyEnv utilities.
• alter_engine.pl does hide views from Primary Key check now.

MySQL Backup Manager

• The MySQL Backup Manager was removed from MyEnv and put into its own package which can be downloaded from FromDual Backup/Recovery Manager.

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

The majority of improvements happened in the MySQL Backup Manager (mysql_bman) where we added a backup catalog.

You can download MyEnv from here.

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

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

Upgrade from 1.1.0 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/
Upgrade from 1.0.5 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/

Replace the following files:

• cp ${HOME}/product/myenv/etc/variables.conf.template /etc/myenv/variables.conf
• cp ${HOME}/product/myenv/bin/myenv.server /etc/init.d/myenv

Changes in MyEnv 1.1.1 MyEnv

• Function to check upgrade requirements to v1.1 implemented.

MyEnv Installer

• none

MyEnv Utilities

• none

MySQL Backup Manager

• End tag added to mysql_bman code in certain places where it was missing.
• innodbackup bug fixed, pigz bug fixed.
• Warning message more verbose explaining solution in case of missing xtrabackup binaries.
• pigz as alternative compression mechanism implemented.
• Log mysqldump error to stderr.
• my_exec replaces exec/system calls.
• Return code exits fixed.
• Cleanup date is formated nicer and cleanup bug is fixed.
• copy_preserve introduced to preserve timestamp and archive code cleaned up.
• Retention time can be 0 or any value out of h, d, w, m.
• Binary log begin and end ts is written to log file.

MySQL Backup Manager Catalog

• Catalog DB handle was sometimes called without a catalog (ugly bug introduced in v1.1.0!).

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalogrelease

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

The majority of improvements happened in the MySQL Backup Manager (mysql_bman) where we added a backup catalog.

You can download MyEnv from here.

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

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

Upgrade from 1.1.0 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/
Upgrade from 1.0.5 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/

Replace the following files:

• cp ${HOME}/product/myenv/etc/variables.conf.template /etc/myenv/variables.conf
• cp ${HOME}/product/myenv/bin/myenv.server /etc/init.d/myenv

Changes in MyEnv 1.1.1 MyEnv

• Function to check upgrade requirements to v1.1 implemented.

MyEnv Installer

• none

MyEnv Utilities

• none

MySQL Backup Manager

• End tag added to mysql_bman code in certain places where it was missing.
• innodbackup bug fixed, pigz bug fixed.
• Warning message more verbose explaining solution in case of missing xtrabackup binaries.
• pigz as alternative compression mechanism implemented.
• Log mysqldump error to stderr.
• my_exec replaces exec/system calls.
• Return code exits fixed.
• Cleanup date is formated nicer and cleanup bug is fixed.
• copy_preserve introduced to preserve timestamp and archive code cleaned up.
• Retention time can be 0 or any value out of h, d, w, m.
• Binary log begin and end ts is written to log file.

MySQL Backup Manager Catalog

• Catalog DB handle was sometimes called without a catalog (ugly bug introduced in v1.1.0!).

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalogrelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalog

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

The majority of improvements happened in the MySQL Backup Manager (mysql_bman) where we added a backup catalog.

You can download MyEnv from here.

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

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

Upgrade from 1.1.0 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/
Upgrade from 1.0.5 to 1.1.1 # cd ${HOME}/product # tar xf /download/myenv-1.1.1.tar.gz # rm -f myenv # ln -s myenv-1.1.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/

Replace the following files:

• cp ${HOME}/product/myenv/etc/variables.conf.template /etc/myenv/variables.conf
• cp ${HOME}/product/myenv/bin/myenv.server /etc/init.d/myenv

Changes in MyEnv 1.1.1 MyEnv

• Function to check upgrade requirements to v1.1 implemented.

MyEnv Installer

• none

MyEnv Utilities

• none

MySQL Backup Manager

• End tag added to mysql_bman code in certain places where it was missing.
• innodbackup bug fixed, pigz bug fixed.
• Warning message more verbose explaining solution in case of missing xtrabackup binaries.
• pigz as alternative compression mechanism implemented.
• Log mysqldump error to stderr.
• my_exec replaces exec/system calls.
• Return code exits fixed.
• Cleanup date is formated nicer and cleanup bug is fixed.
• copy_preserve introduced to preserve timestamp and archive code cleaned up.
• Retention time can be 0 or any value out of h, d, w, m.
• Binary log begin and end ts is written to log file.

MySQL Backup Manager Catalog

• Catalog DB handle was sometimes called without a catalog (ugly bug introduced in v1.1.0!).