Peterson, Chris wrote: > Well, I am running SQL 2005 Std (which supports clustering), but I would > need another SQL 2005 Std license to do a true fault tolerant cluster.
How can you create a fault tolerant cluster with only 2 servers? If the 2 servers get out of sync due to a network issue, which one is authorative? What happens if they are both up and running, but they just can not see eachother anymore? If they continue to process transactions there is no way to guarantee that those transactions do not conflict. If they stop processing transactions your setup has only cost you reliability. And if a predefined master server continues to process transactions, you have gained nothing. Can a cluster reliably differentiate between a server down situation and an out of sync situation? The way I look at clustering of transactional processes, you need more then half of the servers running to have a quorum. That means that you need at least three servers so that there still is a quorum when the cluster is degraded. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

