Backups, restores and clones for fun and profit
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.
Senior DBA, Spil Games
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.