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.
In the earlier blog we discussed Microservices Anatomy and talked about Why we need microservices What is microservices…
Overview Customer service rating plays an important role in determining user satisfaction with the company’s service. There are…
Problem Statement Typically, an enterprise application is often built using a three tier architecture: Client-side interface Server-side application…