Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


June 2002

Geographically Distributed Clustering


RSS
Subscribe to Windows IT Pro | See More Clustering and Load Balancing Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Both the failover and reinstatement procedures automatically perform a reboot of the primary server—not a concern in the case of a failover, but note that following reinstatement, no server will act as primary server until the original primary server is completely rebooted. In my environment, the reinstatement and reboot finished in less than 4 minutes. BrightStor High-Availability Manager's failover and reinstatement process is more automated and user-friendly than those of Octopus and Double-Take.

Double-Take's manual failover process occurs almost instantaneously. The automatic loss-of-connectivity failover involves a fairly long Time to Fail value, but if you know failover is imminent, you can click the Failover button to shorten the wait. During a manual failover, the source computer's name and IP address don't change and the computer isn't removed from the network. Therefore, IP address and name conflicts occur. To return to normal after a failover, I clicked Failback in the Failover Control Center. Doing so immediately removed the source server's identity from the target, and the software prompted me to restart or stop monitoring of the source server. After restarting the source server, I instructed Double-Take to restart server monitoring. At this point, two different sets of data existed on the source and target systems, and I could either copy individual files manually from the target to the source or use Double-Take's Restoration Manager to restore the entire replication set. I chose the manual copy method, which restored all file operations that weren't lost during the failover timeout period from the target server to the source server.

VERITAS Cluster Server 2.0 for Windows 2000
Contact: VERITAS Software * 650-527-8000
Web: http://www.veritas.com
Price: Starts at $4995 per server; bundle pricing available

SQL Server Failover
Legato's Web site offers application scripts that facilitate failover configuration for servers running SQL Server or Exchange. I downloaded a self-extracting executable file that contained the necessary scripts and documentation for configuring both SQL Server and Octopus. I followed the documentation's recommendations for configuring the SQL Server machines, customizing the scripts, and creating a new specification for mirroring SQL Server data directories to enable effective failover. After discovering discrepancies between the scripts and the documentation's script examples, I called Legato support for clarification. A Legato support engineer sent me a simplified set of instructions and an upgrade to Octopus 4.2, build 330b, which let me use SASO - Alias to accomplish the SQL Server failover. After the 30-second manual failover process, an error message informed me that certain files were open during the failover and therefore warranted inspection before using them in production. The process of failing over and reverting back seemed easy after I repeated the process a few times, but I recommend significant testing and documentation of the procedures specific to your environment to ensure success.

As I mentioned in the Installation and Configuration section, BrightStor High-Availability Manager loads Application Notes on the server during a typical installation. To configure the servers for SQL Server failover tests, I referred to Application Notes for Microsoft SQL Server 6.5 and 7.0. I ran the Replication Task Wizard to establish initial parameters for a task (i.e., select replicated folders and enable IP failover), then clicked Advanced Edit to open the Editing Task window and the BrightStor High-Availability Manager console, which Figure 3 shows. In the Task Editor, I set up a Workload to replicate my SQL Server data directory, specified destination paths for the data, and assigned the provided SQL Server script to failover and reinstatement actions on both servers. (The script includes code for both failover and reinstatement.) Failover times were similar to those in the file server tests, but the loss-of-connectivity test resulted in a few more missed transactions than the manual failover test. The failover and reinstatement processes for SQL Server performed flawlessly, requiring little preparation or intervention.

To configure SQL Server and Double-Take in my test environment, I downloaded the High Availability for Microsoft SQL Server Using Double-Take 4.x application notes and associated scripts from NSI Software's Web site and simply followed instructions. Configuring Double-Take's SQL Server failover and failback required more manual operations than BrightStor High-Availability Manager did, but the steps were straightforward and easy. However, I would have found the documentation easier to use if it had more clearly described which server I needed to perform certain actions on. I opened the Failover Control Center and clicked Edit Monitor. In the Monitor Settings window, I edited the two downloaded scripts and specified when Double-Take should execute them.

   Previous  1  2  3  [4]  5  Next 


Reader Comments
This is a great article - thanks !
Do you have comparison of those products with
Microsoft Clustering product ?

Arie Blum June 16, 2002


Why did you test with Exchange 5.5? Because most vendors couldn't support failover with Exchange 2000 yet? That is the question we really wanted answered... too bad.

Jeremy Vignaux July 31, 2002


Jeremy Vignaux you are quite correct, the only real way to provide automatic failover of Exchange 2000 is using MSCS. However you will find useful information on using Double-Take with Exchange 2000 at: http://192.168.0.100:3501/WhitePapers/Exchange2KDR.pdf

Ian Masters November 25, 2002


I understood the point of this article to be a test of some data replication alternatives to Microsoft's shared resource clustering of Windows 2000 Server. If Ed Roth tested these products as alternatives to Windows clustering, then why did he install Win2k Advanced Server on the test servers instead of Windows 2000 Server?

James Kidwell March 09, 2003


How can you title and article “Geographically Dispersed Clustering” mention anything about "geographically dispersed clustering." This is an article about “Clustering Alternatives to MSCS" not geographic clusters. If you wanted to talk about geographic clusters, how come you don't mention anything about the possible MSCS configurations?

How do you write a geographically dispersed clustering article for a Windows environment and not mention EMC's GeoSpan for MSCS? This product was partially (if not wholly) responsible for the creation of the "Cluster/Geographic" category on Microsoft's HCL.

While I do think that the content of your article is valuable, I think your title is very misleading.

John Toner May 16, 2003


I did my own testing using DoubleTake and arrived

Jim Calvin July 18, 2003


I noticed that SteelEye LifeKeeper is not on this list of products.
Anyone considering replication and clustering should also take a look at SteelEye LifeKeeper as it takes an application-centric view of clustering. Making the application highly available, not just the hardware and data.

Shobana Patel September 25, 2003


I use Double-Take to replicate Exchange 2000 mailstores and trans logs across a WAN, from one MSCS cluster to another MSCS cluster. The remote cluster uses Geocluster+ to simplify hard drive configuration. My mailstores total 120Gb, and I generate about 6Gb in trans logs each day. I am not using automatic failover - manual only, by choice. I'm using V4.3 SP2, and the system works very well.

Bob April 13, 2004


I agree with John Toner. Even though your article is helpful and informative it's really about replication tools that leverage mscs. When I look for information about geography distributed clusters I'm looking for shared disk scenarios over long distances (active active or active passive). If you have any information or know how on this type of implementation please share it with us.

Rafael Cruz June 09, 2004


We used a UK company called TriSys, they know all these products and recommended us with the best fit solution. We use Geospan and it has not let us down yet!

Anonymous User November 12, 2004


 See More Comments  1   2 

You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

New Microsoft/Yahoo! Deal? No

On Sunday, the Times of London reported that Microsoft had renewed talks with failing Internet giant Yahoo! and would manage its search engine for 10 years, while Yahoo! would retain control of its email, messaging, and content services. This report ...

How can I stop and start services from the command line?

...


Windows OSs Whitepapers Why SaaS is the Right Solution for Log Management

Related Events Virtualization, Automation and Databases

Virtualization for Mission-Critical BI with SQL Server

SQL Consolidation: Insights from Customers, Analysts & HP

Check out our list of Free Email Newsletters!

Windows OSs eBooks Understanding and Leveraging Code Signing Technologies

A Guide to Windows Certification and Public Keys

SQL Server Administration for Oracle DBAs

Related Windows OSs Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing