MariaDB/MySQL Environment MyEnv 2.1.1 has been released

FromDual has the pleasure to announce the release of the new version 2.1.1 of its popular MariaDB, Galera Cluster and MySQL multi-instance environment MyEnv.

The new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide.

In the inconceivable case that you find a bug in the FromDual Performance Monitor please report it to us by sending an email.

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

Upgrade from 1.1.x to 2.0

Please look at the MyEnv 2.0.0 Release Notes.

Upgrade from 2.0.x to 2.1.1

$ sudo -i -u mysql
$ cd ${HOME}/product
$ tar xf /download/myenv-2.1.1.tar.gz
$ rm -f myenv
$ ln -s myenv-2.1.1 myenv

Plug-ins

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 of the instance directory structure

From MyEnv 1.0 to 2.0 the directory structure of instances has fundamentally changed. Nevertheless MyEnv 2.0 works fine with MyEnv 1.0 directory structures.

Changes in MyEnv 2.1.1

MyEnv

• addInstance for PostgreSQL added.
• Basic PostgreSQL functionality implemented.
• up working now.
• stop, start, restart and status implemented for PostgreSQL.
• Version extraction for PostgreSQL added.
• Function extractVersion rewritten so section config is passed and not basedir any more.
• Configuration type mysqld changed to mysql and now also usable for mariadb and postgresql.
• New variant of version comment added for MySQL 8.0.
• Comment added to my_exec().

MyEnv Installer

• mysql/mariadb fork installation implemented and tested.
• Example in installMyEnv corrected/improved.
• Made nasty warning during installation of new instance go away.

MyEnv Utilities

• New script added.
• SSL added to monitor.
• Slave monitor made MySQL 8+ ready.
• checksum_table works now also with tables consisting of protected keywords.
• More debugging info added.
• All scripts checked by shellcheck.
• Missing runtime directory is caught and fixed now.
• shellcheck suggestions applied.
• checksum_table.sh added.
• Utility scripts brought to new state.
• Build slave script added.
• table diff refactored.
• Chunking added.
• table_diff is now ready for chunking.
• Faster checksum implemented and output shortened.
• Row by row crc32 checksum.
• Moved the checksum table in its own function.
• table_diff.php added.

PostgreSQL

• show_create_table.sh for PostgreSQL added.
• PostgreSQL files added here until we have a better location.

General

• Code clean-up and configuration check added.
• Recursive directory removal improved.
• rc made unique.
• Minor typos fixed.
• my.cnf.template cleaned-up and synced with website.
• 2 bugs with PHP 8.5 fixed.
• Libraries updated.
• Some return codes can be ignored because Redhat tools return error codes > 100 as OK.

Documentation

• Documentation added and ready to start.

Packaging

• Distro versions centralized in one place.
• Zabbix repo added for Ubuntu 24.04.
• Rocky 10 and Debian 11 added.
• lxc replaced by incus, distros cleaned-up.
• Ubuntu 24.04 and MariaDB 10.11 and 11.4 enabled.
• brman as build project added.
• glb included in build scripts.
• restartContainer implemented.
• gid and uid added to pushFileToContainer.
• Build cleaned-up.
• Build scrips improved.
• Container file push and pull added.
• Build infrastructure reorganized.
• stopContainer and startContainer added.
• Container library started.
• Debian 10 removed.
• Update container script is waiting to avoid infrastructure build failure.
• Old package for RPM changed.
• install_base separted from mysql_home.
• Installation moved from /home/mysql to /opt.
• Fix DEB package.
• Ubuntu 22.04 added for package build.
• Bug in Debian build script fixed.
• Ubuntu 24.04 added to build infrastructure.
• recreate_build_infrastructure.sh rewritten in PHP.
• update_container_templates.sh rewritten in PHP.
• Made package build infrastructure more generic.

For subscriptions of commercial use of MyEnv please get in contact with us.