When your MySQL unexpectedly goes down, how confident are you that your current backup and recovery strategy can quickly get you back in business? MySQL backup and recovery processes are foundational to the success of any application infrastructure and can be the difference between a minor outage and the end of a business. In this webinar, you will gain an understanding of how to approach creating a best-in-class backup and recovery system for your MySQL environment.
Join Akshay Suryawanshi, Percona Remote DBA Team Manager, as he shares backup and recovery best practices gained from working with some of the largest MySQL users in the world.
Topics include:
- Various types of backups: Physical, logical and binlog mirroring
- How Percona XtraBackup, mysqldump 5.6 for binlogs and other backup tools work
- Mydumper advanced features and benefits such as less-locking, save-points and chunks filesize/rows
- How to restore each type of backup, including restoring to a point in time using binlogs
- Using Amazon S3 for a long-term storage
