RE: Server Cluster
To chime in on this: I don't believe you would need to purchase multiple copies of CF for virtualized servers, only one per *physical* server, with up to 2 max CPU's. Since the license for CF is for 1-2 CPU's, running it on an unlimited number of VM's residing on a single physical server (dual CPU dual or quad core) would still conform to the license. Of course, you would need to go beefy to properly support anything more than 2 - 3 instances of windows / CF, but 8 gigs of ram would be cheaper than 4 copies of CF Enterprise =) With your example, run 4 virtual servers on a dual CPU quad core system, and software licensing would be (4) windows at $2000 and 1 CF enterprise at $6000. Also, I believe the next version of Windows server will support 'virtualized' instances right out of the box, and would share the same OS code for each virtual machine. This would remove the necessity for multiple windows instances. I really think virtual servers sharing a license would be the way to go for CF hosting I think, have a beefy machine with relatively small VM's so each user has a 'dedicated' server to play with, and pay for only 1 CF license =) Chris Peterson Nathan Strutz wrote: > First off, licensing - windows 2003 web edition costs around $500 last I > checked, though I don't track the virtualization pricing schemes. ColdFusion > Standard edition is about $1300 and ColdFusion Enterprise weighs in at > $6000. CF is always licensed to physical CPU pairs (dual cores count as 1 > CPU). > > To go the CF Enterprise way, If you have 4 servers, 2 processors each, > you'll buy 4 Windows licenses, and 4 CF enterprise licenses. - cost: > $26,000. ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server Cluster
To chime in on this: I don't believe you would need to purchase multiple copies of CF for virtualized servers, only one per *physical* server, with up to 2 max CPU's. Since the license for CF is for 1-2 CPU's, running it on an unlimited number of VM's residing on a single physical server (dual CPU dual or quad core) would still conform to the license. Of course, you would need to go beefy to properly support anything more than 2 - 3 instances of windows / CF, but 8 gigs of ram would be cheaper than 4 copies of CF Enterprise =) Chris Peterson -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 5:28 PM To: CF-Talk Subject: Re: Server Cluster Nathan Strutz wrote: > Contrary to some of the other opinions in this thread, I think that getting > windows in multiple VMs is a better way to go than getting CF on multiple > JVMs, and I have a fair amount of experience to back that up. Depends on the purpose. Let me counter by complementing your example with what it actually means for for instance PDF generation. > First off, licensing - windows 2003 web edition costs around $500 last I > checked, though I don't track the virtualization pricing schemes. ColdFusion > Standard edition is about $1300 and ColdFusion Enterprise weighs in at > $6000. CF is always licensed to physical CPU pairs (dual cores count as 1 > CPU). > > To go the CF Enterprise way, If you have 4 servers, 2 processors each, > you'll buy 4 Windows licenses, and 4 CF enterprise licenses. - cost: > $26,000. And you can run PDF generation in unlimited threads on them. I would not recommend more then 4 threads per core, so with 8 CPUs / 16 cores this amounts to 64 threads. > To go the virtualized server way, say you want to run 2 windows servers per > box - only 4 servers so 4 CF Standard licenses, but 8 windows licenses, > total cost: $9,200. Then there's the cost of the VM software, which I don't > know about, I've heard you can do it for free. With 4 CF Standard license you get 4 threads to generate PDFs. So for three times the cost you get 16 times the performance. I think CF Enterprise is a pretty good deal :) > If you are clustering the JRun servers, there is a lot of confusion over > exactly what that does - a request onto one web server could be serviced by > either JRun server. One JRun server sets itself up to be primary, and if > taken offline, the cluster then fails and requests are serviced by no one. That is not my experience. The worst case scenario I have seen is that under some failure scenario's (which are all failure scenario's outside of JRun so that would also affect other solutions) failover takes 2 MSL (and that should be configurable). > Session sharing is especially painful, especially if you carry a fair amout > of data and have tens of thousands of users, no gigabit network can carry > that much bandwidth, add another server and the bandwidth requirements > increase exponentially. Make sure the servers can use multicast and the bandwidth requirements don't increase. > If you have a network load balancer that sends requests to different web > servers and keeps users stuck to a particular server (except on failovers), > you should have those servers servicing their own requests. If you need to > tack data to a user, you can save it in session but don't replicate it - put > an ID in a cookie and tie it to a database record, that way, it's in quick > session memory, and if the server crashes, you can bring it back out on > demand. Replace "ID in a cookie" with "HTTP authentication" and you have my preferred setup :) > Now back to stability, if one JVM crashes on one server, there's a > better-than-you-think chance of it hurting the whole server. More often than > not, I've had to reboot an entire server because one CF instance had > problems. If independent processes affect eachother there is a problem with the OS. Jochem ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Cluster
Jochem, The PDF example is great. I'm not against CF Enterprise whatsoever, it's the best way to go, and I do whatever I can to look for reasons to recommend it for things like that. I just think it's over-prescribed and often misunderstood. > Now back to stability, if one JVM crashes on one server, there's a > > better-than-you-think chance of it hurting the whole server. More often > than > > not, I've had to reboot an entire server because one CF instance had > > problems. > > If independent processes affect eachother there is a problem with the OS. > Well, I said I was using Windows, didn't I. All joking aside, it's usually a resource contention issue, other processes on the box run out of resources. Admittedly, I'm quicker to reboot than I should be ;) -- nathan strutz http://www.dopefly.com/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Cluster
Nathan Strutz wrote: > Contrary to some of the other opinions in this thread, I think that getting > windows in multiple VMs is a better way to go than getting CF on multiple > JVMs, and I have a fair amount of experience to back that up. Depends on the purpose. Let me counter by complementing your example with what it actually means for for instance PDF generation. > First off, licensing - windows 2003 web edition costs around $500 last I > checked, though I don't track the virtualization pricing schemes. ColdFusion > Standard edition is about $1300 and ColdFusion Enterprise weighs in at > $6000. CF is always licensed to physical CPU pairs (dual cores count as 1 > CPU). > > To go the CF Enterprise way, If you have 4 servers, 2 processors each, > you'll buy 4 Windows licenses, and 4 CF enterprise licenses. - cost: > $26,000. And you can run PDF generation in unlimited threads on them. I would not recommend more then 4 threads per core, so with 8 CPUs / 16 cores this amounts to 64 threads. > To go the virtualized server way, say you want to run 2 windows servers per > box - only 4 servers so 4 CF Standard licenses, but 8 windows licenses, > total cost: $9,200. Then there's the cost of the VM software, which I don't > know about, I've heard you can do it for free. With 4 CF Standard license you get 4 threads to generate PDFs. So for three times the cost you get 16 times the performance. I think CF Enterprise is a pretty good deal :) > If you are clustering the JRun servers, there is a lot of confusion over > exactly what that does - a request onto one web server could be serviced by > either JRun server. One JRun server sets itself up to be primary, and if > taken offline, the cluster then fails and requests are serviced by no one. That is not my experience. The worst case scenario I have seen is that under some failure scenario's (which are all failure scenario's outside of JRun so that would also affect other solutions) failover takes 2 MSL (and that should be configurable). > Session sharing is especially painful, especially if you carry a fair amout > of data and have tens of thousands of users, no gigabit network can carry > that much bandwidth, add another server and the bandwidth requirements > increase exponentially. Make sure the servers can use multicast and the bandwidth requirements don't increase. > If you have a network load balancer that sends requests to different web > servers and keeps users stuck to a particular server (except on failovers), > you should have those servers servicing their own requests. If you need to > tack data to a user, you can save it in session but don't replicate it - put > an ID in a cookie and tie it to a database record, that way, it's in quick > session memory, and if the server crashes, you can bring it back out on > demand. Replace "ID in a cookie" with "HTTP authentication" and you have my preferred setup :) > Now back to stability, if one JVM crashes on one server, there's a > better-than-you-think chance of it hurting the whole server. More often than > not, I've had to reboot an entire server because one CF instance had > problems. If independent processes affect eachother there is a problem with the OS. Jochem ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server Cluster
Contrary to some of the other opinions in this thread, I think that getting windows in multiple VMs is a better way to go than getting CF on multiple JVMs, and I have a fair amount of experience to back that up. First off, licensing - windows 2003 web edition costs around $500 last I checked, though I don't track the virtualization pricing schemes. ColdFusion Standard edition is about $1300 and ColdFusion Enterprise weighs in at $6000. CF is always licensed to physical CPU pairs (dual cores count as 1 CPU). To go the CF Enterprise way, If you have 4 servers, 2 processors each, you'll buy 4 Windows licenses, and 4 CF enterprise licenses. - cost: $26,000. To go the virtualized server way, say you want to run 2 windows servers per box - only 4 servers so 4 CF Standard licenses, but 8 windows licenses, total cost: $9,200. Then there's the cost of the VM software, which I don't know about, I've heard you can do it for free. These are in no way real numbers, and i'm not sure if you can put windows web server edition on a virtual machine, so your mileage may vary. So I would argue the price is better with multiple virtual servers over multiple virtual machines. Next, the stability factor. I've run a lot of CF enterprise servers, installing, configuring different types of clustering, managing the servers and the applications, and developing the appilcations, I'd say about 40 in the last 5 years for a handful of different companies. Each time, the results haven't been 100% what we wanted out of the setup. If you are clustering the JRun servers, there is a lot of confusion over exactly what that does - a request onto one web server could be serviced by either JRun server. One JRun server sets itself up to be primary, and if taken offline, the cluster then fails and requests are serviced by no one. Session sharing is especially painful, especially if you carry a fair amout of data and have tens of thousands of users, no gigabit network can carry that much bandwidth, add another server and the bandwidth requirements increase exponentially. Furthermore, until the release of CF8, CFCs are not replicated safely. If you have a network load balancer that sends requests to different web servers and keeps users stuck to a particular server (except on failovers), you should have those servers servicing their own requests. If you need to tack data to a user, you can save it in session but don't replicate it - put an ID in a cookie and tie it to a database record, that way, it's in quick session memory, and if the server crashes, you can bring it back out on demand. (i've been meaning to blog this subject) Now back to stability, if one JVM crashes on one server, there's a better-than-you-think chance of it hurting the whole server. More often than not, I've had to reboot an entire server because one CF instance had problems. It would be much safer to keep the instances even more isolated - on their own virtual server. Anyways, it's just my opinion, but like I've said, I've done this a few times. -- nathan strutz http://www.dopefly.com/ On 6/11/07, James Smith <[EMAIL PROTECTED]> wrote: > > I am thinking of setting up a virtual cluster to run our website for > reliability reasons. Does anyone have any good documentation > (preferably in a PDF or other offline readable format) in the form of > a beginners guide to CF clusters? > > Also, what is the licencing requirement for this, I am aware I can use > the same copy of Windows Server in multiple virtual machines but will > each one require it's own CF licence or can they share a licence since > they run on the same processor(s)? > > -- > Jay > > > ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
> One limitation on the number of jrun instances on windows is > the maximum limitation in jre of 1gb memory (from memory this > is the limit - could be more perhaps) allocation to Java. So > if each take 250mb of ram, then you are limited at 4 instances. That limit is per-instance. Each instance runs within a separate JVM. So, if you could allocate 4 GB of RAM to your instances, you could run 4 instances, each with 1 GB. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Cluster
I have been through several set ups recently, the latest is 2 physical servers with a cisco pix load balancer with no sticky sessions. we then run 2 jrun instances for the production app on each box. Provides great stability. One limitation on the number of jrun instances on windows is the maximum limitation in jre of 1gb memory (from memory this is the limit - could be more perhaps) allocation to Java. So if each take 250mb of ram, then you are limited at 4 instances. On 6/12/07, James Smith <[EMAIL PROTECTED]> wrote: > so would you recomend one server with multiple jrun instances or multiple > virtual servers with one on each? > > On 11/06/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > > > To answer one of your many questions. You will need CF Enterprise. Once > > you have obtained the appropriate license for each physical server (and > > all their processors) you can add as many CF instances as you want. > > Each of them belonging to one big cluster or several smaller clusters. > > You name it-- there are no restrictions on the number or configuration > > of your clusters. > > > > There are several adobe technotes and blogs about setting up clusters. > > I found most of them through people on this list and Google though I > > don't remember there being any one definitive document that answered all > > my questions. > > > > ~Brad > > > > > > Also, what is the licencing requirement for this, I am aware I can use > > the same copy of Windows Server in multiple virtual machines but will > > each one require it's own CF licence or can they share a licence since > > they run on the same processor(s)? > > > > -- > > Jay > > > > > > > > > > > > ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
> -Original Message- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: Monday, June 11, 2007 5:51 PM > To: CF-Talk > Subject: Re: Server Cluster > > > Actually, you can't just use the same copy of Windows Server in multiple > > virtual machines. Microsoft has a VM licensing calendar here: > > > http://www.microsoft.com/windowsserver2003/howtobuy/licensing/calculator.m > sp > > x > > Good catch, I would have missed that. > This is weird. I remember reading somewhere that an Enterprise version of Windows lets you run unlimited virtual instances on one physical machine. According to this, you need the datacenter edition. Does anyone else remember reading what I did? Russ ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
Dang it-- I keep thinking of addendums... To clarify, when I said that JRUN clusters are non-aware I meant they don't/can't distribute load based on things like CPU utilization, free memory or other application/OS metrics. JRUN clustering IS smart enough however to know if an instance is up or down. Other than that, it is just round robin variants. You have to go to hard ware balancing to get granular control over that other stuff. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 5:33 PM To: CF-Talk Subject: RE: Server Cluster I guess that being said, I should add that for true high availability and fail-over you would want to have at least 2 physical servers in some sort of load-balanced config in case of a hardware failure. Note that in a cluster (which can include instances across multiple physical servers) your JRUN connectors provide (non-aware) balancing between a web server (IIS/Apache) and your cluster (application server). If you have multiple web servers you still will need some sort of load-balancing between your users and them. I guess at some point you have to ask yourself if you are just looking for an easy way to distribute your processing or if 99.999% uptime and fail over for every single possible single point of failure is a requirement. ~Brad ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
I guess that being said, I should add that for true high availability and fail-over you would want to have at least 2 physical servers in some sort of load-balanced config in case of a hardware failure. Note that in a cluster (which can include instances across multiple physical servers) your JRUN connectors provide (non-aware) balancing between a web server (IIS/Apache) and your cluster (application server). If you have multiple web servers you still will need some sort of load-balancing between your users and them. I guess at some point you have to ask yourself if you are just looking for an easy way to distribute your processing or if 99.999% uptime and fail over for every single possible single point of failure is a requirement. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 5:15 PM To: CF-Talk Subject: RE: Server Cluster I would definitely recommend having multiple JRUN instances of CF on a single OS. If you have crazy code it's just going to take down one instance. Generally I don't think CF servers crash due to OS instability. Why waste the overhead of windows times 5? ~Brad -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 4:44 PM To: CF-Talk Subject: Re: Server Cluster so would you recomend one server with multiple jrun instances or multiple virtual servers with one on each? ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Server Cluster
I would definitely recommend having multiple JRUN instances of CF on a single OS. If you have crazy code it's just going to take down one instance. Generally I don't think CF servers crash due to OS instability. Why waste the overhead of windows times 5? ~Brad -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 4:44 PM To: CF-Talk Subject: Re: Server Cluster so would you recomend one server with multiple jrun instances or multiple virtual servers with one on each? ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Cluster
> Actually, you can't just use the same copy of Windows Server in multiple > virtual machines. Microsoft has a VM licensing calendar here: > http://www.microsoft.com/windowsserver2003/howtobuy/licensing/calculator.msp > x Good catch, I would have missed that. > As for CF, though, it's licensed per two physical processors, so there's no > limitation as far as installing it into multiple VMs. However, if your goal > is purely reliability of your site, instead of using multiple VMs you might > just want to set up multiple instances of CF within a single physical OS > instance per physical server. So I can have as many instances as I like so long as they are all on the 2 processors, that may be a better option then since reliability and up time is my only concern here. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Server Cluster
so would you recomend one server with multiple jrun instances or multiple virtual servers with one on each? On 11/06/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > To answer one of your many questions. You will need CF Enterprise. Once > you have obtained the appropriate license for each physical server (and > all their processors) you can add as many CF instances as you want. > Each of them belonging to one big cluster or several smaller clusters. > You name it-- there are no restrictions on the number or configuration > of your clusters. > > There are several adobe technotes and blogs about setting up clusters. > I found most of them through people on this list and Google though I > don't remember there being any one definitive document that answered all > my questions. > > ~Brad > > > Also, what is the licencing requirement for this, I am aware I can use > the same copy of Windows Server in multiple virtual machines but will > each one require it's own CF licence or can they share a licence since > they run on the same processor(s)? > > -- > Jay > > > > > ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
> I am thinking of setting up a virtual cluster to run our > website for reliability reasons. Does anyone have any good > documentation (preferably in a PDF or other offline readable > format) in the form of a beginners guide to CF clusters? There's plenty of stuff in the documentation itself, as well as Adobe Devnet. > Also, what is the licencing requirement for this, I am aware > I can use the same copy of Windows Server in multiple virtual > machines but will each one require it's own CF licence or can > they share a licence since they run on the same processor(s)? Actually, you can't just use the same copy of Windows Server in multiple virtual machines. Microsoft has a VM licensing calendar here: http://www.microsoft.com/windowsserver2003/howtobuy/licensing/calculator.msp x As for CF, though, it's licensed per two physical processors, so there's no limitation as far as installing it into multiple VMs. However, if your goal is purely reliability of your site, instead of using multiple VMs you might just want to set up multiple instances of CF within a single physical OS instance per physical server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Cluster
To answer one of your many questions. You will need CF Enterprise. Once you have obtained the appropriate license for each physical server (and all their processors) you can add as many CF instances as you want. Each of them belonging to one big cluster or several smaller clusters. You name it-- there are no restrictions on the number or configuration of your clusters. There are several adobe technotes and blogs about setting up clusters. I found most of them through people on this list and Google though I don't remember there being any one definitive document that answered all my questions. ~Brad Also, what is the licencing requirement for this, I am aware I can use the same copy of Windows Server in multiple virtual machines but will each one require it's own CF licence or can they share a licence since they run on the same processor(s)? -- Jay ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Server Cluster
I am thinking of setting up a virtual cluster to run our website for reliability reasons. Does anyone have any good documentation (preferably in a PDF or other offline readable format) in the form of a beginners guide to CF clusters? Also, what is the licencing requirement for this, I am aware I can use the same copy of Windows Server in multiple virtual machines but will each one require it's own CF licence or can they share a licence since they run on the same processor(s)? -- Jay ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Optimal CF Server settings w/SQL Server Cluster
Weird coincidence but we just ran into this exact problem with an Oracle cluster. One of the cluster members experienced hardware problems and it failed over to another cluster member...and CFMX DB connections hung. Stace _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 4:21 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster > Dave thanks for the input. My dba tells me that the SQL > Server cluster is an active-active so your were right in that > aspect. Do you know why the queries would get queued up after > a fail-over? Is there any way to force the connections to be > killed maybe from the database side to force CF to recreate these? Unfortunately, I don't know that much about SQL Server clustering. According to this MS article, it's up to the client application to close connections: http://support.microsoft.com/default.aspx?scid=kb;en-us;273673&Product=s ql2k Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
Dave thanks again. I think this will do the trick. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 3:10 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster > That is along the line of where I'm going. Do you know how to > programmically flush the DB connections. In CF 5 administrator > there is a button to flush all DB connections. I haven't seen > this in MX administrator. Does this mean there was an unpubished > tag to do this and if so is it still there in MX? I think you could do this using the ServiceFactory interface in MX: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 (courtesy of Jochem) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
> That is along the line of where I'm going. Do you know how to > programmically flush the DB connections. In CF 5 administrator > there is a button to flush all DB connections. I haven't seen > this in MX administrator. Does this mean there was an unpubished > tag to do this and if so is it still there in MX? I think you could do this using the ServiceFactory interface in MX: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 (courtesy of Jochem) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
> Ok I gotcha...how about catching the specific exception > raised when the DB does its switchover and manually flush > DB connections? I think the problem here is that you don't want to wait for the duration of a database connection timeout. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
That is along the line of where I'm going. Do you know how to programmically flush the DB connections. In CF 5 administrator there is a button to flush all DB connections. I haven't seen this in MX administrator. Does this mean there was an unpubished tag to do this and if so is it still there in MX? -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 2:43 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster Ok I gotcha...how about catching the specific exception raised when the DB does its switchover and manually flush DB connections? Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:54 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster Stace, It's my understanding the the MS SQL Server cluster does this for you. Althought each of the individual servers have their own set of IP addresses. A virtual SQL Server is also created with it's own ip. All the CF Servers are pointed to the virtual SQL Server. When a SQL Server fail over occurs the CF Servers continue to communicate to the database through the same ip addresss. So therefore a seperate VLAN to achive the same thing shouldn't be needed. I may be wrong though? I suspect if I wait for the five minute timeout to occur the old connections will get killed and new ones will be created which would then work without a hitch. I can't afford the 5 minutes of dead time though. I am wondering how much of a savings Maintain Connections provides and whether we should just nix that options which should solve the problem. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 11:35 AM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster I'm no expert in this area but if by chance you have switching capabilities in your topology (Alteon or what-not)...create a vlan for the database cluster and expose that to the CF servers via a single network address. That way CF is always bound to a static virtual server address...no matter which database cluster member is operating behind the scenes. Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:30 PM To: CF-Talk Subject: Optimal CF Server settings w/SQL Server Cluster I have a few questions regarding server settings in the following environement: CF 5.0 cluster with 5 servers in the farm MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over The application gets about 7 million page impressions per day I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters. -Peter Amiri [EMAIL PROTECTED] MySpace.com _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
Ok I gotcha...how about catching the specific exception raised when the DB does its switchover and manually flush DB connections? Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:54 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster Stace, It's my understanding the the MS SQL Server cluster does this for you. Althought each of the individual servers have their own set of IP addresses. A virtual SQL Server is also created with it's own ip. All the CF Servers are pointed to the virtual SQL Server. When a SQL Server fail over occurs the CF Servers continue to communicate to the database through the same ip addresss. So therefore a seperate VLAN to achive the same thing shouldn't be needed. I may be wrong though? I suspect if I wait for the five minute timeout to occur the old connections will get killed and new ones will be created which would then work without a hitch. I can't afford the 5 minutes of dead time though. I am wondering how much of a savings Maintain Connections provides and whether we should just nix that options which should solve the problem. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 11:35 AM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster I'm no expert in this area but if by chance you have switching capabilities in your topology (Alteon or what-not)...create a vlan for the database cluster and expose that to the CF servers via a single network address. That way CF is always bound to a static virtual server address...no matter which database cluster member is operating behind the scenes. Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:30 PM To: CF-Talk Subject: Optimal CF Server settings w/SQL Server Cluster I have a few questions regarding server settings in the following environement: CF 5.0 cluster with 5 servers in the farm MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over The application gets about 7 million page impressions per day I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters. -Peter Amiri [EMAIL PROTECTED] MySpace.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
Dave thanks for the link to the article. What I'm going to do is keep the Maintain Connection on and set a 5 minute time out. But I'll create a probe that does a simple DB query and set it to run every minute. If the probe fails, I'll recycle the CF server to clear the database connections. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 1:21 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster > Dave thanks for the input. My dba tells me that the SQL > Server cluster is an active-active so your were right in that > aspect. Do you know why the queries would get queued up after > a fail-over? Is there any way to force the connections to be > killed maybe from the database side to force CF to recreate these? Unfortunately, I don't know that much about SQL Server clustering. According to this MS article, it's up to the client application to close connections: http://support.microsoft.com/default.aspx?scid=kb;en-us;273673 &Product=sql2k Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
> Dave thanks for the input. My dba tells me that the SQL > Server cluster is an active-active so your were right in that > aspect. Do you know why the queries would get queued up after > a fail-over? Is there any way to force the connections to be > killed maybe from the database side to force CF to recreate these? Unfortunately, I don't know that much about SQL Server clustering. According to this MS article, it's up to the client application to close connections: http://support.microsoft.com/default.aspx?scid=kb;en-us;273673&Product=sql2k Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
Dave thanks for the input. My dba tells me that the SQL Server cluster is an active-active so your were right in that aspect. Do you know why the queries would get queued up after a fail-over? Is there any way to force the connections to be killed maybe from the database side to force CF to recreate these? -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 12:24 PM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster > It's my understanding the the MS SQL Server cluster does this > for you. Althought each of the individual servers have their > own set of IP addresses. A virtual SQL Server is also created > with it's own ip. All the CF Servers are pointed to the > virtual SQL Server. When a SQL Server fail over occurs the CF > Servers continue to communicate to the database through the > same ip addresss. So therefore a seperate VLAN to achive the > same thing shouldn't be needed. I may be wrong though? No, I think you're right, if your SQL Server cluster is set up as "active-active". You should be addressing the cluster itself, not any individual server in the cluster. > I suspect if I wait for the five minute timeout to occur the > old connections will get killed and new ones will be created > which would then work without a hitch. I can't afford the 5 > minutes of dead time though. I am wondering how much of a > savings Maintain Connections provides and whether we should > just nix that options which should solve the problem. You might consider shortening the time a database connection is maintained. Maintaining connections does make a pretty big difference with SQL Server, in my experience. I'd also be concerned if one of your database cluster members is failing frequently, though - I think that SQL Server's clustering ability is more useful for load-balancing than it is for failover. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
> It's my understanding the the MS SQL Server cluster does this > for you. Althought each of the individual servers have their > own set of IP addresses. A virtual SQL Server is also created > with it's own ip. All the CF Servers are pointed to the > virtual SQL Server. When a SQL Server fail over occurs the CF > Servers continue to communicate to the database through the > same ip addresss. So therefore a seperate VLAN to achive the > same thing shouldn't be needed. I may be wrong though? No, I think you're right, if your SQL Server cluster is set up as "active-active". You should be addressing the cluster itself, not any individual server in the cluster. > I suspect if I wait for the five minute timeout to occur the > old connections will get killed and new ones will be created > which would then work without a hitch. I can't afford the 5 > minutes of dead time though. I am wondering how much of a > savings Maintain Connections provides and whether we should > just nix that options which should solve the problem. You might consider shortening the time a database connection is maintained. Maintaining connections does make a pretty big difference with SQL Server, in my experience. I'd also be concerned if one of your database cluster members is failing frequently, though - I think that SQL Server's clustering ability is more useful for load-balancing than it is for failover. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
Stace, It's my understanding the the MS SQL Server cluster does this for you. Althought each of the individual servers have their own set of IP addresses. A virtual SQL Server is also created with it's own ip. All the CF Servers are pointed to the virtual SQL Server. When a SQL Server fail over occurs the CF Servers continue to communicate to the database through the same ip addresss. So therefore a seperate VLAN to achive the same thing shouldn't be needed. I may be wrong though? I suspect if I wait for the five minute timeout to occur the old connections will get killed and new ones will be created which would then work without a hitch. I can't afford the 5 minutes of dead time though. I am wondering how much of a savings Maintain Connections provides and whether we should just nix that options which should solve the problem. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 11:35 AM To: CF-Talk Subject: RE: Optimal CF Server settings w/SQL Server Cluster I'm no expert in this area but if by chance you have switching capabilities in your topology (Alteon or what-not)...create a vlan for the database cluster and expose that to the CF servers via a single network address. That way CF is always bound to a static virtual server address...no matter which database cluster member is operating behind the scenes. Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:30 PM To: CF-Talk Subject: Optimal CF Server settings w/SQL Server Cluster I have a few questions regarding server settings in the following environement: CF 5.0 cluster with 5 servers in the farm MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over The application gets about 7 million page impressions per day I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters. -Peter Amiri [EMAIL PROTECTED] MySpace.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Optimal CF Server settings w/SQL Server Cluster
I'm no expert in this area but if by chance you have switching capabilities in your topology (Alteon or what-not)...create a vlan for the database cluster and expose that to the CF servers via a single network address. That way CF is always bound to a static virtual server address...no matter which database cluster member is operating behind the scenes. Stace _ From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: December 1, 2003 2:30 PM To: CF-Talk Subject: Optimal CF Server settings w/SQL Server Cluster I have a few questions regarding server settings in the following environement: CF 5.0 cluster with 5 servers in the farm MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over The application gets about 7 million page impressions per day I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters. -Peter Amiri [EMAIL PROTECTED] MySpace.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Optimal CF Server settings w/SQL Server Cluster
I have a few questions regarding server settings in the following environement: CF 5.0 cluster with 5 servers in the farm MS SQL Server cluster - Raid 10 array connected to both servers with hot fail over The application gets about 7 million page impressions per day I want to what the optimal settings should be for data sources settings. In particular Maintain Connections and Timeout settings. Currently maintain connections is set to yes and timeout is set to 5 minutes. But when the SQL server locks up for whatever reason and fails over to the backup server the CF queries just start to queue up. In other words it apears that maintaining connections open by CF some how does not get updated to the newly live box. Before resorting to turing off maintain connections I wanted to know if anyone has had much success with CF and SQL clusters. -Peter Amiri [EMAIL PROTECTED] MySpace.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and SQL Server Cluster
Hi David, the configuration is active/active. Any idea or recommendation on how to set up the cluster? Thanks, Marcello. >how is your SQL Server clustered? Is it active/active, active/passive, etc? >Sounds like an issue with how the cluster is set up to talk to CF - not >necessarily a CF configuration issue? > >-Original Message- >From: Marcello Frutig [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, September 13, 2000 4:04 PM >To: [EMAIL PROTECTED] >Subject: CF and SQL Server Cluster > > >Hi! > >Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL >Server cluster? > >It seems that always after a failover, CF is loosing the ODBC connection. >Only restarting CF resolves the problem. Here are the error messages: > >ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server >Driver][TCP/IP Sockets]ConnectionWrite (send()). >ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL >Server Driver]Communication link failure > >Additional info: > >. CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" >. SQL Server 7.0 SP2, NT4 > >Thanks in advace, >Marcello Frutig. >-- Astrolabio > > >-- >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.
RE: CF and SQL Server Cluster
how is your SQL Server clustered? Is it active/active, active/passive, etc? Sounds like an issue with how the cluster is set up to talk to CF - not necessarily a CF configuration issue? -Original Message- From: Marcello Frutig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 4:04 PM To: [EMAIL PROTECTED] Subject: CF and SQL Server Cluster Hi! Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL Server cluster? It seems that always after a failover, CF is loosing the ODBC connection. Only restarting CF resolves the problem. Here are the error messages: ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL Server Driver]Communication link failure Additional info: . CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" . SQL Server 7.0 SP2, NT4 Thanks in advace, Marcello Frutig. -- Astrolabio -- 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.
CF and SQL Server Cluster
Hi! Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL Server cluster? It seems that always after a failover, CF is loosing the ODBC connection. Only restarting CF resolves the problem. Here are the error messages: ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL Server Driver]Communication link failure Additional info: . CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" . SQL Server 7.0 SP2, NT4 Thanks in advace, Marcello Frutig. -- Astrolabio -- 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.
