MyDumper is a MySQL logical backup tool that exports consistent database snapshots and imports them using multithreading for parallelism.
The tool addresses the need for fast, manageable MySQL backups by splitting the export and import process across multiple threads. MyDumper exports databases to separate files for each table along with metadata, while MyLoader reads these backups and imports them into a destination database. Consistency is maintained through a snapshot mechanism that acquires a global read lock, reads metadata about master and slave positions, and establishes transactional snapshots across worker threads before releasing the lock and beginning the actual dump work. This approach avoids expensive character set conversion routines and produces output that is easier to parse and manage than monolithic dumps.
MyDumper suits teams running MySQL, MariaDB, Percona, or TiDB who need faster backups than single-threaded tools provide and want finer control over what gets backed up. The tool supports PCRE regular expressions for including or excluding specific databases and tables. It handles Aurora and MySQL 5.7 environments with specific configuration options. Anyone considering adoption should be aware that consistent snapshots currently work only for transactional storage engines, with support for non-transactional engines noted as expected in future releases.
The project maintains active development with regular updates to its documentation and build infrastructure. The tool is community-maintained rather than backed by MySQL, Percona, or MariaDB. Official Docker images are provided for both development builds and quick deployment scenarios. The codebase includes machine-readable JSON logging output for integration with monitoring systems.
