Solved

Load balance / failover server 2003 across WAN

Posted on 2008-10-28
12
395 Views
Last Modified: 2010-04-18
Hey Pros...

I'm way outta my element on this one.  

We have a new solution being setup and surprisingly enough the consultants doing the implementation are asking ME to look into this part.  We have 5 sites, WAN infrastructure will be 1.5Mbps T's in a fully meshed MPLS cloud (later this year).  Each site houses a Server 2003 R2 x64 Enterprise host for an Oracle based front-end application to SAP.   The servers are brand spankin' new HP DL380 G5's.

What they want to do is provide failover for a site from a primary server at the facility to a server at one of the other sites in our organization.   The downtime is to be scheduled in order to bring down the Oracle database and do a full offline backup of the server data, (backup software is BAckup Exec 12 with Oracle agents installed).

WAN infrastructure, at the moment, is a mass of branch-office VPN tunnels in a star configuration terminated at the home office on a Nortel Extranet 1510 switch (and yes, that IS damned old).  MPLS will be all Cisco hardware and managed by the ISP.

I've read through some of the technet docs for configuring network load balancing and IP load balancing but I'm not sure if I'm in the right ball park, so any advice will be welcomed.
0
Comment
Question by:GPskinzhut
  • 6
  • 6
12 Comments
 
LVL 14

Expert Comment

by:plug1
ID: 22830278
Im not 100% sure what you need to achieve here? If the main site fails then you are to restore the data to a remote site and redirect the traffic to there? Is this what you mean?
0
 

Author Comment

by:GPskinzhut
ID: 22830537
G'mornin' Plug

At the moment, just traffic redirection whenever a server goes down.  I guess I put in more info than I needed to.  
0
 
LVL 14

Expert Comment

by:plug1
ID: 22830685
It depends how clients are connecting to the application server, If they connect by server name then its easy, you can configure DNS to use 2 seperate IP addresses for the server (1 being the remote server) and set it up to use "Round Robin" that way if the first server is unavailable they will connect to the remote server.

Obviosly you can discount the round robin in your scenario and simply manually change the IP address in the DNS server.

If its connecting via IP address then its a hell of a lot more complex..
0
 

Author Comment

by:GPskinzhut
ID: 22831021
Clients are supposed to be using DNS to connect so that's a good thing thus far.

This is something that would have to be completely automatic.  The operation is 24/7 manufacturing and the basis for doing this failover is so that we can bring down an application server over the weekend to do an offline backup, at which time clients would be redirected to a failover server.  So manually changing anything isn't an option.  
0
 
LVL 14

Expert Comment

by:plug1
ID: 22831207
Ok, well if you configure the DNS round robin correctly then it will be. When they try to connect to the failed server it will return as a null entry and move on to the next IP address. Job Done.
0
 

Author Comment

by:GPskinzhut
ID: 22831269
Sounds all kinds of easy, which concerns and delights me all at the same time.

Let me get some feedback from the team and see if that will fit the bill.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 14

Expert Comment

by:plug1
ID: 22831415
lol, good luck..
0
 

Author Comment

by:GPskinzhut
ID: 22840265
well they certainly like the idea.

I read through some of RFC's and round-robin DNS lookups return different IP addresses per query, which would indeed provide load-balancing, but not failover, unless I'm missing something in the translation...
0
 
LVL 14

Accepted Solution

by:
plug1 earned 500 total points
ID: 22840336
Your right, you would need to write a script ot do it, but failing that you can spend less than $100 and use this...

http://www.simplefailover.com/default.aspx
0
 

Author Comment

by:GPskinzhut
ID: 22876894
Heya plug

sorry, I was out for a couple days and swamped the last couple.  I'll d/l that and see if it'll do what they'd like it to do and post back.

Thanks!
0
 
LVL 14

Expert Comment

by:plug1
ID: 22880059
No worries mate.
0
 

Author Comment

by:GPskinzhut
ID: 22921461
Looks like I can probably get that to do what they've asked, still some stuff to figure out as far as getting clients to connect back to the primary server once it comes back online but that's gonna be more for them to figure out I think.

thanks again
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now