> Need some pointers on something. I have just been tasked to lead a > project that will involve moving our single SQL Server 2000 database > into a cluster. > > I'll state up front I have no experience in a clustered environment, > so a lot of these questions are definitely newbie. > > My understanding is that this cluster will be what they are calling > "active/active", which I understood to mean that both servers will be > running and taking connections at the same time. I do not know if the > balancing could and will send people from one database to the other > during the course of a session, and I am assuming the data will be > constantly synced between the two servers. > > What I need to know is this: When CF applications go from using a > single database server to a clustered database server, are there any > issues with how the applications interact? For example, some of our > apps use client variables that are stored on the database, is there > any issues with this? Also, is there any coding practices we need to > implement that we do not currently? The practices we do perform > include things like using CFTRANSACTION around multiple queries to > keep it to one connection, using CFQUERYPARAM for data validation, and > using stored procedures for some advanced queries. > > Basically I'm looking for some tips on clustering in general, and also > what landmines I might could expect to hit, and how to avoid them. > > > > thanks > -r > _____________________________________ > Rob Barthle > Contractor - Sr. Software Developer > [EMAIL PROTECTED] > 202-245-6484 > > I have setup sql server clusters before. You said you are going to run active/active, but I don't think you can. Each active node in the cluster has to own it's own hard disks. You can't have two nodes using the same hard drive(s)at the same time.
Currently sql server clustering is only for high availability or failover. So in other words you can't do load balancing with sql server. I run active/active but I have two nodes using different hard drives on an external storage array. If one box fails, the other box takes control of both sets of hard drives and runs both instances of sql server. Hope this helps you somewhat. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54