using heart-beat between 2 nodes in a cluster 1

[holdahl]

I have a 2 noded cluster which I have to move one of the nodes to another server-room. Is there anything special I have to do to still use the heartbeat function between these two nodes. Or just connect them through our main core-switches?
Our two server rooms are located approx. 500meters between each other.


sH

 

[Catadmin]

I don't know that physical location has ever mattered with heartbeats. As far as I know, all you need is the usual kind of network connection between the servers and you're set.

Of course, they have to be connecting to the same SAN or NAS drives in order to failover properly...



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

NAS, no. SAN yes.

NAS isn't supported with SQL Server.

As long as the two ports that you are using are on the same VLAN, and have connectivity you should be fine, provided that the network speed between the two buildings is fast enough for the hardbeat. I'm not sure what the time out is, but I would assume it's sub 10ms. The BOL for MSCS will probably have more info on the timeout.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Not having used NAS before, what is the difference between it and SAN that SQL Server doesn't support it?

I ask because rumor has it we're going to NAS storage on a whole bunch of servers at our workplace because it's cheaper.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

NAS is Network Attached Storage
SAN is Storage Area Network.

Basically to connect to a NAS you connect to the NAS device over your regular ethernet network (\\NASDevice\Share\Folder\file.txt). If you "mount" a NAS share to a server it shows up as a mapped drive.

To Connect to a SAN you connect over a dedicated high speed fibre network. If you mount a SAN LUN to a server it shows up as a local disk. Unless you know what you are looking for you would never know that a SAN drive isn't physically installed within the server.

With a NAS share many clients (in this case servers) can access the storage at any one time (because the volumne it self is owned and managed by the NAS device).

With a SAN drive only one machine can talk to the volume at any one time.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Okay. That makes sense since SQL doesn't like anything that doesn't look like a local drive to it.

Thanks for the explanation. I appreciate it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com