Quote:
Originally posted by fuzebox
No, he's right, better to get ONE BIG server to do it all.
It'd be more efficient to run web and database on the same server too!
|
How do you figure one server is better? Replication allows you to tailor each servers parameters to the needs of the client. Some queries run slow and infrequently, others run fast and often, and you've got writes which are a whole different issue. One configuration will probably not work the best for all queries. It also gives you redundancy and allows you to get much more bang for the buck. Do you get more processing power from one $10K server or ten $1k server?
As for web and database on the same server, if you're running a small site it certainly is more efficient. If you're doing any sort of traffic you're best off running them seperate (and probably running seperate webservers for static and dynamic pages). Any savings by running both on the same server are miniscule. Not to mention if you're that concerned with efficiency round robin dns is NOT the way to go.