MyDumper is a MySQL Logical Backup Tool. It has 2 tools. mydumper which is responsible to export a consistent backup of MySQL databases. myloader reads the backup from mydumper, connects the to destination database and imports the backup. Both tools use multithreading capabilities. MyDumper is Open Source and maintained by the community, it is not a Percona, MariaDB or MySQL product. 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.
Features
- One needs to install development versions of GLib, ZLib, PCRE and ZSTD
- You can build the Docker image either from local sources or directly from Github sources
- Both tools use multithreading capabilities
- MyDumper is Open Source and maintained by the community
- Easier to manage output
- Maintains snapshot across all threads
Project Samples
