Google Answers Logo
View Question
 
Q: Load balancing websites which run off MS access ( No Answer,   2 Comments )
Question  
Subject: Load balancing websites which run off MS access
Category: Computers > Operating Systems
Asked by: tomhopkins-ga
List Price: $25.00
Posted: 06 Jan 2004 04:25 PST
Expires: 05 Feb 2004 04:25 PST
Question ID: 293608
I'm looking to either load balance / failover two webservers which
serve some sites which operate out of access databases. I guess
ideally, both servers would offer webservers and both would act as
database servers with some sort of frequent, bidirectional updating of
the data to keep them in sync. Any good solutions to this?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Load balancing websites which run off MS access
From: scubapup-ga on 07 Jan 2004 10:48 PST
 
You could add one more pc and put the access database there on a
share, as always the local network between the two webservers and the
file server sharing the access database has to be absolutely reliable.
You could also look into using MSDE which Microsoft is giving away for
free but has a 5 connection at a time limit which should be no problem
if your application closes connections properly and at the correct
time. Given this scenario you could cluster the two web servers using
the MS Network Load Balancing service or if you want a simpler but a
little bit harder to maintain solution you could go with round robin
dns.
Subject: Re: Load balancing websites which run off MS access
From: tomhopkins-ga on 08 Jan 2004 10:59 PST
 
I think this is going to be the answer, which basically amounts to
"use sql on a third machine instead". The attraction of being able to
use Access, however is more the ease of deployment than the cost. If
anyone else has got any bright ideas, that would be very helpful.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy