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.
Every DevOps team, regardless of where or how DevOps is used, has a passion for enhancement at its…
“You can have data without information, but you cannot have information without data.” — Daniel Keys Moran In…
Extracting new insights from all your enterprise data is made easier with Amazon Redshift. Amazon’s Redshift is an…
Cloud costs are among the biggest investments these days for many organizations. Cloud cost optimization is becoming sensitive…