All web applications that I helped building were multi-tenant capable, meaning that it is possible to host many clients on the same application / database without having them see each other.
Now that we can spin up new PaaS-instances to host another instance of an application I wondered whether it makes sense to drop multi-tenant awareness and just use one database and one web app per customer.
Advantages that I see are better isolation between the clients and potentially simpler setup & teardown of clients. Disadvantages may arise when we try to generate some inter-tenant reports (this may or may not be required for a specific application).
My question is, is it really a good idea to use cloud concepts to separate clients? Is something like this done for real-world applications?
Btw if it matters, our new application will be built on ASP.NET and hosted as Azure web site, using Cloudant as DB layer. Also, the expected number of clients is a few hundred at most, not millions.