• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Microsoft SQL Server Clustering

Hi All,

Currently we have two Node DB and there is an observer which is monitoring the heartbeat of these two servers.

If primary Node has any issues then switchover happens and secondary node becomes primary Node.

We need to make one VIP which will be pointing to both the Nodes, in case any DB switch over happens then application can still continue with the VIP and there will not be any impact on application services.

Could you please let me know
a. what port is required to implement the VIP?  
b. How many virtual IP's are required in order to implement Active-Active clustering?

Thanks in advance.
0
sqldba2013
Asked:
sqldba2013
  • 2
2 Solutions
 
Jim P.Commented:
SQL Server 2008 does not support Active/Active clustering. That is any single instance (set of databases) can only be controlled by one SQL Server service at a time. You can possibly setup the VirtualServer\Instance1 is running on ServerName1\Instance1, meanwhile VirtualServer\Instance2 is actually running on ServerName2\Instance2. The VirtualServer will redirect as appropriate.

there will not be any impact on application services.

There will always be a period of time when the SQL service is bringing up the database(s) and running basic integrity checks. And it also depends on the service if it has an auto re-try built in. About the best that you can do if the service doesn't is put a job restart in as SQL Server Agent job.
0
 
PadawanDBAOperational DBACommented:
Just point the applications to the cluster IP/FQDN?
0
 
sqldba2013Author Commented:
--
0
 
Jim P.Commented:
Mind if I ask why the B grade?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now