MySQL Environment MyEnv 1.0.3 has been released

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

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

MyEnv

• Comment in aliases.conf and variables.conf more clear to avoid conflicts with shell variables.
• Commented lines in aliases.conf and variables.conf are ignored.
• product/lib/mysql path added to LD_LIBRARY_PATH for some set-ups (bug #106).
• CHANGELOG added.
• up alias pointing to function in .bash_profile caused troubles in cluster failover. Thus we are using the variables which should always work.

MyEnv Installer

• Install comments for MyEnv installer improved.
• root commands changed into sudo commands.
• basedir is guessed from product directory.
• New socket candidate added.
• Kill session procedure added (sql/create_procedures_kill_sessions.sql).

MyEnv Utilities

• glb_control.shx added. This utility removes or adds a Galera Cluster node from the Galera Load Balancer when the node is not SYNCED.
• Partition maintenance utilities were improved by adding a new partition merge utility (utl/merge_partition.php). Split partition is one week ahead to avoid huge amount of data copy. Password can be stored in a file instead of providing it on the command line. Options usage is fixed.
• Better check for invalid options/parameters in utl/slave_monitor.php (bug #114).

MySQL Backup Manager

• mysql_bman retention time maximum was verified incorrectly.
• Some typos in usage and error messages fixed.
• Remove target for type --cleanup, clean-up does not require target.
• Keys and values trimmed while reading config file.
• mysql_bman compression can be switched off for de-duplicated drives.
• mysql_bman considers ~.my.cnf (user and password) in client and mysqldump section.
• Separated mysql_bman into php part and bash wrapper.
• Split mysql_bman code and lib for automated testing.
• If option was passed twice this lead to strong behaviour (bug #33).
• backupdir creation error caught more nicely (bug #75).
• No option --cleanup removes files after archiving to tape (bug #76).
• Fixed endless loop bug in config read which affected customer.
• Use readlink if realpath is not available (problem with SLES).
• Cleanup does only delete bck_* files.
• No value options (--no-compress, --per-schema, --archive, etc.) in config file works.
• Example in --help is more clear.
• Target improved and more easy.
• Catch parse error on .my.cnf caused by ! in password string.
• .my.cnf (user, password) is considered and target adapted accordingly.
• Dump overview feature implemented.
• Full backup lists all schemas included.