{"id":10429,"date":"2017-08-07T12:08:59","date_gmt":"2017-08-07T10:08:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/mariadb-speed-up-your-logical-mariadb-backups-with-mydumper\/"},"modified":"2017-08-07T12:08:59","modified_gmt":"2017-08-07T10:08:59","slug":"mariadb-speed-up-your-logical-mariadb-backups-with-mydumper","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mariadb-speed-up-your-logical-mariadb-backups-with-mydumper\/","title":{"rendered":"MariaDB – Speed up your logical MariaDB backups with mydumper"},"content":{"rendered":"

By William Sescu<\/h2>\n

Per default, MariaDB is shipped with a utility called mysqldump for logical backups. For more information, please take a look at the following link.<\/p>\n

https:\/\/mariadb.com\/kb\/en\/mariadb\/mysqldump\/<\/a><\/p>\n

The mysqldump has advantages, e.g. it is easy to use and it is shipped with the standard MariaDB installation. \u00a0So, no additional installation is needed. However, it has also some disadvantages. E.g. it is single threaded and it is \u00a0writing to one big file, even with the latest version which is MariaDB 10.2.7 at the moment.<\/p>\n

In case you want to dump out your data very quickly this can be your bottleneck. This is where the mydumper comes into play. The main feature of mydumper is that you can parallelize it. The mydumper utility uses 4 parallel threads per default if not otherwise specified.<\/p>\n

.\/mydumper --help | grep threads\n  -t, --threads               Number of threads to use, default 4<\/pre>\n
Another cool feature is compression.<\/p>\n
.\/mydumper --help | grep compress\n  -c, --compress              Compress output files<\/pre>\n
The biggest disadvantage is that mydumper is not delivered out of the box. You have to compile it yourself. To do so, simply follow the following steps:<\/p>\n