Database Sharing Archives - https://blog.techcello.com/

Deciding your Data Isolation design in SaaS Model

April 9, 2014
Jothi Rengarajan
Multi Tenant Architecture, SaaS Architecture, SaaS Data Isolation
0 Comments

One common question raised while dealing with any SaaS architecture is “What kind of design should I follow for my Data isolation?” . Should I go for an isolated database for every customer or should there be a shared database / shared…

Database Sharding – Scaling data in a multi tenant environment

July 2, 2012
admin
Data Connection Abstraction, Multi Tenant Application Development, Performance, Scalability

A multi tenant SaaS product should be efficient enough to scale seamlessly without compromising on Reliability, Availability and Performance. Large scale applications which are built with the intention of handling thousands of users accessing in a concurrent fashion is to…

Tenant Based Indexing

June 11, 2012
admin
Cloud Ready Application Development, Multi Tenant Application Development, SaaS Application Development

A true Multi tenant SaaS application uses shared database with shared schema to achieve better cost efficiency and maintainability. But over a period of time when the application grows with 100s, or 1000s of tenants, the data stored in the database might also grow exponentially, due to which the application’s performance (while fetching the data) may slow down. Indexing the data might be a good option to improve the speed but it is also resource intensive. So what can we do to enhance the performance?