MySQL Environment MyEnv 1.0.5 has been released

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

The majority of improvements happened on the MySQL Backup Manager (mysql_bman) utility.

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.0.x to 1.0.5

# cd ${HOME}/product
# tar xf /download/myenv-1.0.5.tar.gz
# rm -f myenv
# ln -s myenv-1.0.5 myenv

Upgrade from 1.0.2 or older to 1.0.3 or newer

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/

Exchange the MyEnv section in ~/.bash_profile (make a backup of this file first?) by the following new one:

# BEGIN MyEnv
# Written by the MyEnv installMyEnv.php script.
. /etc/myenv/MYENV_BASE
MYENV_PWD=`pwd`
cd $MYENV_BASE/bin
. myenv.profile
cd $MYENV_BASE;
$MYENV_BASE/bin/showMyEnvStatus.php;
cd - > /dev/null
cd $MYENV_PWD
# END MyEnv

Changes in MyEnv 1.0.5

MyEnv

• Schema output in up was still ugly.
• Instance output is split correctly similar to up/down display.
• Instance list is now shorter when short instance names are used.
• ignore-passive option added for myEnv to ignore passive databases in an active/passive failover cluster. Based on existence of datadir.
• Upgrade instructions have been improved and denormalized.
• Only display existing OEM agents, criteria is directory in oratab must exist.
• Up instances are not reported with missing mysqladmin command (Galera binary tar balls) but it was not visible what is the reason. Reason is displayed as an error message now.

MyEnv Installer

• Lists each basedir candidate in a separate line when adding a new instance. More conveniant for reading if many basedirs are available.

MyEnv Utilities

• block_galera_node.sh: Insert instead of Append used for firewall rules. Only block load balancer ports and not everything else.
• block_galera_node.sh made more flexible.

MySQL Backup Manager

• Cleanup job errors with missing target. Fixed for MGB.
• Password on command line is not exposed anymore to log file.
• Instance name optionally added to binary-log backup file names.
• Binary logs are not cleaned-up because they are not copied with bck_ prefix (Bug #143).
• Config file example in --help output done more nicely.
• More strict option checking implemented.
• All schemas with non transactional tables are shown instead of just the first one.
• Help typo fixed and example improved.
• --ignore-memory-table-check implemented to avoid error exit with MEMORY tables.
• Preparation work for blocking MyISAM backup done.