 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / September 2005SQL and Majority Node Set
Hello Following on from a previous thread posted on 8/9/2005, titled "Need advise on SQL Server installating in MS cluster 2k3 Majority", I am currently evaluating some solutions to install SQL 2000 on Windows 2K3. One of the requirements is to use current clustering technologies, with provision for data centre site failures. Does anyone know if using W2K3 MSCS with MNS would be supported in the following configuration. 3 sites, two nodes at two of the sites that will configured to host the instance of SQL. 1 node at the remainig site to ensure a majority of nodes available in the event of a site failure. The Virtual server that hosts SQL will be configured to not failover to the single host at the third site. The SQL databases and other disk dependancies will be installed on a shared disk array. This would be presented as LUN's form a SAN at each site, most liekly one master and one slave. Synchronous data replication of the shared data would be performed via a third party utility on the SAN, such as EMC's mirrorview. Each of the nodes that can host the SQL Virtual server would have multiple HBA's installed with multi path I/O software installed. Any comments would be appreciated tia Ian SQL clustering requires a shared disk, so MNS clustering does not buy you much. Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC Clustering class > Hello > Following on from a previous thread posted on 8/9/2005, titled "Need [quoted text clipped - 26 lines] > > Ian Hi If you need cluster nodes to be dispersed, you need to use Veritas Clustering ("Stretched Clusters"),together with some SAN based real-time replication like EMC's SRDF. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ > SQL clustering requires a shared disk, so MNS clustering does not buy you > much. [quoted text clipped - 43 lines] >> >> Ian There are some other products like Double-Take, (NSISoftware.com) that will work if your SAN doesn't support SRDF. Mirror view will replicate the data, but it doesn't provide fail over at the application level. Double Take's product rides on MS clustering (either MNS or shared) and provides a failover capability you wouldn't normally get.  SignatureHope it helps dw _______________________________ Don Wilwol donwilwol(DELETE)@yahoo.com http://spaces.msn.com/members/wilwol/ > Hi > [quoted text clipped - 61 lines] >>> >>> Ian I should have posted this in the last reply. http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx SignatureHope it helps dw _______________________________ Don Wilwol donwilwol(DELETE)@yahoo.com http://spaces.msn.com/members/wilwol/ > There are some other products like Double-Take, (NSISoftware.com) that > will work if your SAN doesn't support SRDF. [quoted text clipped - 70 lines] >>>> >>>> Ian It is possible to use MSCS to implement a stretched cluster between two sites, though it makes more sense to use Veritas or Legato AAM clusters when looking for more than 2 sites. Regards, John > Hi > [quoted text clipped - 60 lines] > >> > >> Ian Ian, MSCS requires each node to be on the same subnet. With two sites, you can use vlans to mask the hops between sites, and with a 3rd site it would become even more of a challenge. I think you will also find it difficult to find a synchronous data replication technology that can keep 3 sites synchronized. MNS will only make things worse, in my opinion. I think you should stick with a disk quorum resource and avoid MNS whenever possible. You might want to read through the following KB article for more details about geographically dispersed MSCS clusters: http://support.microsoft.com/kb/280743 Regards, John > Hello > Following on from a previous thread posted on 8/9/2005, titled "Need advise [quoted text clipped - 19 lines] > > Ian I've just been looking at designing a very similar solution. Decided on doubletake in the end. Also, I believe SQL only supports 4 node clustering which means you can't have five nodes... > Ian, > [quoted text clipped - 45 lines] > > > > Ian |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.