AnsweredAssumed Answered

Several MySQL?

Question asked by sjordi on Jan 12, 2012
Latest reply on Jan 13, 2012 by mrogers
we run Alfresco based on MySQL.
Our problem is that we would like to be able to have it point to several MySQL instances.
Alfresco here serves many administrative departments and if one goes South, we would like to be able to make a database restore only for them.

MySQL, unlike Oracle, etc… has to be fully shut down since instances are not independant. That means restoring everything for everyone and have all department stop working in the meantime.

What we would love to have is, say, 3 MySQL instance running concurently
(one on port 3306, the 2nd on 3307, the 3rd on 3308).
If we have to shutdown one MySQL, and keep the two others up, that would dramatically simplify our maintenance.

Is this possible?
Thanks for any recommandation.