Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one.
There will be two talks from TwinDB this year. One is about data recovery and one – about backups.
The data recovery talk is a kind of traditional talk. I will
briefly cover InnoDB files format so you know where to look for
data. I will show how to recover data from two most popular
accidents: InnoDB tablespace corruption and
DROP DATABASE. Data recovery is
impossible without table structure recovery. I will show how to
get the structure from an .frm file or from InnoDB dictionary
DROP TABLE when the .frm file is gone). We
made a drastic improvement in user …