We help IT Professionals succeed at work.

Web Server - Failover solution

I have a client that hosts their webserver internally at their office.   They would like a solution that would repoint their website  -  www.mycompnay.com  -  to an external server if their internal T1 or internal webserver goes down.    they don't mind having a 2nd server offsite somewhere for this purpose.

The reason they can not put their current server offsite is that they are updating it on a regular basis and have a database on it that they use.   They can upload the data a couple of times a week to the offsite server to keep it somewhat fresh in case of an emergency.  

Thanks
K
Comment
Watch Question

Commented:
Why not use somehting like double take software, it carries out a realtime replication of data/ server and in the event of a disaster it would allow tyhe client to get back up and running with the web server relatively quickly. It would mean additional hardware/ OS on the secondary server, but the hardware does not have to be the same.

Author

Commented:
Hey delmc,
Unfortunately They don't have that kind of budget.   they are a non profit and would like to have functional solution but are willing to sacrifice the up to the minute data replication.

K
Top Expert 2009

Commented:
is that windows or linux base server ??

if they have mysql server then mysql replication would be best and easy options


Author

Commented:
it is SQL standard version running on Windows server 2008 on a VM.  
Top Expert 2009

Commented:
So you got Sql Server Standard version. in that case i would not be able to help you.dont have too much knowledge of Sql server. sorry for that.


Commented:
I suppose you could use something like an ftp upload to transfer the data, but scheduling may have to be carried out manually. So it would be a case of setting up the remote server to receive ftp transfers and then using a client such as cuteftp to transfer the data? I'll continue to look and see if there are any free alternatives to double take though as a realtime sync would be more beneficial.

Commented:
Check out this link it may be helpful as well, didn't realise you were using sql
http://searchsqlserver.techtarget.com/tip/Push-vs-pull-Configuring-SQL-Server-replication

Author

Commented:
Thanks delmc.   I'm really looking for a solution that will automatically change the www  direction from their internal server to the hosted server.   the replication is a secondary issue which I don't think they are very worried about for now.  

so the scenario solution that i am looking for is this:

the current website is in their main locaiton and everything is fine.
their T1 goes down for two days and no one can access their www site.
Is there a way that if their main site is not accessible, it will automatically redirect web users to a backup web server they have at a co-lo?

thanks and I apologize for not being more clear.

K

Commented:
Also check out this link, don't know how helpful it will be though as I haven't setup SQL sync for years.

http://msdn.microsoft.com/en-us/library/ms151793.aspx
Top Expert 2009
Commented:
if you have control over the zone record of the domain then you can do this easily by writing script(linux)  or even by hand in a minute.

but if you dont have admin control over your domain then you cant do that. you will have to tell your dns admin manager to change the A record


or

 if you pay some out side provider example, dnsstuff or opendns .. they can do this easily by monitoring the A record

Author

Commented:
Thank you all for your feedback.  It was great help.

Khaled