Quote:
|
Originally Posted by reteep
The cluster is like that. One Webserver(Zeus) and one seperate Database Server.. The DB Server is a XEON and the Webserver a DUAL XEON.. However, it doesn't seem to be able to handle the load.
I investigated a bit, most power is sucked by Search Queries. Unfortunately vB doesn't have an option to disallow searches when the load goes above e.g. 5. But it wouldn't work out anyway because the database machine is seperated from the webserver.. I already set the timeout between searches to 15 seconds / user, but with so much traffic every second a new search query is being shot.
It's really difficult to get rid of that, when I move away from that Cluster I need to use Apache again, which is even more hardware intensive, good for SEO but bad for performance. Zeus is bad for SEO but great for the performance, although it has its price.
What I gonna do now is restricting searches to registered members.. renting 2-3 dedicated Servers for the forum wouldn't make the outcome worth it..
|
Make sure you get a mysql expert to optimzie your mysql conf. file, that REALLY REALLY helps.
Only members can search, you NEED to do this

Also set timeout to 30 seconds maybe.