Home / server / Questions / 86162
Accepted
Cédric Boivin
Asked: 2009-11-19 12:51:33 +0800 CST

SQL 2008 Clustering

  • 772

I need to configure SQL or Windows 2008 Clustering to get HA with no packet loss.

I configure my SQLcluster, but when I restart one node, I lose one ping. I try to lose no ping so that my query will continue to execute with no timeout when the owner node cluster restarts.

Is it possible ?

windows-server-2008

2 Answers

  1. Best Answer

    Clusters don't allow querries to continue to execute on failover. A cluster failover means the instance starts again from a cold state, runs pending recovery on all databases and puts them online on the new node. All clients are disconencted, all pending transactions rolled back, all running querries aborted. Clients have to reconnect and resume from the last commited transaction.

    BTW this also applies to Mirroring. The only technology that abstracts transparently the failover event so that applications don't notice the incident is messaging based, eg. Service Broker, because all work is first commited locally and delivered asynchronously to the cluster/mirror, but this does not apply to the vast majority of applications.

    • 4

  2. do you have a secondary "heart beat" nic connecting the two servers ? the 2nd server need to know about the first server "problem" in order to "take over" and it means than it can't be on the milisec.... there might be 1 ping lost, if there is a heart bit cable between them, it might be detected earlier, also - if one server start processing a query and was shutdown (power) the query will be lost...

    • 0