Over a million developers have joined DZone.

Infographic: MySQL Disasters in the Cloud

· Cloud Zone

Learn about the benefits and drawbacks of microservices with best practices for your own architecture, brought to you in partnership with Iron.io.

Curator's Note: The content of this article was originally written by Avigail Ofer on the Xeround blog.

Anyone who works with databases knows how critical they are to business operations, and how bad it can be when something goes wrong. Millions of individuals and organizations worldwide depend on MySQL, and no one is immune to downtime and data loss – even venerable organizations such as Amazon Web Services, Github and Percona have experienced catastrophic failure of MySQL databases.

  • Interested in seeing the biggest MySQL “earthquakes” of all time? The infographic below tells their stories, including the lessons learned after each database failure, from reputable sources including Wired, Slashdot, TechCrunch and ZDNet.
  • Did you know that data loss and corruption accounts for only 10% of MySQL failures? The rest are due to hardware/OS, performance and replication issues. See this and other interesting statistics further down in our infographic. Data was taken from Percona’s MySQL Failure Causes White Paper.
  • Deleted your InnoDB data file? Don’t worry, you can probably recover it. See this and 7 other common causes of MySQL failure, and how to recover or prevent them altogether. This last part of our infographic was based on Ronald Bradford‘s classic book, Effective MySQL Backup and Recovery.

Here at Xeround, we make MySQL more reliable with a cloud database service that guarantees high availability (even during Amazon outages!) and automatic elasticity with no downtime or application changes. If you want to try disaster-free MySQL on the cloud, create your free database now!

(Click to enlarge infographic)

The Cloud Zone is brought to you in partnership with Iron.io.  Learn about best practices and common pitfalls for working with Iron.io. Avoid the dead ends, and take the enlightened path.


Published at DZone with permission of Avi Kapuya , DZone MVB .

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}