Maybe a stupid question: Why not maintain the single codebase, single cluster shared by all users, AND have a seperate DB for each organisation.
e.q. request.dsn = config.findDSNByOrganisation(cgi.http_host) Best of both worlds? Clustered failover: YES Single codebase to maintain: YES Seperate data storage for each organisation: YES On 09/02/2008, markireland <[EMAIL PROTECTED]> wrote: > > > This question was asked on cfAussie: > > situation: > > in our business, we do partnership deals with other organisations who > we license resources to and then finalise their output on their behalf > on our IT systems. we're looking at providing the tools for our > partners to logon and use to complete the middle part of the process. > There's about 20-30 partners. These "tools" will never be outside our > control (ie not on partners servers) and won't be individually > customised outside some basic settings (no forking of the code) > > OK > > I'll only have two ColdFusion 8 Enterprise server boxes to do this > (plus separate DB servers), at least to start with. > > either > > - I run all the customers out of one instance of the application and > use their OrganisationID to differentiate each partner - sometimes > right down to the individual database row level, all in one db. > - cluster both boxes and add a hardware load balancer in front of > them > - additional partners means adding another server into the cluster > - I gain on fail-over but lose on application design. > > or > > - I run each partner as a seperate CF8 instance off the same > codebase, forget about the OrganisationID, and use each instance's > CFIDE to point the DSN to the corresponding matching database - one > for each partner > - don't bother clustering but try and spread the load by grouping > customers > - additional customers means adding another server to put the new > customers on > - I have no fail-over but it's a lot cleaner as far as rolling out > new customers. > > any other options? > > any suggestions? > > many thanks > b > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
