A member of Databases team at Box. Percona alumnus, data recovery expert. Running TwinDB on free time.
19 April 01:20 PM - 2:20 PM at Ballroom G
Even without available backups InnoDB's design allows to recover database after many kinds of accidents. The session will cover: * InnoDB files and their formats * Recovery corrupted databases * Recovery after DROP TABLE * Recovery compressed InnoDB tables * Table structure recovery from FRM files and InnoDB dictionary
19 April 04:50 PM - 5:15 PM at Ballroom F
How to take reliable MySQL backups. There are several problems to solve: 1. Full vs Incremental vs Differential backups 2. Streaming incremental copies 3. Protecting backup copies 4. Compression options 5. On-fly backup verification 6. Successful backup restore