What is mydumper? Why?
- 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.