Dump and load data with Docker
We deal with a good amount of data at IHME. When I have to migrate data, I use mysqldump , but more recently I have been trying out mydumper and myloader . These two tools are helpful because they allow for:

parallelization of the backup/restore process

output file compression

the output of a single file per table which is easier to manage than the one file per database output of mysqldump .

These new tools are not without issue though. The biggest problem I found with mydumper and myloader is that you have to build the tools yourself. You can run sudo apt-get install mydumper , but that will install an older version that is missing some features and bug fixes. The process of building the tools isn’t a major roadblock, but I don’t want the extra hassle.

The solution I found is to run mydumper and myloader with Docker. By utilizing Docker, I don’t need to mess with building the tools. I only need to have Docker installed and find a Docker image on Docker Hub that suits my needs.

A quick search on Docker Hub indicates that the image below is popular for mydumper and myloader :

https://hub.docker.com/r/mysqlboy/docker-mydumper/
['Brian Dart']
['Technology', 'Tech', 'Docker', 'Database', 'Data']