Re: Does rolling a cluster create down time?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/01/04
- Next message: Geoff N. Hiten: "Re: Does rolling a cluster create down time?"
- Previous message: Rodney R. Fournier [MVP]: "Re: Does rolling a cluster create down time?"
- In reply to: Mike B.: "Does rolling a cluster create down time?"
- Next in thread: Geoff N. Hiten: "Re: Does rolling a cluster create down time?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 10:38:20 -0400
What the clients see or how it affects their transactions depends solely on
how the client app was written. It must be cluster aware. By that I mean
it must be able to detect a connection failure and reconnect. It must also
be able to resubmit the current transaction as it will be rolled back on the
server side when the cluster comes back up.
-- Andrew J. Kelly SQL MVP "Mike B." <Autobahn97@hotmail.com> wrote in message news:eS8jOB3XEHA.3596@tk2msftngp13.phx.gbl... > We have about 40 DB's blackening 40 web sites running on a single > SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the > next I'm wondering exactly what sort of outage our clients would see. Since > the entire cluster rolls in under a minute would there just be a delay on > the web sites with data requests in response from the web/ODBC side or would > there be an ODBC failure. Also, with regards to active web sessions, would > clients mid transaction on the web pages need to restart their transaction > or would there be a short wait during the SQL roll and then they could > proceed with the transaction (or would they need to start all over again). > I guess I'm wondering if I need to add the 1 minute of roll time into our > annual downtime calculation if the clients see an application > failure/unavailability. > >
- Next message: Geoff N. Hiten: "Re: Does rolling a cluster create down time?"
- Previous message: Rodney R. Fournier [MVP]: "Re: Does rolling a cluster create down time?"
- In reply to: Mike B.: "Does rolling a cluster create down time?"
- Next in thread: Geoff N. Hiten: "Re: Does rolling a cluster create down time?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
