By WalkingTree February 22, 2021
Many customers or tenants share the same application, running on the same operating system, hardware, and data-storage mechanism in a multitenancy architecture. Every tenant’s data is isolated and remains invisible to other tenants and very often Multi-tenancy is used by Software-as-a-Service (SaaS) applications.
Databases and Multi-tenancy – There are 3 types of databases in a multi-tenant architecture.
- One common database, one common schema: In one database and in common tables, everything is stored.
- One common database, different schema: Information from different clients is stored in different tables.
- Separate databases: The code is shared between clients, using common UI and business logic, and the data is shared among them.
Advantages of a multi-tenant architecture
- Cost Savings – The cost is shared, and the savings are transferred to the cost of the software.
- Data Aggregation – Instead of collecting data from multiple data sources, the data of all customers is stored in a single database schema.
- Release management simplification – The package only needs to be installed on a single server and the same software version is made available to all customers.
Disadvantages of a multi-tenant architecture
- Increased complexity of development – Applications need a larger development effort because of the additional customization.
- Limited customization: With no added integration benefits, custom changes to the database aren’t an option as it is shared between multiple users.
- Reduced security: Since multiple users are allowed on the same database, this broad access reduces security.
Read on to know more about Multi-tenant architecture and its use cases and real-world examples.
It is mind-boggling to see the scale at which the “Project Red Dog” or “Microsoft Azure” as we…
Problem statement Before the advent of Microservices, we used to create a properties files in which we maintained…
As we all know, Microservices brought in a paradigm shift in the way we think, design and architect…
In my recent articles, I covered the core building blocks of DevOps in Microservices and Pitfalls of each…
In my previous article, I covered the core building blocks of DevOps in Microservices environment. As part of…