What would be the best way to separate users and guarantee processing power?
Scenario is this: Every user has their own database. Every user has purchased on guaranteed processing power amount of X cycles or whatever you use to measure it. The most important part is that all users must be completely separated.
Good way to grasp the idea is to think how VPS is done.. Of course now we are talking only about separating the database so running own Linux installation in VMWare would be huge overkill. I'm looking to do this with C++ using Boost framework. It has to run on top of a web service which will be done with PHP. I'm also open for database suggestions. I have previous experience with MySQL but I'm looking to try Hadoop next.
So any suggestions what's the best way to accomplish this?