Welcome to WebmasterWorld Guest from 54.145.144.101

Forum Moderators: open

Message Too Old, No Replies

Server Configuration when 50 users accessing mysql database

   
10:14 am on Jun 19, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hello,

I would like some input from the experts here regarding a server configuration that I am planning to opt for.

We have an application (VB Based) which uses mysql database and will be accessed by around 50 people simultaneously. The type of requests are selects, updates, and inserts.

Now, the hardware configuration that I plan to use is:

IBM Server : X226 Series
Xeon 3.0 ghz processor based server (800 Mhz Front Side Bus)
3 GB Memory ddr sdram

Now I have two questions:

1. Should I go for SCSI DRives or SATA drives?

2. Should I add one more processor, so that it becomes a dual xeon processor.

Regarding point 1. above

SCSI Drives INFo:

U320 SCSI (144 GB)

SATA Drives Info:

7200 rpm with either 3gbps or 1.5 gbps

Using SCSI increases the cost too much.

- Do you think there will be much performance difference between SCSI and SATA?

Any suggestions?

3:36 pm on Jun 19, 2006 (gmt 0)

WebmasterWorld Senior Member jtara is a WebmasterWorld Top Contributor of All Time 5+ Year Member



If you want or require the ultimate in speed and reliability, go with SCSI.

SATA can get you performance near that of SCSI, and good reliability. This has (almost) nothing to do with the SCSI and SATA technology itself, and everything to do with marketing.

There is a wider range of reliability in SATA drives as most SATA drives are targeted at the desktop market. A few are targeted at the server market. SCSI drives are targeted exclusively at the server market at this point, and so they have specifications more-suited to that market.

It's hard to go wrong with a SCSI drive. It's easy to go wrong with a SATA drive.

For a good balance of speed, reliability, and price, use 10,000 RPM SATA drives that are specifically intended for servers. Check reviews first. There are some great SATA drives and some really awful ones.

As to whether or not your hardware will be up to the task - who knows? You haven't supplied enough information. 50 users doing what? Transactions/second is a much more useful figure than number of users. Even then - how complex a transaction, what are the usage patterns, etc.

I've been using dual CPUs in both servers and desktops for years now, and I wouldn't go any other way - although counter-intuitively, I think it's more important for a desktop than for a server. For a desktop, dual CPUs is a huge responsiveness win.

But I would look for a server using one of the newer chips that pack two CPUs in one package.