Re: Does rolling a cluster create down time?
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 07/01/04
- Next message: Geoff N. Hiten: "Re: # of supported failover nodes"
- Previous message: Andrew J. Kelly: "Re: Does rolling a cluster create down time?"
- In reply to: Mike B.: "Does rolling a cluster create down time?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 10:40:48 -0400
A cluster host transition is exactly like a SQL server stop-start. All
transactions are rolled forward or back at startup. The server is down
during the transition. The client application will see a connection timeout
or a query timeout or a broken connection. Whether the application traps
that or displays that to the end-user depends on the skill of the programmer
who wrote it.
Short answer, a cluster transition is downtime.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "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: # of supported failover nodes"
- Previous message: Andrew J. Kelly: "Re: Does rolling a cluster create down time?"
- In reply to: Mike B.: "Does rolling a cluster create down time?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
