We've two machines that are load balanced. How can we host the forum so that only one database gets updated?
Can we point one requests made to one server to the other server, or do we keep copies of the pages on both and then point to just one database somehow?
If you were using SQL Server or MySQL you surely could use a single database. With Access, it's also possible, but a bit harder and more prone to failure.
I would say it makes no point in having load balanced servers and then redirect requests from one to the other. Anyway, I'm definitely not a hosting expert, so I won't risk commenting on that...
Pointing to the same files is easy. You just setup a network share and point the website in IIS to the folder. You would make changes in config.asp so that the same database is used.
In order for the admin section to work correctly you will need to track sessions across the two servers. That should be a substantial bit of work.
Not to hijack this post... but is anyone else at readyhosting.com?
They've recently been acquired and will be migrating all sites to a new location. "Web and e-mail files are served through a farm of load-balanced Linux machines that utilize Apache Web server software, so your site will load quickly and not be impacted by the performance of any one machine."
Since I have no idea what the implications are... anyone else in the same boat? Or any advice from the experts?