Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Backups, restores and clones for fun and profit

Backups, restores and clones for fun and profit

 20 April 02:00 PM - 02:50 PM @ Ballroom G
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations and Management
Topics:
MySQL
Devops
Tools and Techniques

Description

Nobody cares about backups. Everyone should care about restores. This talk is about improving MySQL backup solution to shift focus from making backups to restoring them. Spilgames backup solution uses BackupPC, Xtrabackup, mysqldump, Glacier and just a bunch of shell/python scripts. To improve the quality on storing the xtrabackup dumps on disk at the backup host we set up an automated restore system and a way to clone production databases to staging. I'll tell how we did that, what kind of checks we run, what problems were overcome along the way. Not to forget the the awesome power of chatops which let us easily enable developers to clone production to staging and download database dumps to their devboxes at will.

Speakers

Jaakko Pesonen's picture

Jaakko Pesonen

Senior DBA, Spil Games

Biography:

Senior MySQL DBA with systems engineering twist. At the moment trying to automate his current job away. Dreams of future, where many database related menial tasks simply do not exist anymore and aims to be part of the solution. Jaakko started his DBA career by being a part of a duo, that brought order to an unmanaged database environment consisting of nearly 200 databases on five different RDBMs. That led him to first specializing in MySQL administration and later joining the DBA team at Spil Games after short stint at setting up highly available hosting environment for a new product in a small startup with big client.

Share this talk


Slides