Server configuration to support concurrent users

We currently have one server, which includes apache, mysql:

Intel Xeon 4x 3.2GHz      8 GB DDR3      120 GB SSD      10 TB BANDWIDTH

Our website times out at 21 concurrent users.

What do we need to do to support more user at the same time? Build a cluster? load balancing?
LVL 8
Sam CohenConsultant to Digital/DeveloperAsked:
Who is Participating?
 
hecgomrecConnect With a Mentor Commented:
Your are planning to support up to 30,000 connections with only 8GB of RAM?.... I have 32GB for only 100 for OWA... I think u should start by adding some decent amount of memory to that box.  Just go to your task manager and open the performance tab to see how much memory your server is using.  You did not mention which OS you're using but if you are using Win Server 2008, you need for it at least 4GB to run it by it self as a DC, DHCP, DNS or file server... and even like this it will be slow.... it will need 8GB to run smooth for any of the above... really... add more memory to it and wait to see if you ran into the same scenario.
0
 
Seth SimmonsSr. Systems AdministratorCommented:
have you looked at mysql and apache logs?
i would start there before spending money on additional hardware when it could be a software configuration
0
 
Sam CohenConsultant to Digital/DeveloperAuthor Commented:
hmm,

But I will need to support 10-30,000 people at one time.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Seth SimmonsSr. Systems AdministratorCommented:
this is a 2-part issue
need to first figure out why after only 21 users it craps out like that unless they are hitting the box hard like running long queries, etc. and capacity planning if you're looking at that much activity
0
 
Sam CohenConsultant to Digital/DeveloperAuthor Commented:
How would I find these things out?
How will the logs help me in this regard?
0
 
Seth SimmonsSr. Systems AdministratorCommented:
if the web site is timing out, the apache  and mysql logs should help
if something (say, a php site) is communicating with mysql and it doesn't return data because mysql crashed or some other error, the logs should tell you what happened.
just having 21 users connect shouldn't bring the site to a halt; something is going on in the background

you want to look at your apache logs in the logs folder where apache is installed (location could vary depending on if it was rpm or compiled from source).  same with mysql.  it's in /var/log/mysql though it would need to be enabled manually if it isn't already

The Error Log
http://dev.mysql.com/doc/refman/5.1/en/error-log.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.