If I have a web application and SQL database for an applicatoin, but I want to create 'isolation' between customers to give each customer their own instance of the application, what would you suggest?
1) One database and one web application, trying to separate customers by their customer ID to give each a look of their own app?
2) One database and one web application instance for each customer to truly make it easy on permissions and deployment?
3) A hybrid, such as one web app for all with one database per customer and change the connect string based on client.
#2 seems the easiest to truly isolate the client, but the most cumbersome to deploy and maintain.
Essentially, when building a SaaS platform to sign up customers, what would be a good way to host this?
agent_smith
Contributor
2030 Points
571 Posts
What would you suggest to host numerous instances of the same site?
Jan 17, 2013 03:04 PM|LINK
If I have a web application and SQL database for an applicatoin, but I want to create 'isolation' between customers to give each customer their own instance of the application, what would you suggest?
1) One database and one web application, trying to separate customers by their customer ID to give each a look of their own app?
2) One database and one web application instance for each customer to truly make it easy on permissions and deployment?
3) A hybrid, such as one web app for all with one database per customer and change the connect string based on client.
#2 seems the easiest to truly isolate the client, but the most cumbersome to deploy and maintain.
Essentially, when building a SaaS platform to sign up customers, what would be a good way to host this?
Thanks.
AGENT_SMITH
ignatandrei
All-Star
134521 Points
21576 Posts
Moderator
MVP
Re: What would you suggest to host numerous instances of the same site?
Jan 17, 2013 06:49 PM|LINK
Bet on 1)
agent_smith
Contributor
2030 Points
571 Posts
Re: What would you suggest to host numerous instances of the same site?
Jan 17, 2013 07:30 PM|LINK
Thanks, but would you care to elaborate?
AGENT_SMITH
ignatandrei
All-Star
134521 Points
21576 Posts
Moderator
MVP
Re: What would you suggest to host numerous instances of the same site?
Jan 18, 2013 09:10 AM|LINK
The simplest way is to add a "CustomerId" to all your tables.
Ruchira
All-Star
42888 Points
7020 Posts
MVP
Re: What would you suggest to host numerous instances of the same site?
Jan 20, 2013 04:03 PM|LINK
Hello,
What do you mean by 'isolation'?
Well, that sounds the best and easiest option.
You've given own answer as why option two is not good.
What are you trying to achieve by this? Why need that much complexity?
My Tech blog | My YouTube ChannelPlease 'Mark as Answer' if this post helps you.