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, [EMAIL PROTECTED] 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 -- 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
