You are here

MyEnv for MySQL Multi-Database set-ups

This week I showed one of my customers our MyEnv. He was very interested in it and suggested to make it known in public. In fact MyEnv is available for download already several years...

But I did not have the heart yet to announce it more publicly because it was not end user ready at all. So I used the weekend to make it nicer, consolidated some of the code, dropped old stuff etc. Now I think it is acceptable to use for public but not perfect.

So what is MyEnv?

MyEnv is a set of scripts to run comfortably multiple MySQL/MariaDB databases on the same server. You can even run multiple databases with different binary versions.

It is more comfortable than mysqld_multi and provides more functionality.

When to use MyEnv?

MyEnv is useful when you have to install several MySQL databases on one machine. This has to be done typically when:

  • you have to consolidate many databases from dedicated servers into one machine or
  • you have to separate the data of different customers into different databases for example when you provide Software-as-a-Service (SaaS) solutions.

MyEnv has the advantage over Virtualization solutions (like VMWare or VirtualBox) that you have not the overhead of an additional virtual machine and the installed OS. So you can run more MySQL/MariaDB database on less machines.

So please, try it out. If it is of use for you, I am happy. Please let me also know, when you have problems with it, when you find bugs or when you have some feature requests.

When you have general questions about Consolidation of MySQL database servers or using MySQL in a Software-as-a-Service (SaaS) set-up our Consulting Team is happy to help you...

More information you can find in the documentation.