The Power Of Cloud Computing: Multi-Tenant Database Architecture

Cloud Computing has Software as a Service (SaaS), which denotes a novel and innovative paradigm, and the fact that companies do not have to purchase and maintain their own Information Technology (ICT) infrastructure; instead services from third party are acquired. Multi-tenancy permits SaaS providers to provide similar service to various customers (tenants), which share physical and/or virtual resources transparently.

Multi-tenancy database architecture essentially forms a design in which a single instance of the software is run on the service provider’s infrastructure, and multiple tenants access the same instance. Simply put “A multi-tenant application lets customers (tenants) share the same hardware resources, by offering them one shared application and database instance, while allowing them to configure the application to fit their needs as if it runs on a dedicated environment”. One of the most conspicuous features of Multi-tenant architecture is that allows for consolidating multiple businesses onto the same operational platform or system. Multi-tenancy invariably takes place at the database layer of a service. For example, The Power Of Cloud Computing: Multi-Tenant Database Architecture as an analogy, think of a rental apartment building with numerous tenants, each having its own requirement of storage, space, and utilities.

Easier application deployment for service providers, improved rate of hardware utilization, and reduction in overall costs especially for SMEs are core benefits of Multi-tenant model. In traditional single-tenant software development, tenants usually have their own virtual server. This set-up is similar to the traditional Application Service Provider (ASP) model. However, in the SME segment, for instance, server utilization in such a model is low. By placing several tenants on the same server, the server utilization can be improved.

There different kinds of Multi-tenant models that exist in database applications today are as follows in The Power Of Cloud Computing:

1.   Separate application, separate database, and infrastructure (Isolated Tenancy)

2.   Separate application, separate database, shared infrastructure (Infrastructure Tenancy) in The Power Of Cloud Computing: Multi-Tenant Database Architecture

3.   Shared application separate database, shared infrastructure (Application Tenancy)

4.   Shared application, shared database, shared infrastructure (Shared Tenancy)

The figure below illustrates a high level architecture of Multi-tenancy. Multi-tenant approaches as a continuum paradigm. The far left (Isolated Tenancy) depicts each tenant with its own application instance running and as we move further towards the right, sharing of tenancy increases, ultimately reaching the far right side (Shared Tenancy)