Biggest SQL Disasters
Written by Kay Ewbank   
Monday, 01 April 2013

I doubt if there’ll ever be a film version of ‘When Databases Go Bad’, but the people at Xeround have done a good job of making MySQL failures seem a bit more dramatic than usual.

The infographic from Xeround shows ‘the Biggest MySQL Disasters of All Time’, with earthquake magnitudes attached to the various failures.

Top at Magnitude’s 10 and 9 are two Amazon Web Services outages. Whether these are really the biggest disasters of all
time is debatable, but it makes interesting reading in a scary sort of way. Maybe there is scope for that movie, presumably with Jeff Goldblum playing the cool-headed database administrator who saves the day by rebuilding the indexes and getting things back on line.

Click for a full resolution PDF

mysql-disasters

 

The ‘lessons learned’ analysis of the database outages could well raise a hollow laugh if you’re a database developer; most of the companies say they’re going to put a lot more emphasis on doing proper backups. They are probably going to get more exercise, lose weight and be kinder to their mothers, too.

Xeround offers a cloud database service that guarantees high availability, so has a certain interest in making you feel nervous when the lights on the database server dim and flicker. 

 

mysql-disastersicon

 

However, the outages described are real enough, and some more in depth analysis of problems is drawn from a Percona White Paper on research into causes of downtime in MySQL.

More Information

Xeround

Percona White Paper

Related Articles

Fedora May Replace MySQL With MariaDB       

MySQL 5.6 Released       

Codd and his Rules    

  

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, FacebookGoogle+ or Linkedin,  or sign up for our weekly newsletter.

 

blog comments powered by Disqus

 

Banner


Cat Photos - A Potential Security Risk?
27/07/2014

A website called I Know Where your Cat Lives uses the latitude and longitude metadata from photos of cats posted websites like Flickr to place the photos on Google maps with remarkable accuracy. Shoul [ ... ]



PHP Gets A Formal Specification
31/07/2014

Given how important PHP is in terms of its use, it is very surprising to learn that it only now is getting a formal specification after 20 years of use. 


More News

Last Updated ( Monday, 01 April 2013 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.