All geek questions in one place

SQL Server Cluster Failure Programming

Currently, I do not have access to the SQL server cluster for development (one of which uses the cluster services with the SAN behind it), but in the future it will do for a live environment.

When programming this from a .NET environment, what should I expect in my code if node I am connected to a movie? Is the transition to another node completely transparent? Do I need to catch some kind of exception and try to connect again? Is there any code for this?

+3
source share
1 answer

Fault tolerance is a big fat disconnect that will disconnect all connections to the server. You can reconnect in a few seconds to minutes as soon as the backup server starts and restores the databases from the shared disk (s). Any transaction in flight at the time of failure will be discarded.

In your application, the fail-safe event will be disconnected, you will lose all your connections, and any attempt to reconnect will fail until the recovery of the backup server is completed. If you use the correct transaction semantics, the data will be correct and a well-written application will resume without problems. If you do not use transactions properly, you will have all sorts of inconsistencies from logical half-records that are not properly protected by the transaction boundary.

. Virtual Server, HyperV ( Virtual PC), , VMWare ( ).

+3

Source: https://habr.com/ru/post/1779899/

More articles:


All Articles