Re: Multi-Tenant Data Architecture
Re: Multi-Tenant Data Architecture
- Subject: Re: Multi-Tenant Data Architecture
- From: Klaus Berkling <email@hidden>
- Date: Wed, 23 Sep 2009 08:13:53 -0700
FWIW
We uses an setup were access is organized by groups, sub-groups and
sub-sub-groups, etc.
We have sales reps which manage channel partners, which manage clients
or schools. In the schools are more groups. These are all group
objects.
There are classes that relate to groups, students are related to one
or more class. All the groups are in one table, then there is a
classes table and students table.
The groups are the your tenants. One of our sites has 35819 groups.
A user is assigned a group and when the user logges into their group
they are given a list of their sub-groups. Users are never aware of
their login group, their parent groups or any other group above that.
We keep track of their login group in the session.
There are certain safe-guards to block exposing objects who's group
relationship is not a child of the users' login group.
This seems to work pretty well.
Issues arise when doing searches for data in a table that's shared
with multiple tenants. A tenant should not take the penalty for
someone else's large data set. There is a performance hit when
combining the database your searching through with the group the
tenant belongs to. If you have large tenants you'll need to considere
getting them their own server, or at least their own instance(s)
+database.
Thanks
kib
"We keep moving forward, opening new doors, and doing new things,
because we're curious and curiosity keeps leading us down new paths."
Walt Disney
Klaus Berkling
Web Application Dev. & Systems Administrator
DynEd International, Inc.
www.dyned.com | www.eskimo.com/~kiberkli
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden