Purpose to convert existing apps (Visual Interdev) on Microsoft NT4 using IIS4 (database is Ms.SQL 6.4) to Linux.

Current Information
Current server = Dual Pentium III processor
RAM = 512MB
HardDisk = 16GB SCSI
Userbase = 16,000
Concurrent user = 200 - 300
Application = Leave, overtime, and all webbased application.


I intend to use Linux but which Linux flavor is best suited for this? What server specs? Should I use MySQL? I intend to use PHP as the scripting langague.

Any suggestions would be great.

Well, I personally love RedHat Linux, but many people prefer Free/OpenBSD

Oh, as for database software.. I recommend MySQL or PostgreSQL.

I'd deffinitely reccomend PostgreSQL.

I have to agree with earlier posters, I'd be really worried about doing this sort of job on linux or mysql. I'd go with FreeBSD and postgresql.

Where can I find more info about PostgreSQL? and is it capable of handling 300 concurrent users?

Originally posted by certify
Where can I find more info about PostgreSQL? and is it capable of handling 300 concurrent users?

www.postgresql.org would be a good start. And it is just as capable of handling lots of concurrent users as mysql is, with the added advantage of avoiding database corruption if the system ever crashes.