[nflug] Server Specs - Need Some Comments

[Frank Kumro]

Mark,
 I meant "php issuing a search query to the db". Thanks for the help

On 2/2/06, Mark Musone <mmusone at shatterit.com> wrote:
> For this need, at the very least, you want 2 servers, one database and one
> web server. for the DB server, 4G memory, dual xeon cpu. you say you will be
> using php for searching..what do you mean by that? do you mean php issuing a
> search query to the db, or php actually doing manual searching (the latter
> would be very bad)
>
> ..thats my quick $.02 off the top of my head..
>
> -Mark
>
>
>
> -----Original Message-----
> From: nflug-bounces at nflug.org [mailto:nflug-bounces at nflug.org] On Behalf Of
> Frank Kumro
> Sent: Thursday, February 02, 2006 12:10 PM
> To: nflug at nflug.org
> Subject: [nflug] Server Specs - Need Some Comments
>
> I am working on a new contract and one priority is to set up a LAMP
> server. I have set up many before however this one will have 500,000
> records that are searchable in the MySQL database. Since I have never
> worked with this much data I was wondering if the LUG can give me some
> specs for the server. PHP4 will be used for searching unless the
> performance is horrible, but I will deal with that when I begin
> testing. What I was thinking for hardware is
> 1) SCSI drives
> 2) 2GB of ram (maybe more maybe less??)
> 3) 2 processors (Xeon, is 1 good enough?)
>
> As you can see I only have a vague idea. Thanks in advance guys!
> --
> Frank
> Shenanigans!!
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>


--
Frank
Shenanigans!!
_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug