Mydumper – MySQL backup tool created by Domas Mituzas and later supported by several other devs.
The main benefits are multi-threaded and fast backups with almost no locking (if not using non innodb tables), built-in compression, separate files for each table, making it easy to restore single tables or schema. It also has support to hard link files which can reduce the space needed for history of backups. Much faster than mysqldump. The main benefit for separate files is the ability to create backups in multiple threads (the same works for restoring process)
In short – Mydumper is how MySQL DBA and support engineer would imagine mysqldump.
To install mydumper follow the next steps
Install necessary devel libs and cmake
yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel cmake |
Download mydumper – https://launchpad.net/mydumper (or directly here https://launchpad.net/mydumper/0.6/0.6.2/+download/mydumper-0.6.2.tar.gz)
Extract the tar.gz archive with
tar -xvzf mydumper-0.6.2.tar.gz cd mydumper-0.6.2 cmake . make |
Creating backup
mydumper -u USER -p PASSWORD -o /home/DESTINATION_DIR/DATABASE/ -B DATABASE |
Note: My advice is to create separate dir for every database.
Restore from backup
myloader -u USER -p PASSWORD -B DATABASE -d /home/SOURCE_DIR/DATABASE/ |