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