Taking backups using mysqlpump

mysqlpump is a very similar program to mysqldump with some extra features.

How to do it...

There are numerous ways to do it. Let's have a look at each one in detail.

Parallel processing

You can speed up the process of dumping by specifying the number of threads (based on the number of CPUs). For example, use eight threads to take a full backup:

shell> mysqlpump --default-parallelism=8 > full_backup.sql

You can even specify the number of threads for each database. In our case, the employees database is very big compared to the company database. So you can spawn four threads to employees and two threads to the company database:

shell> mysqlpump -u root --password --parallel-schemas=4:employees --default-parallelism=2 > full_backup.sql
Dump progress: 0/6 tables, 250/331145 rows
Dump progress: 0/34 tables, 494484/3954504 rows
Dump progress: 0/42 tables, 1035414/3954504 rows
Dump progress: 0/45 tables, 1586055/3958016 rows
Dump progress: 0/45 tables, 2208364...