In our current project the customer wants to install and run multiple MySQL Enterprise Server 5.7 Instances on the same machine (yes, I know about virtualization (we run on kvm), containers, Docker, etc.). He wants to use Red Hat Enterprise Linux (RHEL) 7 which brings the additional challenge of SystemD. So mysqld_multi is NOT an option any more.
This article will cover the installation of the MyEnv, a tool of FromDual.
MyEnv is a bundle of scripts to run multiple MySQL, Percona Server or MariaDB database instances on the same server with ease. You can even run multiple database instances with different binary versions.
The MyEnv (MySQL/MariaDB BasEnv) is a solution to operate easily MySQL multi-instance set-ups or MySQL installations installed with binary tar-balls. No more problems with packages, easy upgrade, you have everything under control.
es gibt Firmen, welche mit ihren MySQL Datenbanken zehntausende von Euros Umsatz pro Stunde erzielen. Andere Firmen betreiben ihr ERP System auf MySQL, an welchem 1000 Arbeitsplätze hängen. Steht die Datenbank still arbeiten 1000 Mitarbeiter nicht mehr, bis das System wieder läuft! Ausfallkosten ab EUR 30'000 pro Stunde aufwärts.
there are companies which earn tens of thousands of Euros per hour with their MySQL databases. Other companies operate their ERP system on MySQL, to which 1000 employees are attached to. Is the database down 1000 people are not working any more until the system is working again! Downtime costs starting at EUR 30'000.- per hour upwards.
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).
Vor ein paar Wochen haben wir einem unserer Kunden unser MyEnv gezeigt. Er war sehr interessiert daran und hat uns geraten MyEnv einer breiten Öffentlichkeit bekannter zu machen. In Tat und Wahrheit ist das MyEnv bereits seit mehreren Jahren verfügbar und kann frei heruntergeladen werden...
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.
MyEnv is a set of scripts to run comfortably multiple MySQL, Percona Server or MariaDB database instances on the same server. You can even run multiple database instances with different binary versions.
MyEnv is more comfortable than mysqld_multi and provides more functionality.
A large MySQL user (Alexa Ranking: Top 500 world-wide, top 20 in Germany) stated:
MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB.
All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.