Media Temple has an excellent article on their blog about the abuse of their poor MySQL servers on the “grid”. Their problems stemmed from a new user-base who had poorly performant web-applications:
Having an 8-year history of catering to high-demand websites we thought we had seen it all but this new level of load “requirement” was blindsiding. Our new offering quickly became a refuge for sites that were kicked off their old hosting company; a common industry practice. Because of their high database load “requirements” and need of resources, these site owners were shut down immediately and told to leave other hosts. Many of these “orphaned” users had applications, code, and query instructions that were grossly inefficient for even a massive dedicated server.
This is something sites like Wordpress.com don’t have to worry about, because they’re running their own code. They know they’ll scale by adding more hardware. That’s something harder to say when an idiot who’s hacked their blog software to do 1000s of cartesian joins suddenly connected to a mysql cluster node and takes it down. And if he fails over to another one…
|This entry was posted on Sunday, January 21st, 2007 at 2:28 am and is tagged with grid media, cluster node, query instructions, mysql servers, database load, 1000s, hosting company, web applications, dedicated server, hosts, blog. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback.|