[TriLUG] Metrics for concurrent connections in a web based application

[Jon Carnes]

I've done something similar using PostGres instead of MySQL.  The
machine specifics were similar as well.  In that setup I could easily
handle 20 simultaneous connections and 10,000 hits/hour.

We were recording all requests into the database, and feeding out some
dynamic html content as well as product information from the database. 
All of this was in a test environment.  A "proof of concept" that
PostGres could function as well as MS-SQL for our clients web data
needs.

Good Luck - Jon Carnes

BTW: if you are looking for some tools to help you accurately measure
the volume your web-site can handle (which also helps you refine your
website and remove trouble spots), you should check out:
  http://www.webperformanceinc.com

(no I'm not with the company)

On Tue, 2003-10-14 at 11:29, STaylor at srspos.com wrote:
> Good Morning,
> 
> We are currently in the process of implementing a web application on
> MySQL with apache.
> 
> We are planning to implement the app on a P3 450 w/ 756 mb ram.
> 
> Does anyone have any experience with this type of solution?
> 
> Do you have any idea about concurrent connection limits or scalability
> requirements?
> 
> Like at what number does one wish to move to scsi or raid?
> 
> Does it make sense to implement the DB on a separate machine? so that
> the web transactions are processing on a separate processor?
> 
> Or should I simply put the DB on a separate drive on the same bus?
> 
> Any experiences shared would be greatly appreciated.
> 
> Thanks,
> 
> Shawn
> 
> 
> 
> ______________________________________________________________________
> 
> -- 
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
> TriLUG PGP Keyring         : http://trilug.org/~chrish/trilug.asc