Jimmy Wales wrote:
What should I do to resovle the flush-hosts problem? If it's hardware we need, then it's hardware we shall have. Is the problem solvable by ram? By CPU?
I've no idea what exactly triggers the connection errors, but increasing the max_connect_errors (whice I've just done) should keep it from blocking future access.
I'm ready to throw some money at this thing again. Suggestions would be much appreciated.
I'd highly recommend a second database server, which would feed off the main one using MySQL's replication feature.
* It could run searches and nonessential but nice special pages; or perhaps simply round-robin load sharing
* If the main server crashes again, the wiki can fall back to the second server instead of being inaccessible.
-- brion vibber (brion @ pobox.com)