Logical MySQL backup tool mydumper 0.6.2 now availableMax Bubenick
We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups. These new features include enhancements to AWS RDS support and extending TokuDB support.
Due to recent changes (or not so much) on mysql libs, it became impossible to compile mydumper without the complete mysql source code. To simplify this, we had to disable the binlog functionality by default, as it was the one affected by the mysql libs changes. Now you should be able to compile against any mysql version without issues. If you still want the binlog feature, it is still there and you can enable it with:
cmake . -DWITH_BINLOG=ON
The one caveat is that you will need to compile against a mysql version greater than 5.5.34. It’s also possible to compile with binlog enabled against the latest 5.6 versions. In this case, you will need the source code to make some changes. You can find related information about this issue at these locations:
Download mydumper-0.6.2 source code here.
- #1347392 Last row of table not dumped if it brings statement over statement_size
- #1157113 Compilation of latest branch fails on CentOS 6.3 64bit
- #1326368 Can’t make against Percona-Server-devel-55 headers
- #1282862 Unknown type name ‘HASH’
- #1336860 k is used twice
- #913307 Can’t compile – missing libs crypto and ssl
- #1364393 Rows chunks doesn’t increase non innodb jobs
New MySQL Backup Features:
Use LOCK TABLE for all instead of FLUSH TABLES WITH READ LOCK. With this option you will be able to backup RDS instances and also get the binlog coordinates (5.6).
- TokuDB support
Now TokuDB tables are dumped within the consistent snapshot instead of being locked like MyISAM.
- Support to dump tables from different schemas
mydumper has two arguments,
so until now you were able to do;
-B db1 -T t1,t2,tn
To dump a whole database or a list of tables from one database respectively. In 0.6.2 you can list tables in different databases in this way;
NOTE: You should not use
-B here because mydumper will take the
-T list as table names.