Thanks everyone. With the emphasis on moving everything to the cloud this type of capability is very desirable. Hibernate supports it. Jpa is making progress toward it.
I wish we could move to cayenne but I think we are going to get pushed to top link eventually. Dov Sent from my iPhone On Oct 19, 2012, at 9:51 AM, Andrus Adamchik <[email protected]> wrote: > Or use Cayenne 3.1 ;) > > On Oct 19, 2012, at 4:16 PM, Pascal Robert <[email protected]> wrote: > >> Check: >> >> https://github.com/hprange/multi-tenant-prototype >> >> I think Michael Gargano is using it with good success. Check the "model >> connections to multiple DBs" thread from April 2011 and "Different Database >> Connection per session for the same model" from June 2012. >> >>> 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/probert%40macti.ca >>> >>> This email sent to [email protected] >> >> >> _______________________________________________ >> 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/andrus%40objectstyle.org >> >> This email sent to [email protected] > > > _______________________________________________ > 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/dov%40cfl.rr.com > > This email sent to [email protected] _______________________________________________ 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]
