How do you do Load Testing and Capacity Planning for Web Sites
Let me refine my questions:
1. How can I improve MySQL performance?
2. Will adding more RAMs help?
3. Will server 1 (details below) get bogged down even with more RAMs?
Server 1 - Dual-core Xeon, 1GB RAM (max 8GB), LAMP (as image cdn server, not really using the M part)
Server 2 - Quad-core Xeon, 8GB (max 24GB), LAMP (as main server, AMP running exclusively on this server)
Server 1 (top command) - rather free, not much happening, CPU utilization is idle most of the time
Server 2 (top command) - heavily loaded with MySQL (where mysqld can take 100-175% CPU utilization easily)
My plan is to do primitive MySQL load balancing between the two servers (edit PHP and channel say 40% of mysql queries to Server 1).