Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Resurrecting a MySQL Database from the Dead

Resurrecting a MySQL Database from the Dead

 20 April 01:00 PM - 01:50 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations and Management
Topics:
MySQL
Devops
Tools and Techniques

Description

You're sitting in a meeting when your phone alerts you to a page you've received. Somewhere in your datacenter, evil is afoot. You pull out your laptop and try to connect to the database: no luck. SSH: swing and a miss. You look at the console logs and your worst fears are realized. In this presentation we'll walkthrough how we took a machine with a failed RAID card and restored all the data on that machine without any data loss using techniques available to you in Percona Server and how at New Relic we not only did this in production but we automated it as well.

Speakers

Jesse Dearing's picture

Jesse Dearing

Senior Database Engineer, New Relic

Biography:

Jesse is a Senior Database Engineer at New Relic where he spends time wrangling MySQL, Postgres, and Cassandra at scale. This works well because he does have an interest in databases, their internals and how to hack things for mostly fun and sometimes even profit. In addition, Jesse has an interest in bicycles, coffee, beer, and artisnal baked goods. Jesse spends his free time with his wife and son in Portland, OR.

Share this talk


Slides