This is the first time I am trying to implement multi-tenant setup
under django and hence the question.
Problem/Setup
- There are two companies signed up for service from portal I am
developing say CompanyA, CompanyB.
- Each user with this setup is identified by unique email address,
users login using their email address and password.
- CompanyA has following users
A-tech1
A-tech2
A-tech3
- CompanyB has following users
B-tech1
B-tech2
B-tech3
Requirements:
1. Data security/isolation: Technician A-tech1, A-tech2, A-tech3
should only be able to view data associated with companyA. Same for
B-tech* technicians should only be able to see data from companyB.
2. Scalability: CompanyA, CompanyB might be of different sizes -
companyA might have 10 users. While CompanyB might have 10000s users
representing large customers.
3. SLA: There might be different service level agreement with companyA
& companyB.
I think, it doesn't make sense to lump data related to companyA, companyB
into same database.
Proposed Architecture Possibilities:
Path 1:
- system will use one replicated database for authentication/authorization
- When a company is registered within the system, 'Administrator' will
assign a company to specific database connection. And request will be
routed to correct database using database router, based on currently
logged in user.
See https://docs.djangoproject.com/en/dev/topics/db/multi-db/ for
multi-db applications under django.
Path 2:
Do the url based routing c1.company.com , c2.company.com in apache
server setup and let apache configuraion refer to different wsgi.py
scripts to set proper values for DJANGO_SETTING_MODULE. And each
settings file points to different databases.
Are either of these approaches (1 or 2) work better?
-Subodh
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CALr9Q3aDxvO1L8Ov9FHyUrQj%3Dr4bQURWQz%2Bz%3DZWreqyL9bptXQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
