Yahoo Case Study: MySQL Xtrabackup and its Recovery Scenario
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.
Sr MySQL DBA, Yahoo
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.
MYSQL DBA, Yahoo
MySQL DBA at Yahoo!
Sr. MySQL DBA, Yahoo
MySQL DBA at Yahoo