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.
Cloud costs are among the biggest investments these days for many organizations. Cloud cost optimization is becoming sensitive…
An integrated security practice within the DevOps process helps ongoing collaboration between engineers and security teams and build…
DevOps is the most recent tech absorption in enterprises with close sync between software development and IT operations…
Microsoft Ignite 2019 was a jam-packed event filled with many exciting announcements, news, shop floor demonstrations, developer sessions,…