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/archive%40mail-archive.com This email sent to [email protected]
