FromDual InfoFeed (en)

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 fail-over 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.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackuprelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackup

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 fail-over 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.

FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular Database Performance Monitor for MySQL, MariaDB and Percona Server mpm.

This release makes mpm compatible with Zabbix v2.2 and contains various minor bug fixes and improvements.

You can download mpm from here.

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

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

New installation of mpm v0.9.2

Please follow our mpm installation guide.

Upgrade from 0.x to 0.9.2 # cd /download # tar xf mysql_performance_monitor-0.9.2.tar.gz # cd /opt # tar xf /download/mysql_performance_monitor_agent-0.9.2.tar.gz # rm -f mpm # ln -s mysql_performance_monitor_agent-0.9.2 mpm

No other upgrade requirements are known.

Changes in mpm v0.9.2 mpm agent

• Fix of mpm_mr_version newline at EOL which affects zabbix_sender.
• zabbix_sender return code change from Zabbix v2.2 and v2.1.7 fixed (bug #124).
• Log rotate problem caught.
• 2 exit errors fixed.
• Default file locations adapted to the newest standard.
• Using GLOBAL VARIABLES instead of SESSION VARIABLES.
• Cache file is removed instead of shrinked now, and remove lock file message should be at the right place.
• Agent locking problem fixed.
• Check of upload file size and shrink introduced.

mpm agent and MaaS

• Proxy settings should be considered now for MaaS solution.
• Data upload switched from http to https.
• Send data made more verbose related to http/s send method errors and prepared for https only behaviour.

DRBD module

• DRBD information is now reported correctly (bug #133).

Galera module

• wsrep_last_committed item added.

mpm templates for Zabbix

• Some items added to templates according to customer needs.

Taxonomy upgrade extras: mysqlperformancemonitormonitoringmpmmaasperformance monitorfpmmmrelease

FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular Database Performance Monitor for MySQL, MariaDB and Percona Server mpm.

This release makes mpm compatible with Zabbix v2.2 and contains various minor bug fixes and improvements.

You can download mpm from here.

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

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

New installation of mpm v0.9.2

Please follow our mpm installation guide.

Upgrade from 0.x to 0.9.2 # cd /download # tar xf mysql_performance_monitor-0.9.2.tar.gz # cd /opt # tar xf /download/mysql_performance_monitor_agent-0.9.2.tar.gz # rm -f mpm # ln -s mysql_performance_monitor_agent-0.9.2 mpm

No other upgrade requirements are known.

Changes in mpm v0.9.2 mpm agent

• Fix of mpm_mr_version newline at EOL which affects zabbix_sender.
• zabbix_sender return code change from Zabbix v2.2 and v2.1.7 fixed (bug #124).
• Log rotate problem caught.
• 2 exit errors fixed.
• Default file locations adapted to the newest standard.
• Using GLOBAL VARIABLES instead of SESSION VARIABLES.
• Cache file is removed instead of shrinked now, and remove lock file message should be at the right place.
• Agent locking problem fixed.
• Check of upload file size and shrink introduced.

mpm agent and MaaS

• Proxy settings should be considered now for MaaS solution.
• Data upload switched from http to https.
• Send data made more verbose related to http/s send method errors and prepared for https only behaviour.

DRBD module

• DRBD information is now reported correctly (bug #133).

Galera module

• wsrep_last_committed item added.

mpm templates for Zabbix

• Some items added to templates according to customer needs.

Taxonomy upgrade extras: mysqlperformancemonitormonitoringmpmmaasperformance monitorfpmmmrelease

Taxonomy upgrade extras: mysqlperformancemonitormonitoringmpmmaasperformance monitor

FromDual has the pleasure to announce the release of the new version 0.9.2 of its popular Database Performance Monitor for MySQL, MariaDB and Percona Server mpm.

This release makes mpm compatible with Zabbix v2.2 and contains various minor bug fixes and improvements.

You can download mpm from here.

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

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

New installation of mpm v0.9.2

Please follow our mpm installation guide.

Upgrade from 0.x to 0.9.2 # cd /download # tar xf mysql_performance_monitor-0.9.2.tar.gz # cd /opt # tar xf /download/mysql_performance_monitor_agent-0.9.2.tar.gz # rm -f mpm # ln -s mysql_performance_monitor_agent-0.9.2 mpm

No other upgrade requirements are known.

Changes in mpm v0.9.2 mpm agent

• Fix of mpm_mr_version newline at EOL which affects zabbix_sender.
• zabbix_sender return code change from Zabbix v2.2 and v2.1.7 fixed (bug #124).
• Log rotate problem caught.
• 2 exit errors fixed.
• Default file locations adapted to the newest standard.
• Using GLOBAL VARIABLES instead of SESSION VARIABLES.
• Cache file is removed instead of shrinked now, and remove lock file message should be at the right place.
• Agent locking problem fixed.
• Check of upload file size and shrink introduced.

mpm agent and MaaS

• Proxy settings should be considered now for MaaS solution.
• Data upload switched from http to https.
• Send data made more verbose related to http/s send method errors and prepared for https only behaviour.

DRBD module

• DRBD information is now reported correctly (bug #133).

Galera module

• wsrep_last_committed item added.

mpm templates for Zabbix

• Some items added to templates according to customer needs.

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

• MyEnv made PHP 5.4 compatible.
• System requirement checks for installation improved.
• Usage is only displayed with --help not on every error.
• Installation instructions improved.

MyEnv Installer

• Missing PHP error message improved.

MyEnv Utilities

• No changes.

MySQL Backup Manager

• System requirement checks for installation used from MyEnv.
• Installation instructions improved.
• Instance name can be added in mysql_bman backup file name (--instance-name).

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackuprelease

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

• MyEnv made PHP 5.4 compatible.
• System requirement checks for installation improved.
• Usage is only displayed with --help not on every error.
• Installation instructions improved.

MyEnv Installer

• Missing PHP error message improved.

MyEnv Utilities

• No changes.

MySQL Backup Manager

• System requirement checks for installation used from MyEnv.
• Installation instructions improved.
• Instance name can be added in mysql_bman backup file name (--instance-name).

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackuprelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackup

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

• MyEnv made PHP 5.4 compatible.
• System requirement checks for installation improved.
• Usage is only displayed with --help not on every error.
• Installation instructions improved.

MyEnv Installer

• Missing PHP error message improved.

MyEnv Utilities

• No changes.

MySQL Backup Manager

• System requirement checks for installation used from MyEnv.
• Installation instructions improved.
• Instance name can be added in mysql_bman backup file name (--instance-name).

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 fail-over. 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.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationrelease

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 fail-over. 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.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationrelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidation

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 fail-over. 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.

We are very satisfied with the functionality and the launch. The entire Cluster is running absolutely stable. This is a significant advantage for our customers because we are able to offer our services without interruption. We will use Galera in further projects and convert our existing Master/Slave installations.

A. Rempening, Datenbank-Administrator, KiKxxl GmbH

Download this case study: KiKxxl Gmbh: Highly available communication services based on a MySQL database and Galera Cluster (PDF, 420 kbyte).

Taxonomy upgrade extras: galeraclustercustomer

We are very satisfied with the functionality and the launch. The entire Cluster is running absolutely stable. This is a significant advantage for our customers because we are able to offer our services without interruption. We will use Galera in further projects and convert our existing Master/Slave installations.

A. Rempening, Datenbank-Administrator, KiKxxl GmbH

Download this case study: KiKxxl Gmbh: Highly available communication services based on a MySQL database and Galera Cluster (PDF, 420 kbyte).

Taxonomy upgrade extras: galeraclustercustomer

Taxonomy upgrade extras: galeraclustercustomer

We are very satisfied with the functionality and the launch. The entire Cluster is running absolutely stable. This is a significant advantage for our customers because we are able to offer our services without interruption. We will use Galera in further projects and convert our existing Master/Slave installations.

A. Rempening, Datenbank-Administrator, KiKxxl GmbH

Download this case study: KiKxxl Gmbh: Highly available communication services based on a MySQL database and Galera Cluster (PDF, 420 kbyte).

FromDual has the pleasure to announce the release of the new version 1.0.2 of its popular multi-instance MySQL 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.

If you have questions about MyEnv we will answer them in the MyEnv forum.

Upgrade from 1.0.x to 1.0.2 # cd /home/mysql/product # tar xf /tmp/myenv-1.0.2.tar.gz # rm -f myenv # ln -s myenv-1.0.2 myenv

Add the following line to your ~/.bash_profile:

# BEGIN MyEnv # Written by the MyEnv installMyEnv.php script. . /etc/myenv/MYENV_BASE MYENV_PWD=`pwd` cd $MYENV_BASE/bin . myenv.profile up cd $MYENV_PWD # END MyEnv Changes in MyEnv 1.0.2 MyEnv

• Missing [client] section in my.cnf should not lead to error any more (Bug #95).
• profile.template removed because it is redundant to installer information.
• up removed from myenv.profile.
• Also root should be allowed to start MySQL (Bug #99).
• Status for OEM agent implemented (oem_agent.php). To activate this feature copy it from utl/oem_agent.php to plg/showMyEnvStatus/.
• Plug-in interface for showMyEnvStatus.php implemented.
• Debug information improved.
• Empty line after environment switch removed.
• One missing error line in myenv_start_stop.php was added.
• Return code in myenv_start_stop.php is nicer now.
• Difference between my.cnf and myenv.conf should be warning and not an error.
• Error messages made more precise.
• Made it more clear that MyEnv is distributed under GPL v2.
• Deleting the actual instance with MyEnv Installer should no longer confuse MyEnv (Bug #104).
• RPM packages for CentOS 6, Fedora 18 and 19, RHEL 5 and 6 are available.

MyEnv Installer

• User experience during deleting an instance improved (Bug #96).
• Deleting a running instance is not allowed. Much more verbose information about (Bug #89).
• Instance name black list added.
• Instances should be listed when change was chosen (#93).
• Replace multi-line readline output to fixed crippled output in menu selection (Bug #103).

MyEnv Utilities

• alter_engine.pl should now work for socket and port, local and remote.
• Password is not exposed any more in alter_engine.pl.
• Query bench (query_bench.phpx) added for micro bench marks.

MySQL Backup Manager

• Automated mysql_bman tests should all pass again.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationrelease

FromDual has the pleasure to announce the release of the new version 1.0.2 of its popular multi-instance MySQL 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.

If you have questions about MyEnv we will answer them in the MyEnv forum.

Upgrade from 1.0.x to 1.0.2 # cd /home/mysql/product # tar xf /tmp/myenv-1.0.2.tar.gz # rm -f myenv # ln -s myenv-1.0.2 myenv

Add the following line to your ~/.bash_profile:

# BEGIN MyEnv # Written by the MyEnv installMyEnv.php script. . /etc/myenv/MYENV_BASE MYENV_PWD=`pwd` cd $MYENV_BASE/bin . myenv.profile up cd $MYENV_PWD # END MyEnv Changes in MyEnv 1.0.2 MyEnv

• Missing [client] section in my.cnf should not lead to error any more (Bug #95).
• profile.template removed because it is redundant to installer information.
• up removed from myenv.profile.
• Also root should be allowed to start MySQL (Bug #99).
• Status for OEM agent implemented (oem_agent.php). To activate this feature copy it from utl/oem_agent.php to plg/showMyEnvStatus/.
• Plug-in interface for showMyEnvStatus.php implemented.
• Debug information improved.
• Empty line after environment switch removed.
• One missing error line in myenv_start_stop.php was added.
• Return code in myenv_start_stop.php is nicer now.
• Difference between my.cnf and myenv.conf should be warning and not an error.
• Error messages made more precise.
• Made it more clear that MyEnv is distributed under GPL v2.
• Deleting the actual instance with MyEnv Installer should no longer confuse MyEnv (Bug #104).
• RPM packages for CentOS 6, Fedora 18 and 19, RHEL 5 and 6 are available.

MyEnv Installer

• User experience during deleting an instance improved (Bug #96).
• Deleting a running instance is not allowed. Much more verbose information about (Bug #89).
• Instance name black list added.
• Instances should be listed when change was chosen (#93).
• Replace multi-line readline output to fixed crippled output in menu selection (Bug #103).

MyEnv Utilities

• alter_engine.pl should now work for socket and port, local and remote.
• Password is not exposed any more in alter_engine.pl.
• Query bench (query_bench.phpx) added for micro bench marks.

MySQL Backup Manager

• Automated mysql_bman tests should all pass again.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationrelease

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidation

FromDual has the pleasure to announce the release of the new version 1.0.2 of its popular multi-instance MySQL 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.

If you have questions about MyEnv we will answer them in the MyEnv forum.

Upgrade from 1.0.x to 1.0.2 # cd /home/mysql/product # tar xf /tmp/myenv-1.0.2.tar.gz # rm -f myenv # ln -s myenv-1.0.2 myenv

Add the following line to your ~/.bash_profile:

# BEGIN MyEnv # Written by the MyEnv installMyEnv.php script. . /etc/myenv/MYENV_BASE MYENV_PWD=`pwd` cd $MYENV_BASE/bin . myenv.profile up cd $MYENV_PWD # END MyEnv Changes in MyEnv 1.0.2 MyEnv

• Missing [client] section in my.cnf should not lead to error any more (Bug #95).
• profile.template removed because it is redundant to installer information.
• up removed from myenv.profile.
• Also root should be allowed to start MySQL (Bug #99).
• Status for OEM agent implemented (oem_agent.php). To activate this feature copy it from utl/oem_agent.php to plg/showMyEnvStatus/.
• Plug-in interface for showMyEnvStatus.php implemented.
• Debug information improved.
• Empty line after environment switch removed.
• One missing error line in myenv_start_stop.php was added.
• Return code in myenv_start_stop.php is nicer now.
• Difference between my.cnf and myenv.conf should be warning and not an error.
• Error messages made more precise.
• Made it more clear that MyEnv is distributed under GPL v2.
• Deleting the actual instance with MyEnv Installer should no longer confuse MyEnv (Bug #104).
• RPM packages for CentOS 6, Fedora 18 and 19, RHEL 5 and 6 are available.

MyEnv Installer

• User experience during deleting an instance improved (Bug #96).
• Deleting a running instance is not allowed. Much more verbose information about (Bug #89).
• Instance name black list added.
• Instances should be listed when change was chosen (#93).
• Replace multi-line readline output to fixed crippled output in menu selection (Bug #103).

MyEnv Utilities

• alter_engine.pl should now work for socket and port, local and remote.
• Password is not exposed any more in alter_engine.pl.
• Query bench (query_bench.phpx) added for micro bench marks.

MySQL Backup Manager

• Automated mysql_bman tests should all pass again.

Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidation

FromDual has the pleasure to announce the release of the new version 1.0.1 of its popular multi-instance MySQL 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.

If you have questions about MyEnv we will answer them in the MyEnv forum.

Upgrade from 1.0 or 1.0.x to 1.0.y # cd /home/mysql/product # tar xf /tmp/myenv-1.0.y.tar.gz # rm -f myenv # ln -s myenv-1.0.y myenv
Changes in MyEnv 1.0.1 MyEnv

• New alias v introduce for echo $MYENV_VERSION.
• Function start was extended by --option. This allows you to start a Galera cluster node as follows: start --wsrep-cluster-address="gcomm://" (Bug #58).
• Requirements for Ubuntu in README added.
• Mismatch between my.cnf and myenv.conf or [mysqld] section and [client] section in my.cnf is checked and reported (Bug #71).
• Before an instance is started MyEnv will check if file mysql/user.frm is created just in case installation was missing (Bug #82).
• Non default PID file name is handled properly (Bug #64).
• Starting an instance will also report SUCCESS or ERROR.
• Instance check mysqladmin ping was improved by adding a timeout (Bug #56).
• User to start MySQL instance is checked (Bug #69).
• The scripts start and stop are much more robust (Bug #66).
• Internal sequence of checks during start and stop has been changed.
• Package recommendation for SLES/OpenSuSE completed.
• Fixes around the POSIX functions for SLES/OpenSuSE.
• Fake around missing signal constants for SLES/OpenSuSE and more verbose error messages.
• Check for missing POSIX features added (Bug #59).
• MyEnv start-up and check sequence changed.

MyEnv Installer

• Deleting a non existing instance is handled properly.
• Empty basedir is handled properly.
• Installation on /etc/my.cnf is handled properly (Bug #62).
• Installation of my.cnf is redesigned, prepared for future features and error handling is improved.
• mysql_install_db is also searched in bin path for NDB (MySQL Cluster) set-ups.
• Installer is checking at the right location to decide if an instance is already installed or not (#Bug #83).
• Installer should not be started as root user. Throwing warning (Bug #61).
• Installer has additional suggestion for socket name: mysql-instance.sock, whole installation process is broken up in more pieces for future improvements, test cases were added (Bug #60).
• Delete instance error messages made more clear (Bug #89).

MyEnv Utilities

No changes in this release.

MySQL Backup Manager

No changes in this release.

FromDual has the pleasure to announce the release of the new version 1.0 of its popular multi-instance MySQL Environment MyEnv.

Thanks to the countless feedback of many big customers and the community we finally feel ready to publish version 1.0. A major step forward from the last version 0.4 (dated March 2011) and not published version 0.5 (dated August 2013).

What is MyEnv?

MyEnv is a CLI environment for operating multiple MySQL instances on the same server. If you are using mysqld_multi or/and if you have set-up multiple mysqld instances on the same machine you should really have a look at MyEnv.

If you consider to consolidate your MySQL databases on one machine but if you do not want to pack everything in one instance you are a candidate for MyEnv as well...

You can download MyEnv from here.

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

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

Upgrade from 0.x to 1.0

Package php-posix needs to be installed.

If the following manual steps are too complicated just run the installer installMyEnv.sh and copy your old myenv.conf to /etc/myenv.

# cd /home/mysql/product # tar xf /tmp/myenv-1.0.tar.gz # sudo mkdir /etc/myenv # sudo chown mysql: /etc/myenv # echo 'export MYENV_BASE=/home/mysql/product/myenv' > /etc/myenv/MYENV_BASE # cp /home/mysql/product/myenv/etc/myenv.conf /etc/myenv/ # rm -f myenv # ln -s myenv-1.y myenv # cp myenv/etc/aliases.conf.template /etc/myenv/aliases.conf # cp myenv/etc/variables.conf.template /etc/myenv/variables.conf # cat > ~/.bash_profile # BEGIN MyEnv # Written by the MyEnv installMyEnv.php script. . /etc/myenv/MYENV_BASE MYENV_PWD=`pwd` cd $MYENV_BASE/bin . myenv.profile cd $MYENV_PWD # END MyEnv _EOF
Changes in MyEnv 1.0 MyEnv

• cd abc xyz alias failed when one of the patterns contained a space. This is fixed now (Bug #10).
• Different smaller bug fixes.
• timezone added to MyEnv to avoid nasty error messages.
• Old path in PATH variables should be cleaned-up properly now.
• Incompatible Change: DEBUG variables replaced by MYENV_DEBUG.
• MyEnv start/stop script (myenv_start_stop.php) accepts as parameter and instance name now (customer enhancement request).
• hideschema parameter implemented for myenv.conf (customer enhancement request).
• Default section is now configurable in section [default] (customer enhancement request).
• Better support for Percona Server (customer enhancement request).
• Readline support added for set-ups not having it by default (customer enhancement request).
• cdb alias added for cd $basedir or cd $MYSQL_HOME.
• Security check for my.cnf introduced.
• Password was shown in clear text in error log (Bug #12).
• tmp directory is added to MyEnv structure.
• unknown version fixed.
• Made hideschema variable inheritable.
• Parameter drizzle and type removed. De-support for Drizzle.
• The utl directory should be added to the PATH as well.
• Add Path to the right of PATH is fixed now.
• Possibility to start mysqld without angel process (mysqld_safe) now.
• /tmp/myEnv.xxx files where not removed. This is fixed now.
• 5.6.12 as version pattern is now accepted (customer request).
• Incompatible Change: Configuration file (myenv.conf) is now relocated from $MYENV_HOME/etc to /etc/myenv.
• MySQL stop functionality was changed from mysqladmin shutdown to kill (MySQL like).
• my.cnf privilege check is less restrictive now (rwxr-----).

MyEnv Installer

• Many bug fixes and improvements for MyEnv Installer.
• Incompatible Change: MyEnv Installer rewritten, renamed (bin/installMyEnv.php) and code cleaned-up.
• MySQL database can now be created in installer.
• Check for mysql user is added to installer.
• Missing mysql_install_db is caught.
• Missing socket error is caught.
• Only a stopped database can be deleted.
• Configuration files are versioned when changed.
• Delete process more user-friendly.
• Missing basedir and datadir variables in my.cnf fixed.
• Privileges of my.cnf file set correctly to avoid warning later.
• Not existing my.cnf file caught.
• Selection characters made more intuitive.
• Empty my.cnf string caught.
• Installer is aware of missing environment variables.
• Start/stop instance parameter was added in installer.

MyEnv Utilities

• Row Extractor (utl/row_extractor.pl) to extract rows from corrupt tables (leading to a DB crash) added.
• Script to flush Query Cache regularly (utl/flush_query_cache.sh) added.
• Script to find last access to tables (utl/filesystem_table.php) added.
• MySQL Backup Manager (mysql_bman) added.
• Script to do a NDB Cluster channel fail-over (utl/channel_failover.pl) added.
• README about MyEnv utilities usage updated (utl/README).
• Compare script to compare two GLOBAL STATUS outputs added (utl/compare.php).
• Rotate log script to rotate different MySQL logs added (utl/rotate_log.sh).
• Script to convert \G output of MySQL client to one-line output added (utl/backslashG2table.pl).
• alter_engine.sh script improved by a Perl version (for windows customer) (utl/alter_engine.pl).
• Different resources, configuration files and monitors added for Heartbeat v1/v2: (utl/{stop-heartbeat.alert|ping.monitor|node.monitor|mysql.monitor|mail.alert|Crontab|canias}, etc/{drbd.conf.template|ha.cf.template|mon.cf.template|my.cnf.template}).)
• Slave Monitor added (utl/{slave_monitoring.php|slave_monitor.php}).
• DRBD Monitor added (utl/check_drbd.sh).
• MySQL Profiler added (utl/profiler/{profiler.pl|tracer.pl}).
• split_partition.php and drop_partition.php scripts added (utl/{split_partition.php|drop_partition.php}).
• Insert test added (utl/{insert_test.sh|insert_test.phpx}). Shell script is for connection testing. PHP script is more for INSERT load testing...
• Utility mem_map.pl added (utl/mem_map.pl).
• Start/stop script for VIP added (utl/vip).
• Script to fix wrong encoding added (utl/fix_encoding.php).
• Alter Engine script enhanced with MySQL 5.6 and Galera features.
• Ping Log utility added (utl/ping_log.sh).
• Script added to block MySQL port so Load Balancer recognizes if Galera Cluster node is away (utl/block_galera_node.sh, customer request).
• Create table statement for test.test table for insert_test.* added as comment to the script.

MySQL Backup Manager (mysql_bman)

• Several bugs fixed and improvements.
• Schema dump implemented now (customer enhancement request).
• Backup is now possible with MySQL 5.5 as well (Bug #31).
• All parameters can now be put in the configuration file.
• Configuration file is now more dynamic.
• Archive job fixed.
• Configuration backup fixed.
• Xtrabackup wrapper added.
• Empty schema option defaults now to all databases.
• Per schema backup should not contain drop/create database.

Have fun,
The FromDual Consulting Team

FromDual holds its annual company meeting this year in Leoforos Vravronos near Athens (20 km outside) in Greece.

We are happy to invite everybody interested in MySQL technologies (MySQL, Percona Cluster, MariaDB, Galera Cluster, etc.) to participate Wednesday evening October 9th at the Mare Nostrum Hotel in Leoforos Vravronos for exchanging ideas about MySQL.

Meeting at 17:00 in the hotel lobby.

• Presentation about Xtrabackup (25') and 5' Questions and Answers (Abdel-Mawla Gharieb, Support Engineer at FromDual)
• Presentation of a MySQL community member (25') and 5' Questions and Answers
• Break 15 min
• Presentation about Galera Cluster (25') and 5' Questions and Answers (Oli Sennhauser, CTO of FromDual))
• Presentation of a MySQL community member or discussion and questions about MySQL (25') and 5' Questions and Answers
• Dinner at the Mare Nostrum Hotel Restaurant

Please feel free to send us your suggestion about your presentation. Any technical or non-technical MySQL related topic is welcome. For example how you use MySQL in your companies or special problems you have faced and solved (or not solved yet), research work you have done on MySQL products. Business cases you solve with MySQL products, Evaluations or experience you have made. The proposal can be sent to contac@fromdual.com.

Please also let us know when you plan to participate at contact@fromdual.com. So we can arrange and organize all the infrastructure with the Hotel.

The event is free of costs for all participants.

Best Regards,
Your FromDual Team