Nick Hill wrote:
On Mon, 25 Nov 2002 19:21:57 -0500 "Poor, Edmund W" Edmund.W.Poor@abc.com wrote:
Nick,
Your idea assumes that the "lag" problem is due to overloading a single machine, which plays double roles: database backeand and web server. So, if we divide the work amoung 2 or more machines, you expect faster throughput. Right?
My idea is not to divide the roles of web server and backend. It is to divide the workload of the one server between many servers. This includes search queries and other functionality.
<snip brave and expensive vision>
While the proposal of Nick will no doubt be the long-term future, separating database server and webserver is both relatively cheap and easy, and should increase performance. It is even recommended in either the MySQL or the PHP online manual (or was it apache? Brain, where are you?).
Even a smaller server might do, though I'm not sure wether to run apache or MySQL on it. Probably the latter.
Oh, and we need a place for the sifter project, while we're at it ;-)
Magnus