|
|
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? |
|
There is no answer at this time. |
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |