Taking backups using mydumper

mydumper is a logical backup tool that's similar to mysqlpump.

mydumper has these advantages over mysqldump:

• Parallelism (hence, speed) and performance (avoids expensive character set conversion routines and has efficient code overall).
• Consistency. It maintains snapshots across all threads, provides accurate master and slave log positions, and so on. mysqlpump does not guarantee consistency.
• Easier to manage output (separate files for tables and dumped metadata, and it is easy to view/parse data). mysqlpump writes everything to one file, which limits the option of loading selective database objects.
• Inclusion and exclusion of database objects using regex.
• The option to kill long-running transactions that block the backup and all subsequent queries.

mydumper is an open source backup tool, which you need to install separately. In this section, installation steps on Debian and Red Hat systems and the usage of mydumper will be covered.

How to do it...

Let's start with the...