Mydumper RPM Now Available For CentOS/RHEL 6 and 7
Mydumper is a a tool for fast reliable logical backups. It’s an alternative to mysqldump that has many advantages over it, some of which you can find below:
- Unlike mysqldump, mydumper is a multi-threaded backup tool, which makes it a lot faster. This is especially helpful if you have very fast storage like SSDs. And you can utilize it much better with multiple threads.
- The tool produces separate files for separate tables. This way, it’s much easier to restore single tables than with one big monolithic file. You can even chunk the table into multiple files, which is super useful for cases where you have very large tables.
- Mydumper allows for multi-threaded restores, making restores an order of magnitude faster in comparison to restoring from mysqldump produced backups. This is especially true for large datasets.
- The tool provides in-built compression, so that the backup files appear in compressed form.
Up until now, RPMs for mydumper weren’t readily available, but we now provide mydumper RPMs for CentOS and RHEL versions 6 and 7. The RPMs are available from the TwinDB repository.
You can install the TwinDB repository on both the CentOS and the RHEL systems by executing the following command:
sudo yum install https://twindb.com/twindb-release-latest.noarch.rpm
The key we use to sign our packages can be downloaded from here.
Once the repository is setup by installing the package above, installing mydumper RPM is as simple as running:
yum install mydumper
We built the mydumper tool you installed from the TwinDB repository against MySQL 5.6 and tested to work with MySQL 5.6 and Percona Server 5.6. We also plan on releasing mydumper built against MySQL 5.7.