MyEnv (MySQL and MariaDB BasEnv)

— Shinguz

What is MyEnv?

FromDual MyEnv is a database environment to run and operate several different MariaDB, MySQL or PostgreSQL database instances simultaneously on the SAME machine. You can even run multiple database instances with different binary versions. We call this multi-instance set-ups.

With MyEnv a multi-instance set-up is more comfortable to handle than with mysqld_multi (old) or Systemd services (new) and it provides more useful functionality.

Using MyEnv does not need the use of the O/S root user to operate MariaDB, MySQL or PostgreSQL database instances. Thus it is appropriate for classical enterprise DBA organizations (segregation of duties).

Further MyEnv multi-instance set-ups are a much more efficient way of consolidating MariaDB, MySQL and PostgreSQL database instances an has less overhead than virtualization or even container solutions. To do proper resource fencing MyEnv provides cgroup integration.

When to use MyEnv?

MyEnv is useful when you have to install several MariaDB, MySQL or PostgreSQL database instances on one machine. This has to be done typically:

  • when you have to consolidate many database instances from dedicated servers into fewer machines or
  • when you have to separate the data of different customers into different database instances if you provide Software-as-a-Service (SaaS) solutions (for example hoster or internal IT departments for big companies) or
  • when you have to install different versions or forks of MariaDB, MySQL or PostgreSQL to run tests on it or
  • when you are using binary tarballs.

Check out this link for more information about How to install multiple MySQL instances on a single host using MyEnv.

MyEnv has the advantage over virtualization solutions (like VMWare or VirtualBox) that you do not have the overhead of an additional virtual machine and the installed operating system.

MyEnv has the advantage over container solutions (like Docker or LXD) that it is much easier and transparent to operate.

MyEnv is based on ideas of the Trivadis TVD-BasEnv, which does not exist any more, and is used for Oracle databases.

Upgrading under MyEnv is much simpler than with DEB or RPM packages because MyEnv relies on binary tarballs.

MyEnv users are saying…

A large MySQL user (Alexa Ranking: Top 500 world-wide, top 20 in Germany) stated:

I found MyEnv accidentally when I was searching for something like this. I liked it immediately more than MySQL Sandbox or mysqld_multi. A very comfortable tool. Thank you very much!

And MyEnv user Jonv:

I am working on a project where I will most likely be using MyEnv (oh how I wish I had known of this the last time I set up mysqld_multi). … Thanks for writing MyEnv, it is going to make this project far more polished without having to use mysqld_multi again.

License

MyEnv is distributed under the terms of the GNU General Public License v2.

Download

MyEnv can be downloaded from the FromDual MyEnv Download.

Installation and Documentation

Please checkt the MyEnv Installation guide.