Skip to content

Slipped & DROP'd your TABLE? Recover w/TwinDB's Undrop for InnoDB toolkit

Photo of Mike Tougeron
Hosted By
Mike T. and Erin O.
Slipped & DROP'd your TABLE? Recover w/TwinDB's Undrop for InnoDB toolkit

Details

Overview:
TwinDB data recovery toolkit is set of tools that help recover dropped or corrupted InnoDB tables.

The session covers format of InnoDB table space, B+tree index, page and record, structure of InnoDB dictionary.

Typical failure scenarios will be reviewed: DROP DATABASE/TABLE, tablespace corruption, wrong DELETE or UPDATE.

There will be demo where we will drop a table and recover its structure from InnoDB dictionary and recover its data.

If you want to bring a laptop and follow along here's what you need:

  1. Linux machine of favorite flavor: Redhat, Debian, Ubuntu Amazon Linux are supported. But 64 bit only.
  2. Source code of the toolkit. To download it run:
    bzr branch lp:undrop-for-innodb
  3. Software and tools:
    bzrmake
    gccbisonflexMySQL server.

Run make in undrop-for-innodb, it should compile w/o errors.

Bio:
Aleksandr has been working on MySQL data recovery since 2008 while he worked for Percona.
In 2014 he joined Dropbox DBA team and founded TwinDB that provides backup and data recovery services.

Agenda:
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation
8:00 - 8:30 -- General discussion/Q&A/networking/etc.
8:30ish -- post-event socializing... aka beers someplace nearby

Sponsors:
Percona (http://www.percona.com/) is the oldest and largest independent MySQL support and consulting company, with a global 24×7 staff of over 40 people serving more than 1000 customers (http://www.percona.com/about-us/customers/) in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity. Anyone can claim expertise, but we show our abilities by creating open-source (http://www.percona.com/software/) software for MySQL users, writing industry-leading books (http://www.percona.com/about-us/books/), and publishing original research on the widely read MySQL Performance Blog (http://www.mysqlperformanceblog.com/). We also organize the Percona Live (http://www.percona.com/live/) series of conferences to share what we know.

O'Reilly Media (http://oreilly.com/) spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.

Photo of #SFMySQL Meetup group
#SFMySQL Meetup
See more events
#SFMySQL Meetup
Photo of #SFMySQL Meetup group
No ratings yet
Lithium Technologies
225 Bush St., 14th floor in the Prometheus meeting space · San Francisco, CA