Assume there’s no scaling penalty for storing all the clients in one database; for most people, and well configured databases/queries, this will be fairly true these days. If you’re not one of these people, well, then the benefit of a single database is obvious. In this situation, benefits come from the encapsulation of each client. … Read more
I have the same problem to solve and also considering variants. As I have years of experience creating SaaS multi-tenant applicatios I also was going to select the second option based on my previous experience with the relational databases. While making my research I found this article on mongodb support site (way back added since … Read more
However there are some companies of course who fear that their data might be compromised, so we are evaluating other solutions. This is unfortunate, as customers sometimes suffer from a misconception that only physical isolation can offer enough security. There is an interesting MSDN article, titled Multi-Tenant Data Architecture, which you may want to check. … Read more