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]
