Multi-tenancy is an architecture in which a single circumstances of a software application or application servers numerous consumers. Here each consumer is an occupant. Renters might have the capabilities to personalize some parts of the application, such as UI color, logo design, business name, address etc. However occupant can’t customize the application’s code.

In this architecture numerous circumstances of an application run in a shared environment. Each occupant is incorporated physically, however apart rationally. This kinds of architecture is utilized to make it possible for numerous users to utilize a single application.

Multi-tenant architecture is utilized most with cloud computing. It is discovered in both public cloud (such as Amazon Web Solutions, Microsoft Azure and Google Cloud) and personal cloud. Likewise it is a crucial part of another cloud design, software application as a service (SaaS).

Multi-tenant Database

In multi-tenant architecture database is really concern. There are 3 methods we can develop our database in multi-tenant system, with various intricacy and expense.

Single database, shared schema

In this system one database is utilized to hold all the occupant’s information. Every occupant’s information is kept in the exact same table. Each table has a particular column that determine occupant’s row. Select operation is pricey, customize schema is simple & & low pricey.

Single database, different schema

In this system one database is utilized to hold all the occupant’s information. Each occupant information is kept in the different table.

Database per occupant

In this system each occupant has their own database.