We are looking into converting our existing EOF based apps to support 
multi-tenancy. Today we can support multiple customers in a single schema using 
relationships to separate the data. EOF works fine in this model. We even 
implemented the multiple EOObjectStore coordinators for additional scalability.

Has anyone figured out how to support separate schema based multi-tenancy with 
EOF? i.e. each customer gets a separate schema and requests for that customer 
load data from that schema only? I know we can deploy our app multiple times - 
each time pointing to a different schema. Ideally though we would be able to 
share binaries and swap schemas on a per request basis.

I am thinking some mojo would have to occur along the lines of the following:

Load the EOModel once - this assumes that all customers would share the same DB 
structure
DO NOT pre-load any data at start up unless it is stored in per customer caches
As each request comes in - 
identify the customer
either create a new connection or grab one from a pool. In the case of EOF I 
think that implies that there would be separate object store coordinators per 
customer
Hook the object store up with the model
execute the request
break everything back down

Is this even possible with EOF/Project Wonder?

Thanks

Dov Rosenberg
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to