By WalkingTree February 22,  2021

Introduction to Multi-Tenant Architecture

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

  1. Cost Savings – The cost is shared, and the savings are transferred to the cost of the software.
  2. Data Aggregation – Instead of collecting data from multiple data sources, the data of all customers is stored in a single database schema.
  3. 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 

  1. Increased complexity of development – Applications need a larger development effort because of the additional customization.
  2. Limited customization: With no added integration benefits, custom changes to the database aren’t an option as it is shared between multiple users.
  3. 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.


Privacy Preferences
When you visit our website, it may store information through your browser from specific services, usually in form of cookies. Here you can change your privacy preferences. Please note that blocking some types of cookies may impact your experience on our website and the services we offer.