Performance isn’t worse, necessarily. As the article explains, there are specific conditions which make the schema approach better or worse depending on your application design and workload. Let me explain the tradeoffs of the “tenant-schema” vs. “shared-table” approaches: tenant-schema is best when you have a relatively small number of fairly large tenants. An example of … Read more
We built a multitenancy platform using the following architecture. I hope you can find some useful hints. Each tenant gets sub-domain (t1.example.com) Using url rewriting the requests for the Django application are rewritten to something like example.com/t1 All url definitions are prefixed with something like (r’^(?P<tenant_id>[\w\-]+) A middleware processes and consumes the tenant_id and adds … Read more
I usually add ClientID to all tables and go with one database. But since the database is usually hard to scale I will also make it possible to run on different database instances for some or all clients. That way you can have a bunch of small clients in one database and the big ones … Read more
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