{"id":95102,"date":"2022-11-22T08:54:08","date_gmt":"2022-11-22T08:54:08","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=95102"},"modified":"2022-11-22T08:54:08","modified_gmt":"2022-11-22T08:54:08","slug":"backing-up-mysql-part-4-mydumper","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/backing-up-mysql-part-4-mydumper\/","title":{"rendered":"Backing up MySQL Part 4: mydumper"},"content":{"rendered":"

There are many tools we can use to back up our MySQL databases. Some are well-known and used by the best technology companies out there (<\/span>mysqldump<\/span><\/code> comes to mind<\/span><\/a>), and some are a little less famous, but still have their place in the MySQL world. Enter <\/span>mydumper<\/span><\/a><\/code> \u2013 the tool is built by the engineering team over at Percona and it\u2018s supposedly created to address performance issues caused by <\/span>mysqldump<\/span><\/code>.<\/span><\/p>\n

Prerequisites and Installation<\/span><\/h2>\n

mydumper<\/span><\/code> is a tool that lets people take logical backups of their MySQL databases. The tool is built according to the best MySQL practices, it\u2018s being actively maintained, and works on all flavors of MySQL, including Percona Server and MariaDB. Note that the tool is not built-in to MySQL \u2013 to use it, one needs to install the <\/span>development versions of MySQL<\/span><\/i> or any of its flavors, install a couple of development tools, and install the development versions of <\/span>GLib<\/span><\/a>, <\/span>ZLib<\/span><\/a>, <\/span>PCRE<\/span><\/a>, and <\/span>ZSTD<\/span><\/a> \u2013 once all of these libraries are installed, we should follow the instructions for installation that are available <\/span>here<\/span><\/a>.<\/span><\/p>\n

All of these libraries accomplish specific goals \u2013 GLib is a bundle of libraries, ZLib is used to compress data, PCRE stands for \u201ePerl-Compatible Regular Expressions\u201c, and ZSTD \u2013 otherwise known as ZStandard \u2013 is a compression algorithm developed by Facebook.<\/span><\/p>\n

The installation of <\/span>mydumper<\/span><\/code> will provide us with:<\/span><\/p>\n