Mydumper (aka. MySQL Data Dumper) is a high-performance multi-threaded backup (and restore) toolset for MySQL and Drizzle.  The main developers originally worked as Support Engineers at MySQL (one has moved to Facebook and another to SkySQL) and this is how they would envisage mysqldump based on years of user feedback.

Mydumper features

  • Lightweight C source
  • Up to 10x faster dumps compared to mysqldump
  • Consistent snapshots for transactional and non-transactional tables (in 0.2.2 onwards)
  • File compression on-the-fly
  • Binary log dumps
  • Multi-threaded restore utility (in 0.2.1 onwards)
  • Daemon mode for timed snapshots and continuous binary logs (in 0.5.0 onwards)
  • Open Source! (GNU GPLv3)

Mydumper is still under active development but is well tested/used in production on some large installations.

DB | 评论(0) | 引用(0) | 阅读(6653)