December 12, 2002 at 2:45 pm
I am wanting to know what happens, from a process point of view, when a SQL cluster fails over in an active/passive environment. I understand that the SQL Virtual Cluster assumes the MAC address of the new server. Is there a way to keep this from happening? In addition does anyone know how the SQL Engine on the new machine takes over? What if there are any transactions taking place at time of fail-over. How are these handled? Thanks in advance!
December 13, 2002 at 6:58 am
quote:
I understand that the SQL Virtual Cluster assumes the MAC address of the new server.
Each MAC address is burned into the NIC at manufacture and is supposed to be unique. With that said, there are options that can present a different MAC address... Compaq's NIC Teaming does this. However, is this of great concern?
The Virtual Cluster will use the same IP address regardless of what node it's running on and will respond to the same NetBIOS name. Hence the reason the MAC address isn't part of the equation.
As far as the SQL Engine, it runs under the MSSQLServer service. Each node has the MSSQLServer service installed, however, it's only running on the node that has the virtual cluster. So during a failover, the MSSQLServer service is shut down on the one node and is started on the second node. So the SQL Engine picks up like it would normally.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 13, 2002 at 1:18 pm
Thank you for the information on the MSSQLServer service. The issue I have is that the switch has issues mapping multiple IPs to a single MAC. In addition when a failover happens that IP is then associated with a different MAC. I have used Dell NIC Teaming but it did not seem to make a difference. I have yet to find a good source for the intimate details of how MS clustering works. Do you have any suggestions?
Thanks
Kevin
December 26, 2002 at 9:54 am
Has anyone seen a book that is decent in regards to this?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply