Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [multitenancy]

79 questions
38
votes
2 answers

Do multi-tenant DBs have multiple databases or shared tables?

Is a multi-tenant database: A DB server that has a different (identical) database/schema for each customer/tenant?; or A DB server that has a database/schema where customers/tenants share records inside of the same tables? For instance, under…
smeeb
  • 4,820
  • 10
  • 30
  • 49
37
votes
6 answers

Should I use one database per application or share a single database amongst multiple applications

I have multiple applications some that use data from the same sources. Is it best practice (or what are the pros/cons) to: leave the data in databases shared by multiple applications saves space as only one database is needed complicates indexing…
Laz
  • 761
  • 1
  • 6
  • 10
29
votes
5 answers

Multi-tenancy - single database vs multiple database

We have a number of clients, whose systems share some functionality, but also have quite a degree of diversity. The number of clients is growing - always a healthy thing! - and the diversity between their businesses is also increasing. At present…
RichardW1001
  • 391
  • 1
  • 3
  • 5
26
votes
3 answers

What exactly is a multi-tenant application?

According to the definition available online, "Multi-tenancy is an architecture in which a single instance of a software application serves multiple customers". It means I have a Restaurant or School website and I provide access to different…
Nomi Ali
  • 369
  • 1
  • 3
  • 5
13
votes
2 answers

Multi tenancy or multi instance?

I'm trying to build a web-based SaaS solution, and I hit a road where I'm not sure to use multi tenancy or multi instance. I will try to describe what I'm trying to achieve, and each approach advantages and disadvantages (my opinion, according to…
Asher
  • 239
  • 2
  • 5
10
votes
3 answers

Supporting multitenancy

What are the typical challenges that arise when converting a single-tenant app into a multitenant app? Security and data isolation strike me as the most significant. What are some others? I'm one of the architects for a fairly significant automation…
user21123
7
votes
2 answers

What are the advantages of using multi-tenant architecture with separate db schemas per customer?

I have a client that wants me to build a SaaS application with a multi-tenant architecture, where different clients will go in a separate schema on the same db server. I have seen this architecture before, but never really used it, so I am quite new…
Martin Taleski
  • 179
  • 1
  • 4
7
votes
1 answer

If multitenancy is a priority, should I store site content in the database?

I have a multi tenant ASP.NET MVC website and all client specific text is stored in resource files. Every time someone wants to change text I have to jump through hoops and fill out forms and let someone else put it in production. This was fine…
Gary Green
  • 73
  • 3
6
votes
2 answers

Design question for handling large volumes of messages in multi-tenant queue

I have a system with two applications interacting via a message queue. Let's call them Producer and Consumer. Some key context is that this a multi-tenancy scenario. Producer produces events based on various inputs (user interactions, api, etc...)…
Taylor
  • 169
  • 4
6
votes
2 answers

Scalability: Millions of tables vs one big master table and millions of views

We have to migrate an old (million LOC) system from SAP ADS (formerly Sybase) ISAM based (so called free tables) based system to a PostgreSQL database. The system implements kind of multitenancy regarding putting some basic information (chancellery…
πάντα ῥεῖ
  • 1,540
  • 3
  • 12
  • 19
6
votes
2 answers

Composite-keys in multi-tenancy application for administrative actions

I've designed a single-instance database for a multi-tenant application which uses composite-keys to enforce tenant-segregation at the database-layer (thus preventing incorrect 3rd-degree relations). So the schema looks like this: TABLE Tenants ( …
Dai
  • 680
  • 4
  • 15
5
votes
1 answer

Using Redis as a cache in a Multi-Tenant application

I'm working on building a multi tenant application which relies on redis as a cache. I'm currently researching a feasible way to achieve multi tenancy with redis. I see that redis enterprise offers multi tenant support, however I'm looking to take…
Brad
  • 425
  • 6
  • 11
5
votes
4 answers

Multitenant app or separate instance for every customer

Suppose you are selling a web app. There is no data or operation that involves more than 1 customer. Each customer is totally separate. How would you prefer to make the deployments? 1) Deploy one instance for each customer, meaning you are running…
uylmz
  • 1,129
  • 1
  • 8
  • 17
4
votes
1 answer

Multi tenant in a micro-service

We are creating a SaaS multi-tenant (separate databases) with micro-service architecture, which causing a lot of discussion between me and my manager trying to determine if it needs to be multi-tenant or the databases can be related to the service…
Hamza Mohamed
  • 143
  • 5
4
votes
3 answers

Logical separation of database content

Background I have an application which stores a lot of entities in a classical relational database (Microsoft SQL Server) and I use an ORM (Entity Framework) to query data from it. This database has one schema any only a "global view" to this data…
Danielku15
  • 151
  • 1
  • 4
1
2 3 4 5 6