Home

What is MyDumper?

MyDumper is a Logical Backup Tool. It has 2 tools:

• mydumper which is responsible to export a consistent backup
• myloader reads the backup from mydumper, connects the to destination database and imports the backup. Both tools use multithreading capabilities

Why do we need MyDumper?

• Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
• Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
• Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc
• Manageability - supports PCRE for specifying database and tables inclusions and exclusions

Should I use MyDumper on a production environment?

It is not easy to answer this question. We are not going to consider MyDumper to be production ready until we release v1.0.1. This doesn't mean that MyDumper is not a trustable tool that can not be use on a production environment. The problem is the amount of moving parts inside mydumper and myloader that can cause undesirable results, like inconsistencies on restores, performance issues, unusable backups, etc.

We consider that v1.0.1 will be released when can achieve the next goals:

• More testings: we know that we have a lot of use cases and we need to cover as much as possible.