Anyone ever implement a SQL Server cluster that's controlled by CF? That is, CF can determine if a SQL Server is down and direct queries away from the failed server. best, paul At 06:20 PM 7/6/00 -0700, you wrote: >Your assessment is essentially correct. In my opinion, every serious >e-commerce site needs to be on at least two servers for fail-over. However, >many people put their database on one of their two clustered servers, >effectively defeating the purpose of the cluster if the server with SQL on >it fails. And if you have just one SQL server, where's the failover for >that? I have a presentation at http://www.sccfug.org on Scalability that >might show you some of the 'growing pains' most companies go through and how >you might address them. > >-----Original Message----- >From: Gregory Harris [mailto:[EMAIL PROTECTED]] >Sent: Thursday, July 06, 2000 10:19 AM >To: [EMAIL PROTECTED] >Subject: Slightly OT:Single Server vs. Cluster Comparison > > >Hello everyone, right now I've been assigned to do a comparison of a single >server vs. a multiple server configuration, this is what I've thought of so >far, can anyone help further? Need a few more brainstorms. > >Single: > >Advantages: > > Easier maintenance > Simpler setup > Cheaper > >Disadvantages: > > Less reliable (no fail-over) > Slower > >Multiple Server: > > Advantages: > > Faster throughput > Fail-over reliability > >Disadvantages: > > More complicated setup > Harder to maintain > > > >Gregory Harris >Los Angeles ITA Dept. >[EMAIL PROTECTED] > >---------------------------------------------------------------------------- >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >------------------------------------------------------------------------------ >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.