April 15, 2008 at 12:35 pm
I want to know what is the difference On Hearbeat.
I have nodeA (active) heartbeat IP address is 192.188.1.11
In NodeB the (passive) heartbeat IP address is 192.188.1.12
Do I need to use the another Heartbeat IP address or if I use 192.168.1.11 is fine. I used the 192.168.1.11 and it works.
What is the difference if I used 192.168.1.12 or the another IP address. can anyone please explain me.
April 15, 2008 at 2:47 pm
Nita Reddy (4/15/2008)
I want to know what is the difference On Hearbeat.I have nodeA (active) heartbeat IP address is 192.188.1.11
In NodeB the (passive) heartbeat IP address is 192.188.1.12
Do I need to use the another Heartbeat IP address or if I use 192.168.1.11 is fine. I used the 192.168.1.11 and it works.
What is the difference if I used 192.168.1.12 or the another IP address. can anyone please explain me.
It works because you are connecting to an active node directly.
Do you have a virtual IP setup?
if not ...you have to create a VIRTUAL IP that spans both (active nodeA 192.188.1.11) and passive nodeB 192.188.1.12 like (192.188.1.13).
if your 11 fails over to 12 your applications will still be able to function since 13 is spanning them both.
With your current setup your applications will fail at the failover if you set them to use 11.
April 16, 2008 at 9:26 am
Thanks Alex,
Yes I am using the Virtual IP address seperate from NODEA and NODEB.
So I can use it the same hearbeat IP? or do you want me to use the new IP address for hearbeat.
To use new heartbeat IP address how should I change it from my existing configuration. I am using SQL 2005
April 16, 2008 at 11:45 am
Yes use the virtual IP
From another machine can you try to connect from Query Editor using the virtual IP?
Also check out these docs and articles on how to setup sql 2005 cluster
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply