High loading servers
 

Oh... I own a very high loading forum running on Linux.

To solve it, I have divided the forum into two servers:

Web server: Apache with web pages
Database server: MySQL with forum data

Yip, the loading is distributed but unfortunately, the loadings of the seperated servers are still very high.

Any help please...

are you saying that you are doing load balancing, but the loads on both machiens are still high? sounds like you either need more machines or more powerful machines. Also check to make sure you arent being attacked or something. You do have a firewall setup right?

No, I am not under any attack but just a huge number of apache (httpd) connections that are visiting the forum.

How can I solve it by so call "more machines"? I know that I can further divide the web server into two or even more, but the database cannot, right?

I have cocerned using RAID but someone tell me that it is not the solution.

Can directly connect the two servers by network cards but not through rounter solve the problem?

Thanks for your reply

When you say the load is high - which aspect of the systems. Is your CPU maxed out? Or is it memory/network/disk IO that's the bottle neck? You might just want to think about performance tuning the existing systems.

cheers

Jamie...

More details...

In MySQL server

load average: 4.59, 5.66, 4.44
...
%CPU %MEM CPU COMMAND
99.9 2.6 1 mysqld

In Apache web server, there is huge connections to apache (httpd) as there are many people visiting the forum.

load averages: 2.92, 3.59, 3.40

Thanks

Yeah thats pretty high CPU load. Are these your databases? If so are you making good use of indexes / a good structure to reduce query time to a minimum?

cheers

Jamie...

Yes, I am using MySQL wiht mysqld (MySQL daemon).

The forum is not written by myself but is a download one like phpBB.

Any ideas...