Hi all,
I am developing a simple online multiple quiz that runs during a specific hourlong time period.
There is a login system that users will be able to setup anytime before the quiz occurs. I will be keeping record of each user's answers, and would like live stats of the current best score for having completed the quiz, as well as current stats for each question's answers.
The catch here is that the traffic is going to be HUGE. We expect 20,000 users all trying to login and start the quiz at the same time.
The actual pages of the quiz will be extremely simple, with almost no graphics, and we will be having around 10 questions per page. Furthermore, the "bandwidth" itself will be virtually unlimited.
Which finally brings me to my question -- I would like to do this in PHP/MySQL...is this unrealistic? It's mainly that first minute when lots of people are trying to login, when the problems will occur.
1. Am I crazy to imagine being able to do this on a single server (to keep things simple), with a single mySQL database.
2. If I need to use more than one machine, how would you recommend doing it?
I am open to all suggestions, requests for clarifications, etc, etc.
Thanks for any help,
michael
I am developing a simple online multiple quiz that runs during a specific hourlong time period.
There is a login system that users will be able to setup anytime before the quiz occurs. I will be keeping record of each user's answers, and would like live stats of the current best score for having completed the quiz, as well as current stats for each question's answers.
The catch here is that the traffic is going to be HUGE. We expect 20,000 users all trying to login and start the quiz at the same time.
The actual pages of the quiz will be extremely simple, with almost no graphics, and we will be having around 10 questions per page. Furthermore, the "bandwidth" itself will be virtually unlimited.
Which finally brings me to my question -- I would like to do this in PHP/MySQL...is this unrealistic? It's mainly that first minute when lots of people are trying to login, when the problems will occur.
1. Am I crazy to imagine being able to do this on a single server (to keep things simple), with a single mySQL database.
2. If I need to use more than one machine, how would you recommend doing it?
I am open to all suggestions, requests for clarifications, etc, etc.
Thanks for any help,
michael