1. TwinDB Talks On Percona Live 2016

TwinDB Talks On Percona Live 2016

planets

Percona Live is Christmas in the MySQL world. Naturally, it’s the time when friends and family come together. Everyone is talking about achievements of the year and making New Year’s resolutions.

TwinDB at Percona

This year, TwinDB does two talks. One about data recovery and the other about backups.

The first one will be a bit traditional. I will briefly cover the InnoDB files format, so you know where to look for data. I will show you how to recover data from two of the most popular accidents: InnoDB tablespace corruption and DROP TABLE (or DROP DATABASE) Data recovery is impossible without the table structure recovery. Therefore, I will show you how to get the structure from an .frm file or from the InnoDB dictionary (think of DROP TABLE when the .frm file is gone).

We made a drastic improvement in user interface last year. Now, the data recovery toolkit is available online. Data recovery with a few mouse clicks? Easy! Come over on Tuesday after lunch.

Finally, the second talk will be about MySQL backups. It features a rockstar speaker, my colleague from Dropbox and Percona Peter Boros!

Percona’s XtraBackup became a standard de facto for backing up MySQL databases. We collected our experience with XtraBackup and compiled a set of recommendations. They will guide you through the backup process. Among other things, Peter will talk about:

  • What’s better: incremental or differential backups, how to do either of them
  • Compression
  • Encryption
  • Backup transfer
  • Backup preparation
  • Indicative benchmarks (how fast you can take, compress, encrypt and transfer backups)
  • How to actually verify your backups so you don’t become our data recovery customer.

Check it out on Tuesday night, right before the evening beer session.

 

Previous Post Next Post