216 reputation
24
bio website
location India
age
visits member for 2 years, 8 months
seen Aug 14 at 6:50

Jun
24
awarded  Notable Question
May
5
awarded  Yearling
Nov
11
awarded  Nice Question
Mar
11
awarded  Popular Question
Apr
19
comment Handling growing number of Tenants in Multi-tenant Database Architecture
Thanks for sharing your experience.Indeed its enlightened me.Looking more on it. But u already wrote Non-free. :(
Apr
19
comment Handling growing number of Tenants in Multi-tenant Database Architecture
@AaronBertrand Its a Learning Management System where services will be partially free and partially paid.
Apr
19
comment Handling growing number of Tenants in Multi-tenant Database Architecture
Thank for the comments.Indeed the project is interesting. Due to the word limitation i vl keep the comment very precise. It is a Learning Management System where each tenant will going to have around 120-150 table.No user will have same username irrespective of Tenant. To further reduce the complexity DNS CNAME mapping will be used example tenant1.abc.com. Now the Boiling point is - designing it in correct manner so it will cater all suggestion you have shared and i am worrying for. Getting whitepaper will be praiseworthy but its not easy, perhaps.Looking more input if you can. !!!!
Apr
19
comment Handling growing number of Tenants in Multi-tenant Database Architecture
Thanks for the valuable comment. <br/>
Apr
19
asked Handling growing number of Tenants in Multi-tenant Database Architecture
Apr
18
revised Automation of backups of Large Number of Database
edited body
Apr
18
asked Automation of backups of Large Number of Database
Apr
18
comment Data Backup and Restoring the same if requried in SQL SERVER 2008
thanks for the comment. I am too in the favor of Tenant based database. But I am confuse how to handle authentication authorization if database is isolated, in Single Instance Web application for multiple isolated tenant db.
Apr
18
comment Data Backup and Restoring the same if requried in SQL SERVER 2008
Thanks for the suggestion. But do you think it will be right approach as the number of tenant will be more than 10,000. Taking backup of all the tenant and if required restoring the tenant data say tenant no 267 among 10,000 tenants for more than 150 tables for each tenant.
Apr
18
asked Data Backup and Restoring the same if requried in SQL SERVER 2008
Mar
30
awarded  Editor
Mar
30
awarded  Student