Hacker News new | ask | show | jobs
by mickeyben 3906 days ago
I've recently created a similar tool at our company.

We found out that dumping the database table by table in a parallelized way is much faster than a full database mysqldump.

There's also mysqlpump soon available in mysql 5.7 to replace mysqldump and works in parallel.

1 comments

Until then, have a look at "mydumper", which does both parallel dumps at a table level, but also chunking, which makes de-duplication possible.