MySQL on the Media Temple GRID

Posted in Blogging, Computers & Technology, Performance, Scalability by Elliott Back on January 21st, 2007.

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.

Viewing 5 Comments

Computer Guru 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

That's a bit of a stretch, don't you think?
WordPress is one of the more in scripts, database wise.
While any forum and many blogs can take a digging on almost any shared server, WordPress will immediately go belly-up.....

reply edit reblog flag

http://neosmart.net/blog/

Elliott Back 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Play around this blog a little bit. I'm 100% sure it can handle a surge of traffic from Digg, Slashdot, anywhere. The only thing that worries me is if all of Akami redirects here, or Amazon hotlinks an image.

reply edit reblog flag

http://elliottback.com

steve 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Actual Media Temple Grid Server Response Times

http://spreadsheets.google.com/pub?key=p-Ab3UaY...

reply edit reblog flag

roflemaster 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

if you think media temple's grid response time sucks you should see their customer service. if they picked up the phone and farted into the reciever i would consider it an improvement over what they have going on now

reply edit reblog flag

Richard 11 months ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

With no improvement in sight. (mt) Media Temple is now all marketing and appearances. The (gs) Grid-Service is a failure. Very nice concept, but unfortunately doesn't work. Their previous shared server solution was brilliant and worked for years, I bought the marketing line and migrated at my own expense to the (gs) and have since experienced the worst downtime, latency and poor support one could imagine.

There was a time when (mt) Media Temple was the absolute best in the industry hands-down, but now they are directly responsible for endless stressful days and nights fielding client calls and emails about how their site or email isn't working. I intend to move my extensive client list off the (gs) and to a more reliable and stable host.

Yes, they have a nice architecturally profound office, an elegant interface for the control panel and account center, but that's now all show and misdirection for a poorly executed shared grid environment. I would much prefer a reliable company with stable hosting that has a gross logo and uninspired control panel if it meant that my client's sites would always be up and their emails never failing.

Company bottom lines are directly affected by downtime and can't be tolerated at any expense, not in today's market and world.

reply edit reblog flag