MySQL & Mydumper

A little while ago we published an article about an open source database utility called "mydumper".  One of the things Mydumper does is clean up a bunch of command line inconsistencies found in the MySQL utilities, making them easier to script, but what it does really well is speed things up! Mydumper does this by parallelizing the operation of dumping and loading database tables. Quite dramatic speedups can be obtained. Along with speeding up  database dumps, Mydumper makes it possible to version control your DB because the database dumps are in one-file-per-table format in a directory. This also makes keeping two large remote databases in sync a little faster (e.g. sync from production to staging). Read more about speeding up your MySQL dump with Mydumper.