Multi Tenancy

When we develop software which is applicable to multiple customers we need to consider Multitenant architecture. In Multi-tenancy, each customer is called a tenant.

Shared Database, Shared Schema
In this case, multiple tenants are using the same database and schema. Each table will have records from multiple tenants. A unique ID like Tenant ID relates every record with the particular tenant.

Sharing database with Separate Schemas
In this case, multiple tenants are in the same database, with each tenant having its own schema created specifically. Here database server, Database and Instance are shared.

Separate database for each tenant
In this case, only the database server resource can be shared. Each tenant has its own database. Banking Customers are mostly looking for the products with this option.

Key Benefits

  • It simplifies release management process and does not require having separate release for each customer until changes required in customized interfaces.
  • IT has ability to scale up easily. The scaling productivity depends upon the available resources.
  • Addition of new customer is economical.
  • Cost saving in terms of:
    • License Cost of software like OS, DBMS, etc.
    • Sharing of hardware resources

Related Posts



Contata Solutions announces Worbix Print

Contata Solutions announces Worbix Print, the company’s latest addition to its multi-channel distributed marketing service. With Worbix Print, content marketers can now plan and execute both digital and direct mail marketing programs using the same enterprise sponsored content. Enterprise marketing programs can be shared with regional and local franchises, realtors, agents and associations while enabling local personalization. […]



Contata chooses to standardize on Microsoft Azure

Contata has chosen to standardize on Microsoft Azure and Big Data platform to fuel its analytics business. In this fast-changing marketplace, it became clear to Contata that Microsoft is coming out on top in the world of analytics. While still able to do tech-agnostic work, Contata has made the overall strategic decision to standardize on the Microsoft[…]