What is mydumper? Why?

Created by Domas Mituzas on on 2009-02-02
Keywords:
Last updated by:
Domas Mituzas on on 2009-02-05

mydumper is complement to mysqldump, for MySQL data dumping, providing:

1. Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
2. Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
3. Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc

It does not support schema dumping and leaves that to 'mysqldump --no-data'

It was born as weekend experiment, and apparently it worked well enough to have public appearance.