1. mydumper RPM now available for CentOS/RHEL 6 and 7

mydumper RPM now available for CentOS/RHEL 6 and 7

mydumper is a a tool for fast reliable logical backups. It is an alternative to mysqldump and has many advantages over mysqldump some of which are listed below:

    • Multi-threaded backup tool which makes it a lot faster then mysqldump, as mysqldump is single threaded. This is especially helpful if you have very fast storage such as SSDs which can be much better utilized with multiple threads.
    • The tool produces separate files for separate tables instead of one big monolithic file, making it easy to restore single tables. You can even chunk the table into multiple files which is super useful for cases where you have very large tables.
    • The tool 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 are written in compressed form.

Up until now, RPMs for mydumper were not readily available, but we now provide mydumper RPM for CentOS and RHEL versions 6 and 7. The RPMs are available from the TwinDB repository.

The TwinDB repository can be installed on CentOS and RHEL systems by executing the following command:

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:

The mydumper tool installed from the TwinDB repository has been built against MySQL 5.6 and has been tested to work with MySQL 5.6 and Percona Server 5.6. We also plan on releasing mydumper built against MySQL 5.7.

Have a question? Ask the experts!

Previous Post Next Post
  • Excellent thanks for this.. much easier than source compiling 🙂 mydumper is up to 0.9.x versions while you have 0.6.2-2 available. What’s the schedule and plans for 0.9.x ? cheers

    • Hi George,
      The latest stable release of mydumper is 0.6.2. Once 0.9.x is stable we will provide packages for it too.

  • Excellent thanks for this.. much easier than source compiling 🙂 mydumper is up to 0.9.x versions while you have 0.6.2-2 available. What’s the schedule and plans for 0.9.x ? cheers

    • Hi George,
      The latest stable release of mydumper is 0.6.2. Once 0.9.x is stable we will provide packages for it too.

      • Bruce T Jorgens

        mydumper 9.1 was released some time ago, are there still plans to create a .rpm for it?

        • Hi Bruce,

          yes, we have plans to maintain mydumper packages for 9.1 releases. I can’t give ETA though.

          • Bruce T Jorgens

            No worries.
            I was able to install the required packages with yum, download the latest version of mydumper and compile it for both mysql5.6 and mariadb10.1 with the following process:

            yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel cmake gcc gcc-c++

            cd /tmp

            tar xvzf mydumper-0.9.1.tar.gz

            cd mydumper-0.9.1

            cmake .

            make

            make install

            /usr/local/bin/mydumper -V

  • Nate Cummings

    I’m getting the following error when trying to run a mydumper:

    /usr/bin/mydumper: relocation error: /usr/bin/mydumper: symbol mysql_init, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference

    The server is running Percona 5.6 on CentOS 6.7

    Any idea what I need to change? I’d love to be able to use the RPM and not have to compile it.

    Thanks!

  • Fernando Miguel

    Thank you so much!