For one of our sites, we run a pair of load-balanced Windows servers. Each server is running Apache 2.0. We use FoxWeb for some of our pages.
When we went to load balancing, we moved the Visual FoxPro database files off of the web server onto a back-end server (same as we did for the static document root) that both servers access. This was far easier for us to pull off than having duplicates of the database and figuring out how to keep them synchronized.
This has proved effective for our needs. We've resolved the performance issues we were facing prior to load balancing. (BTW, those were general web server load issues, nothing related to FoxWeb's performance).
We do see a handful of VFP errors in the error log each day: "Database object is being used by someone else." This occurs maybe 3-5 times per day, out of many thousands of hits. These are not mission-critical pages, and are display only (not recording user transactions), so this error rate is acceptable to us for these pages.
I should state that the code we wrote for these pages takes a very simpleton approach to accessing the database...no attempt is made to lock/check for locks/timeout/retry/etc. Just your basic select and scan -- whatever VFP's default behavior is in a multiuser environment, that's what we've got.
I'm curious if anyone else is using FoxPro (and FoxWeb) in a load balanced or similar multi-user environment. How did you approach it, and how is it working for you? Are there best practices?
I look forward to an open discussion on this,
Internet Database Administrator
Kentucky Educational Television
(859)258-7164 - (800)333-9764