Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Yahoo Case Study: MySQL Xtrabackup and its Recovery Scenario

Yahoo Case Study: MySQL Xtrabackup and its Recovery Scenario

 27 April - 11:00 AM - 11:50 AM @ Ballroom B
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
Devops
High Availability

Description

In this case study, we will present Yahoo's backup and recovery strategy. We will present How to optimize backups of large amounts data using full, incremental, compress, parallel options. How to get the consistent backup using slave-info, safe-slave-backup, no-lock How to automate slave rebuild using Xtrabackup How to perform point-in-time-recovery How to monitor and validate the backups How to use multi-source replication to configure the backup server. We will discuss how to implement these strategies in production and we will talk about the operational issues.

Speakers

Yngve Eriksson's picture

Yngve Eriksson

Sr MySQL DBA, Yahoo

Biography:

Over +20 years experience with Oracle, Percona, MariaDb, Tokudb, Cassandra for a handful Startups such as Ironkey, YouSendIt, Hightail and was at Ebay in the early days when it kept growing faster than anyone could predict and avoiding outages on a daily basis.

Kushal Shah's picture

Kushal Shah

MYSQL DBA, Yahoo

Biography:

MySQL DBA at Yahoo!

Stacy Yuan's picture

Stacy Yuan

Sr. MySQL DBA, Yahoo

Biography:

MySQL DBA at Yahoo

Share this talk