Development for SQL Server Cluster

If I am developing an environment that will use SQL Server clustering, what (if anything) should I know?

From what I saw, I have to handle the exception in the database operation and have two options:

  • Display the "retry" of the user. By the time the user repeats the transition to another node resource, he should have been logged in.
  • Wait a few seconds and try again without notifying the user.

It is right? Is that all I need to do?

This is an ASP.NET application, but I don’t think it should be of great importance to the approach.

Any advice would be appreciated.

Duncan

+3
source share
1 answer

. , , :

  • SQLException: " (: TCP, : 0 - .)"
  • SQLException: " SQL Server . . SQL Server (: TCP, : 0 - , .)"
  • 3 .
  • .

. SQL- , , 30 , - . , , .

IP- , , , , - . , , , -, , node.

+3

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


All Articles