?
Solved

Failover remote server

Posted on 2009-04-13
8
Medium Priority
?
332 Views
Last Modified: 2013-12-05
I have two servers that replicate data. I need to have the ability to failover to the second remote server if the first fails. dns points to the first server. Any suggestions on how to accomplish this task.  Both servers are windows 2000 server std and 2000 SQL server std.

Need to implement this yesterday.
0
Comment
Question by:jimmylew52
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 15

Expert Comment

by:zelron22
ID: 24139519
What are you using for replication?

For simple DNS failover, create a CNAME that points to your first server.  Then use the CNAME (alias) to point your apps to that server.

Then, if you need to fail over, just change where the CNAME points to.  Once DNS replicates, you'll be set.
0
 
LVL 1

Author Comment

by:jimmylew52
ID: 24141456
Peer sync is used to synchronize the data. Not sure what your are saying about the DNS but the DNS delay is the problem. We need to fail over in 1 - 3 hours.
0
 
LVL 15

Expert Comment

by:zelron22
ID: 24141584
How many DNS servers do you have, and are they located in different sites?

Is this just for internal access?  If so, you can configure your AD replication so that the DNS zone replicates within 15 minutes.  If you only have one DNS server, then it should almost be instantaneous (the client computers cached DNS will need to expire or they'll need to run ipconfig /flushdns).
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:jimmylew52
ID: 24144602
I have reread my question and see that I was not very clear. Let me try again.

client A in Washington accesses my site, my.domain.com and internet DNS resolves it to 6.5.4.3.         6.5.4.3 is my primary server in Texas. The secondary server is 8.3.4.5 in Georgia. How do I get my client to the server in Georgia when the Texas server goes down. And get then there with in 3 hours or less when the Texas server goes down.
0
 
LVL 15

Expert Comment

by:zelron22
ID: 24145013
Unless you can modify your router/firewall under these circumstances to forward that IP over to the failover, I believe you have a few options.

Dynamic DNS http://www.dyndns.com/services/dns/dyndns/readme.html (just one example).  You set up a new internet domain for this (and potentially other) hosts.  It basically acts as an alias and runs through a service provider.  If one server goes down, you log into your account at the service and change where the dynamic DNS domain host points to.

Is it just the one client, or many clients?  If it's the one client, have THEM set up a CNAME in their DNS for your app server and change where it points if there's an issue.

A differerent third party product to create a cluster over a WAN.

A VLAN that spans the WAN that both machines are a member of, and then simply change the natting on your firewall if there's an issue (or change the IP of the failover to the IP of the failed machine).
0
 
LVL 1

Author Comment

by:jimmylew52
ID: 24149970
Unless you can modify your router/firewall under these circumstances to forward that IP over to the failover, I believe you have a few options. - Firewall cannot do this. it would be easiest though.

Dynamic DNS   - Tried this. takes 12 - 24 hrs to update, time lag not acceptable

Is it just the one client, or many clients?  - Many and the list is growing

A differerent third party product to create a cluster over a WAN. - looking for one. Any suggestions?

A VLAN  - vlan is not possible with the present setup and hardware. trying to keep the cost to a min.
0
 
LVL 15

Accepted Solution

by:
zelron22 earned 2000 total points
ID: 24154202
Hmm...there are dynamic DNS services available where you can change the destination address and it should work within minutes, the only thing that has to happen is for the client DNS cache (or if there's a proxy server, it's cache) has to expire.

I don't know enough to recommend a WAN cluster solution, but my guess is that they may require a VLAN.  
0
 
LVL 1

Author Comment

by:jimmylew52
ID: 24177985
Found a failover dns company. looks lik that will work of us
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question