This session speaks about Innodb database recovery techniques (apart from recovering from back).
First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.
Then we will look at Innodb storage data structure to see what foundations does it has for corruption discovery and recovery.
Then we will go into approaches one can use to recover data including
- Recovering Innodb dictionary running our of sync with .idb files - Recovering minor corruptions using innodb_force_recovery and build-in MySQL Features - Recovering deleted data and dropped tables using Innodb Recovery Tools package - Dealing with complex data loss scenarios such as failed filesystem or failed RAID subsystem.
Peter helped many companies ranging from one man startups to Fortune 500 companies with their Performance and Scaling problems on various stages starting from architecture design and down to queries and schema optimization.
Over cause of the years Peter has spoken on many International conferences focused on MySQL, Open Source, Databases or High Performance Web applications.
Before co-founding Percona Peter worked for MySQL AB as head of High Performance Group being involved in Support, Consulting, Development and working with vendors helping to optimize their software or hardware to perform well with MySQL.
Peter also was involved in number of Web Startups in the roles ranging from CTO to Consultant and has a lot of experience in MySQL and Web Applications Operations, Deployment, Quality Assurance and Development.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at email@example.com
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.