We are thinking about a new setup of servers and have the following hardware available:
2x double P3 servers @ 1GHz each with 2GB ram, SCSI
2x XP1800 or P3 1GHz with 1GB ram, IDE (7200)

We thought about the following setup:
The two single CPU IDE servers as frontend webservers in a cluster serving only http, mail and ftp traffic and the 2 double CPU servers as mysql database servers.

Would this be cool or better the other way around using the double P3 machines as the front end servers and going with the single CPU machines as mysql servers?

The single CPU's can't be upgraded to more RAM but the double CPU's can be upgraded to 4 GB ram each.


EDIT:
<<MODS PLEASE MOVE TO TECHNICAL & SECURITY FORUM>>

Microsol, if you're looking for performance, i'm not very experienced in heavy clustering situations, or with some of the windows SQL, and related matters, but you might want to look past the dual p3 setup to dual MP setup. MP's are just like athlon XP's, and asus makes some nice boards to accmodate 2 of those, you'll likely get a lot more bang for your buck, unless you want to fit into a 1u case (which i doubt is possible).

You might also want to put a scsi drive on the mailservers, i've found that web servers don't do as many reads because most people have static content that gets stuffed into ram, but mailservers drives (from past experiences) seem to get very worn, millions of small requests :)

Hope that helps.