TwinDB talks on Percona Live 2016
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 TABLE or
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 (think of
DROP TABLE when the .frm file is gone). We made a drastic improvement in user interface last year. Now data recovery toolkit is available online. Data recovery with few mouse clicks? Easy! So, come on Tuesday right after the lunch and check it out.
Second talk is about MySQL backups. It features a rock star speaker, my colleague from Dropbox and Percona Peter Boros!
Percona’s XtraBackup became the standard de facto for backing up MySQL databases. We collected all our experience with XtraBackup and compiled it in a set of recommendations on how to do each step of backup process right way including, but not limiting to:
- What’s better incremental or differential backups, how to do either of them
- How to do compression
- How to do encryption
- How to transfer backups
- How to prepare backup
- Indicative benchmarks so you know how fast you can take, compress, encrypt and transfer backups
- And last, but not least is how to actually verify your backups so you don’t become our data recovery customer.
So, check it out in the end of Tuesday, right before the evening beer session.