-
Notifications
You must be signed in to change notification settings - Fork 440
Home
David Ducos edited this page Mar 31, 2023
·
11 revisions
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
- 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
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.