MySQL Environment MyEnv 1.2.0 has been released

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 1^st 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.