I want to run two instances of MySQL on one CentOS 7 machine. And I need to run instances on different users. Reason for this approach is need for limiting resources (CPU and memory) for each instance, because I don't want situation where one instance (serving one application) utilize all resources, so other database (and app) will be slow or non-functional.
If there is other way than two instances, feel free to suggest solution, but keep in mind that limits on query and connection number for specific database user is not solution for my case.
So, I've tried with this solution : run multiple instances of MySQL CentOS7
but only one instance is started .
In short: I want to run two instances, one on user mysql, one on user mysql2 on one machine, on different ports ofcourse.