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.

 

C book

 

Comments




or email your comment to: comments@i-programmer.info

 

Banner


TypeScript 5.5 Adds ECMAScript Set Support
11/06/2024

TypeScript 5.5 is now available as a release candidate. This version adds support for the proposed ECMAScript Set methods, as well as inferred type predicates and the ability to narrow expressions for [ ... ]



Get Started With Ollama's Python & Javascript Libraries
03/06/2024

New libraries allow you to integrate new and existing apps with Ollama in just a few lines of code. Here we show you how to use ollama-python and ollama-javascript so that you can integrate Ollama's f [ ... ]


More News

Last Updated ( Monday, 01 April 2013 )