使用 Homebrew 安装 mydumper

项目链接

• 主页

命令和别名

• mydumper
• myloader

项目历史

The project has long occupied the DBA niche between the official mysqldump client and heavier physical-backup systems. Package descriptions and project documentation emphasize separate output files for tables and metadata, consistent snapshots across worker threads, binary log position capture, compression, regex-based selection, and parallel restore. A 2015 Percona post about version 0.9.1 highlighted full schema support in MyDumper/MyLoader, reducing the need to combine MyDumper data dumps with mysqldump schema dumps.

使用方式

In practice, MyDumper is used for fast logical backups, restores, and migrations where SQL-level portability matters but database size makes serial dumps painful. Cloud migration guides from Microsoft describe mydumper/myloader as community tools for large Azure Database for MySQL migrations, including examples that run MyDumper near the source database, tune thread counts, split table data into chunks, compress traffic, and restore with MyLoader on the target. Homebrew, Nix, and Ubuntu package it as `mydumper`, usually exposing the two command-line programs `mydumper` and `myloader`.

来源

• https://community.linuxmint.com/software/view/mydumper
• https://formulae.brew.sh/formula/mydumper
• https://github.com/mydumper/mydumper
• https://learn.microsoft.com/en-us/azure/mysql/migrate/concepts-migrate-mydumper-myloader
• https://mydumper.github.io/mydumper/docs/html/index.html
• https://www.percona.com/blog/logical-mysql-backup-tool-mydumper-0-9-1-now-available/