homepage Welcome to WebmasterWorld Guest from 50.17.86.12
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
Forum Library, Charter, Moderator: open

Webmaster Hardware Forum

    
Server Configuration when 50 users accessing mysql database
Imaster

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 425 posted 10:14 am on Jun 19, 2006 (gmt 0)

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?

 

jtara

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



 
Msg#: 425 posted 3:36 pm on Jun 19, 2006 (gmt 0)

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Webmaster Hardware
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved