Petri.co.il forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Databases > SQL Server 2008 / 2008 R2 / 2012
Petri.co.il is happy to award RicklesP the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read
Notices

SQL clustering

SQL clustering

this thread has 5 replies and has been viewed 3187 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 16th August 2010, 18:52
Stevenjwilliams83 Stevenjwilliams83 is offline
Junior Member
It's not a coincidence
 
 Join Date: Jan 2008
  6 month star 12 month star
 Location: Illinois
 Posts: 116
  Send a message via Yahoo to Stevenjwilliams83
 Reputation: Stevenjwilliams83 is on a distinguished road (10)
Default SQL clustering

Is SQL clustering possible with 2 SAN clusters? Can you setup a cluster over a WAN to achieve a DR solution?
  #2  
Old 16th August 2010, 20:11
Ossian Ossian is offline
Administrator
 
 Join Date: Nov 2003
  6 month star 12 month star
 Location: Bonnie Scotland
 Posts: 16,360
  Send a message via Skype™ to Ossian
 Reputation: Ossian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud of (1470)
Default Re: SQL clustering

AFAIK clustering is 2 hosts connected to 1 SAN -- not 2 SANs

There is log shipping which give a copy dB at another site for DR purposes
__________________
Tom Jones
MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
PhD, MSc, FIAP, MIITT
IT Trainer / Consultant
Ossian Ltd
Scotland

** Remember to give credit where credit is due and leave reputation points where appropriate **
  #3  
Old 16th August 2010, 22:51
Stevenjwilliams83 Stevenjwilliams83 is offline
Junior Member
It's not a coincidence
 
 Join Date: Jan 2008
  6 month star 12 month star
 Location: Illinois
 Posts: 116
  Send a message via Yahoo to Stevenjwilliams83
 Reputation: Stevenjwilliams83 is on a distinguished road (10)
Default Re: SQL clustering

does log shipping give you automatic failover? i didnt think it did. How are people creating automatic failover solutions for DR when equipment is in tow separate locations?
  #4  
Old 17th August 2010, 09:04
Ossian Ossian is offline
Administrator
 
 Join Date: Nov 2003
  6 month star 12 month star
 Location: Bonnie Scotland
 Posts: 16,360
  Send a message via Skype™ to Ossian
 Reputation: Ossian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud of (1470)
Default Re: SQL clustering

No, I don't think so either...
I checked MS and SQL 2008 does offer geographical clustering:
http://www.microsoft.com/sqlserver/2...ilability.aspx
__________________
Tom Jones
MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
PhD, MSc, FIAP, MIITT
IT Trainer / Consultant
Ossian Ltd
Scotland

** Remember to give credit where credit is due and leave reputation points where appropriate **
  #5  
Old 17th August 2010, 16:07
Stevenjwilliams83 Stevenjwilliams83 is offline
Junior Member
It's not a coincidence
 
 Join Date: Jan 2008
  6 month star 12 month star
 Location: Illinois
 Posts: 116
  Send a message via Yahoo to Stevenjwilliams83
 Reputation: Stevenjwilliams83 is on a distinguished road (10)
Default Re: SQL clustering

Now thats interesting. Although Windows/SQL support Geographically Dispersed Failover Clustering it will not span different subnets. You need to cluster in the same LAN or VLAN. This solution also requires SAN replication, which is fine, but the subnet thing kills me, what company will have a DR site on the same subnet.
  #6  
Old 14th October 2010, 22:21
ScottMcD ScottMcD is offline
Junior Member
It's not a coincidence
 
 Join Date: Feb 2009
  6 month star 12 month star
 Location: Minneapolis, Minnesota
 Posts: 113
 Reputation: ScottMcD is on a distinguished road (35)
Default Re: SQL clustering

Quote:
Originally Posted by Stevenjwilliams83 View Post
what company will have a DR site on the same subnet.
Ours does, dark fiber between the sites. If our primary datacenter goes boom, we just have to flip the cluster HBAs at the DR site to a replicated secondary SAN and were back up and running.

That said, a new feature of Windows Server 2008 Failover Clustering is support for cluster nodes on different subnets.

From http://technet.microsoft.com/en-us/l...25(WS.10).aspx

"Place clustered servers on different subnets: You can now place clustered servers on different IP subnets, which reduces the requirements for geographically dispersed clusters."
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SQL] SQL server setup best practice. dotnerd Misc 4 26th February 2009 21:00
Windows 2008 Server Clustering for MS-SQL 2005 imran_mcse Windows Server 2008 / 2008 R2 1 28th October 2008 04:28
Multiple SQL clustering options Techie Windows Server 2000 / 2003 / 2003 R2 2 14th October 2008 19:43
MS SQL desktop Engine to SQL server 2008 E.T.phonehome Windows Server 2000 / 2003 / 2003 R2 0 4th September 2008 20:57
SQL server clustering Shiva Windows Server 2000 / 2003 / 2003 R2 0 11th March 2005 22:20


All times are GMT +3. The time now is 21:44.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri