Over a million developers have joined DZone.

Infographic: MySQL Disasters in the Cloud

· Cloud Zone

Download the Essential Cloud Buyer’s Guide to learn important factors to consider before selecting a provider as well as buying criteria to help you make the best decision for your infrastructure needs, brought to you in partnership with Internap.

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 Internap. Read Bare-Metal Cloud 101 to learn about bare-metal cloud and how it has emerged as a way to complement virtualized services.


Published at DZone with permission of Avi Kapuya, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}