BYOND seems like a good place to pose questions like these, since I don't have too many tech savvy friends to turn to.
I'm working on a web service and I want to make sure my design allows for rapid expansion without scaleability issues or the need to rewrite the entire system to work on a cluster of servers.
Rapid expansion meaning jumping from handling thousands to ten thousands of unique visitors a day, to millions of unique visitors per hour.
I'd imagine you would need to have 3-5 servers to act solely as primary databases, then double that to serve as mirrors that only retrieve data and process requests.
Are there any considerations that should be made in regards to database software? Can MySQL handle a job like this?
PHP is not as efficient as something like C, is it worth writing the server side code in a lower level programming language?