Lukas Vileikis continues a series on backing up MySQL. Part 2 involves Percona XtraBackup:
As already stated above, Percona XtraBackup is one of the primary offerings for MySQL & Percona database administrators developed by Percona. The tool is an open-source backup utility that does not lock our databases during the backup processes it performs. Percona says that their tool can provide automatic verification of backups that have been taken, offer fast dumping and restore times, and above all, it’s supported by their award-winning consulting services helping us make sure that our data and its backups are in safe hands by day and by night.
mysqlpumpis a backup utility that is used via the command-line interface. The tool is very similar to
mysqldumpin that it provides us with the ability to take logical backups, but also different at the same time – the goal of
mysqlpumpis to be an extendable, parallel-supporting replacement of
mysqldump. In their blog from 2015, MySQL team said that one of the primary aims of introducing
mysqlpumpwas not be forced to implement legacy functionality that is provided by
Read on to see how both of these work.