FromDual MyEnv Documentation

$ ~/product/myenv/bin/showMyEnvVersion.php

# Become root again
$ sudo cp -i /home/dba/product/myenv/tpl/systemd.myenv.dba.unit.template /etc/systemd/system/myenv.service
$ sudo systemctl daemon-reload
$ sudo systemctl enable myenv.service
Created symlink /etc/systemd/system/myenv → /etc/systemd/system/myenv.service.

$ sudo systemctl status myenv.service
● myenv.service - FromDual Environment for MySQL and MariaDB (myenv)
   Loaded: loaded (/etc/systemd/system/myenv.service; enabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: https://www.fromdual.com/myenv-installation-guide

$ sudo systemctl start myenv
$ sudo systemctl status myenv
● myenv.service - FromDual Environment for MySQL and MariaDB (myenv)
   Loaded: loaded (/etc/systemd/system/myenv.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2020-09-01 09:42:39 CEST; 4s ago
     Docs: https://www.fromdual.com/myenv-installation-guide
  Process: 19532 ExecStartPre=/usr/bin/mkdir -p /run/myenv (code=exited, status=0/SUCCESS)
  Process: 19533 ExecStartPre=/usr/bin/chown mysql: /run/myenv (code=exited, status=0/SUCCESS)
 Main PID: 19534 (myenv_start_sto)
    Tasks: 32 (limit: 4915)
   Memory: 343.7M
   CGroup: /system.slice/myenv.service
           ├─19534 /usr/bin/php -d variables_order=EGPCS /home/dba/product/myenv/bin/myenv_start_stop.php start
           ├─19552 bin/mysqld --defaults-file=/home/dba/database/monitoring/etc/my.cnf --basedir=/home/dba/product/mysql-5.7 --datadir=/home/dba/database/monitoring/data --user=mysql
           ├─19584 sh -c export LC_ALL=C ; /usr/bin/php -d variables_order=EGPCS -f /home/dba/product/myenv-2.0.2/bin/database.php mysql-80 start 2>&1 2>/tmp/my_exec.stderr.19534
           ├─19585 /usr/bin/php -d variables_order=EGPCS -f /home/dba/product/myenv-2.0.2/bin/database.php mysql-80 start
           └─19595 bin/mysqld --defaults-file=/home/dba/database/mysql-80/etc/my.cnf --basedir=/home/dba/product/mysql-8.0 --datadir=/home/dba/database/mysql-80/data --user=mysql

Sep 01 09:42:39 boss systemd[1]: Starting FromDual Environment for MySQL and MariaDB (myenv)...
Sep 01 09:42:39 boss systemd[1]: Started FromDual Environment for MySQL and MariaDB (myenv).

$ sudo journalctl -xeu myenv
...

$ sudo tail /home/dba/product/myenv/log/myenv_start_stop.log -n 20
2025-09-01 09:42:39 Starting myenv_start_stop
2025-09-01 09:42:39 Starting instances: monitoring mysql-80 dwh mysql-84 mariadb-114 mariadb-118 mysql-8019
2025-09-01 09:42:39   Starting instance: monitoring
2025-09-01 09:42:42   Starting instance: mysql-80
2025-09-01 09:42:54   Starting instance: dwh
2025-09-01 09:42:57   Starting instance: mysql-84
2025-09-01 09:43:00   Starting instance: mariadb-114
2025-09-01 09:43:03   Starting instance: mariadb-118
2025-09-01 09:43:10   Starting instance: mysql-8019
2025-09-01 09:43:18 Finished myenv_start_stop (rc=0).

$ su - dba
$ cd ~/download
$ VERSION='2.1.1'
$ wget https://support.fromdual.com/admin/download/myenv-${VERSION}.tar.gz
$ cd ~/product
$ tar xf ../download/myenv-${VERSION}.tar.gz
$ unlink myenv
$ ln -s myenv-${VERSION} myenv

$ cd ~/product
$ sudo rm -rf myenv-x.y myenv /etc/init.d/myenv /etc/myenv
$ sudo rm /etc/systemd/system/myenv.service
$ sudo systemctl daemon-reload

$ ~/product/myenv/bin/installMyEnv.php

Configuration file /etc/myenv/myenv.conf already exists.

Use this, overwrite with Template or Abort (U,t,a): U


No instance exists yet.

An instance is the same as a mariadbd/mysqld/postgres process.

What do you want to do next?
o Add a new instance,
o change an existing instance,
o delete an existing instance,
o save configuration and exit or
o quit without saving

(A/c/d/s/q)? A

You have to enter a new instance name. An instance name can consist of 0-9, a-z, A-Z, - and _.

Examples: test, prod, dev, [mariadbd1] mysqld1 mariadbd-3306 postgresql1

Enter a new instance name: mariadbd1

You have to enter the database type.

Choice: [mysql] or postgresql

Enter database type: mysql

Changing instance mariadbd1:

Set basedir. The basedir is the directory where your MariaDB/MySQL/PostgreSQL binaries are located.
Example:
/home/dba/product/mariadb-12.3.1
/home/dba/product/mariadb-12.3.1-linux-systemd-x86_64
/home/dba/product/mysql-8.4.8
/home/dba/product/mysql-8.4.8-linux-glibc2.28-x86_64
/home/dba/product/postgresql-18.3
/home/dba/product/postgresql-18.3-x86_64

basedir = /home/dba/product/mariadb-12.3.1

/home/dba/product/mariadb-12.3.1 seems to exist and has already some files in it.

Omitting installation of binary tar ball.

Set instancedir. The instancedir is the directory where your MariaDB/MySQL/PostgreSQL data directory (datadir) is located.

Example: /var/lib/mysql/mariadbd1 /opt/mysql/mariadbd1 /usr/local/mysql/mariadbd1 [/home/dba/database/mariadbd1]
instancedir =

Creating directory /home/dba/database/mariadbd1

Set datadir. The datadir is the directory where your MariaDB/MySQL data are located.

Example: /var/lib/mysql /opt/mysql/data /usr/local/mysql/data /home/dba/data/mariadbd1 [/home/dba/database/mariadbd1/data]
datadir =

Creating directory /home/dba/database/mariadbd1/data

Shall I install a MariaDB/MySQL/PostgreSQL instance under /home/dba/database/mariadbd1/data (Y/n)?
Installing MariaDB/MySQL instance. Please be patient, this can take a while...

/home/dba/product/mariadb-12.3.1/scripts/mariadb-install-db --no-defaults  --user=dba --datadir=/home/dba/database/mariadbd1/data --basedir=/home/dba/product/mariadb-12.3.1

Set port.
Example: [3307]
port  =


Set socket.
Example: [/run/myenv/mariadb-3307.sock] /run/myenv/mariadb-mariadbd1.sock /run/myenv/mariadb.sock /run/myenv/mysql-3307.sock /run/myenv/mysql-mariadbd1.sock /run/myenv/mysql.sock
socket  =


Choose location of database configuration file (my.cnf/postgresql.conf):
Example: /etc/my.cnf /etc/mysql/my.cnf /home/dba/database/mariadbd1/data/my-3307.cnf /home/dba/database/mariadbd1/data/my.cnf [/home/dba/database/mariadbd1/etc/my.cnf]
my.cnf  =

INFO: There is no such file /home/dba/database/mariadbd1/etc/my.cnf yet.

Shall I strip comments from the configuration file (Y/n)?
Creating file /home/dba/database/mariadbd1/etc/my.cnf
Link my.cnf to datadir.

Shall mariadbd/mysqld be started with angel process (mariadbd-safe/mysqld_safe) (y/N)?

Shall instance run under cgroups to fences resources (y/N)?

Choose stage of instance mariadbd1:
Possible values: [production] quality testing development
stage  =

The following instances are available:

mariadbd1

An instance is the same as a mariadbd/mysqld/postgres process.

What do you want to do next?
o Add a new instance,
o change an existing instance,
o delete an existing instance,
o save configuration and exit or
o quit without saving

(a/c/d/S/q)? S


Writing the configuration file /etc/myenv/myenv.conf...
Rename /etc/myenv/myenv.conf to /etc/myenv/myenv.conf.2026-02-28-20-09-17
Write /etc/myenv/myenv.conf
Do you want to add the following code to your ~/.bash_profile file?

source /etc/myenv/MYENV_BASE
MYENV_PWD=$(pwd)
cd $MYENV_BASE/bin
source myenv.profile
cd $MYENV_BASE;
$MYENV_BASE/bin/showMyEnvStatus.php;
cd - > /dev/null
cd $MYENV_PWD

(Y/n)?

Writing /etc/myenv/MYENV_BASE

Now source your profile as follows:
shell> source ~/.bash_profile

The README gives some hints how to continue...

$ source ~/.bash_profile

Up       :

Down     : mariadbd1 (12.3.1)

mariadbd1 [*:3307 ] : test

$ source ~/.bash_profile

#
# /etc/myenv/myenv.conf
#

[test]

start                = yes
stop                 = yes
hideschema           = mysql,performance_schema,lost+found,sys
type                 = mysqld
basedir              = /home/dba/product/mysql-5.7
instancedir          = /home/dba/database/myenv_test
datadir              = /home/dba/database/myenv_test/data
user                 = mysql
port                 = 3306
socket               = /run/myenv/mysql-3306.sock
my.cnf               = /home/dba/database/myenv_test/etc/my.cnf
angel                = no
cgroups              = no
stage                = testing

    dba@master:~ [prodcms, 3308]> u

    Up       : mysql-8421 (5.7.21) prodcms (10.2)

    Down     : mysql-84 (5.7) mariadb-103 (10.3.8) mysql-4030 (4.0.30)
               mysql-4125 (4.1.25) mariadb-55 (5.5) galera-57-a (5.7)
               galera-57-b (5.7) galera-57-c (5.7)

    mysql-8421             (*:3311 ) : cacti
    mysql-84               (*:3310 ) : cluster_test test01 test02 test03
                                       test04
    mariadb-103            (*:3314 ) : typo3
    mysql-4030             (*:3309 ) : test
    mysql-4125             (*:3313 ) : test foodmart
    mariadb-55             (*:3307 ) : drupal7
    prodcms                (*:3308 ) : drupal8
    mariadb-55             (*:3312 ) : magento oxid
    galera-57-a (192.168.57.1:3306 ) : hybris
    galera-57-b (192.168.57.2:3306 ) : hybris
    galera-57-c (192.168.57.3:3306 ) : hybris

    dba@master:~ [prodcms, 3308]>

<instance> : Switches to the environment for this instance. For example:
             $ mariadb-103
u or up    : Lists, which releases are available, which instances are up and
             down and which instance contains which database. For example:
             $ u
start      : Starts the actual or a specific instance. For example:
             $ start
             or
             $ start mysql-805
stop       : Stops the actual instance or a specific instance. For example:
             $ stop
             or
             $ stop mariadb-10212
restart    : restarts the actual or a specific instance. For example:
             $ restart
             or
             $ restart mysql-8421
bootstrap  : bootstraps a Galera node.
V          : print the current MyEnv version
cdb        : cd to the binlogdir of this instance.
cdd        : cd to the datadir of this instance.
cde        : cd to the etcdir of this instance.
cdh        : cd to the basedir of this instance.
cdi        : cd to the instancedir of this instance.
cdl        : cd to the logdir of this instance.
cdm        : cd to the myenv-directory.
cdt        : cd to the tmpdir of this instance.
cd a b     : cd to a directory with the name where a is substituted by b.
             For example:
             $ pwd /var/lib/mysql1
             $ cd 1 2
             $ pwd /var/lib/mysql2
ll         : ls -l
la         : ls -la
mv         : mv -i
rm         : rm -i

    dba@chef:~ [mariadb-123, 3318]> u

    Up       : mariadb-118 (11.8) mysql-84 (8.4)

    Down     : monitoring (8.4) dwh (8.4) mariadb-123 (12.3)

    monitoring               (*:3319)  : mem mem__advisor_text mem__advisors mem__bean_config mem__config mem__enterprise
                                         mem__events mem__instruments mem__instruments_config mem__inventory mem__quan sys zabbix
    mariadb-118              (*:3312 ) : test
    dwh                      (*:3325 ) : cms crm datamart download erp focmm foodmart mpm shop staging tellmatic test
    mariadb-123              (*:3318 ) : foodmart test world
    mysql-84                 (*:3320 ) : FlughafenDB test test2

    dba@chef:~ [mariadb-123, 3318]> dwh
    dba@chef:~ [dwh, 3325]>

    dba@chef:~ [dwh, 3325]> start
    . SUCCESS!
    dba@chef:~ [dwh, 3325]> restart
    .. SUCCESS!
    . SUCCESS!
    dba@chef:~ [dwh, 3325]> stop
    .. SUCCESS!

    dba@chef:~ [dwh, 3325]> mariadb-118
    dba@chef:~ [mariadb-118, 3312]> cdm
    dba@chef:~/product/myenv [mariadb-118, 3312]> cdh
    dba@chef:~/product/mariadb-11.8 [mariadb-118, 3312]> cdd
    dba@chef:~/database/mariadb-118/data [mariadb-118, 3312]> cdb
    dba@chef:~/database/mariadb-118/binlog [mariadb-118, 3312]> cde
    dba@chef:~/database/mariadb-118/etc [mariadb-118, 3312]> cdl
    dba@chef:~/database/mariadb-118/log [mariadb-118, 3312]> cd 102 103
    dba@chef:~/database/mariadb-123/log [mariadb-118, 3312]>

$ export MYENV_DEBUG=1

$ unset MYENV_DEBUG