which approach to follow for SaaS + Multitenancy data?

Question

0.00/5 (No votes)

See more:

I have to build a .net application with SaaS + multi-Tenancy data. I need to know which of the Multi-tenancy approach is favorable in my case:
1) separate database, 2) shared database-separate schema, 3) shared database-shared schema.

In my data, I will be having around 1000 tenants, each tenant with maximum 100 users. There will be maximum 1400 transaction entries for each user every day.

Thanks.

Posted 20-Jan-14 1:40am

Member 10291320

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fixthebugg · Answer 1 · 2014-01-20T06:15:00

Solution 1

It all depends the what you needs and limitations are in terms of features, cost, supported programming models, performance, scalability, and reliability.Also have a look at tenant's Regulatory Considerations as a lot of government entities demand isolated storage. You have a lot of tenants so I think a more isolated approach will be better for you in general. Have a look at this http://msdn.microsoft.com/en-us/library/aa479086.aspx[^]

Posted 20-Jan-14 6:15am

fixthebugg

Comments

Member 10785115 28-Jan-16 10:51am

HI,
Already we have application using Asp.net with MVC and Sql server.We need to add multi-tenants concept on our existing application tomake cloud basis.we would like to use single instance for multiple tenants.Please assist us which is the best way to handle this.At present we dont have any clear idea on it.
Thanks
Sella