Well, I am not a database guy myself, but I have worked with some, and I can give some pointers from my limited experience. First off is cost a factor? SQL and other Microsoft licensing is very expensive and requires higher end hardware to run. Where as a Linux solution running MySQL, with many of the free open source standard web front ends and web servers, like Apache would make it cheaper, more streamlined and of course more secure.
Make sure your database is clean and do not allow SQL injection, otherwise your data base can be compromised really fast.
As for the hardware behind it, man, 50k users, at the same time? I would say you would want a bad ass oct-core (dual quad xeons) with at least 4 gigs of RAM and probably some form of RAID 5 running, probably SAS drives. Then of course put it on at least a gigabit backbone.
Heck you may need to cluster a few servers together for that, it is hard to say if one server could handle 50,000 users.
|