MySQL Environment MyEnv 1.1.1 has been released

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!).