Solved

Server configuration to support concurrent users

Posted on 2014-03-02
6
76 Views
Last Modified: 2015-10-01
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?
0
Comment
Question by:Sam Cohen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 35

Expert Comment

by:Seth Simmons
ID: 39899414
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
 
LVL 8

Author Comment

by:Sam Cohen
ID: 39899431
hmm,

But I will need to support 10-30,000 people at one time.
0
 
LVL 35

Expert Comment

by:Seth Simmons
ID: 39899438
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 8

Author Comment

by:Sam Cohen
ID: 39899464
How would I find these things out?
How will the logs help me in this regard?
0
 
LVL 35

Expert Comment

by:Seth Simmons
ID: 39899469
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
 
LVL 11

Accepted Solution

by:
hecgomrec earned 400 total points
ID: 39900369
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

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The 6120xp switches seem to have a bug when you create a fiber port channel when you have a UCS fabric interconnects talking to them.  If you follow the Cisco guide for the UCS, the FC Port channel will never come up and it will say that there are n…
Usually shares are where we want them for our users and we tend to take them for granted. There are times, however, when those shares may disappear causing difficulty for your users. One of the first things to try is searching for files that shou…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question