Percona xtrabackup knowledgebase

MySQL & MariaDB Percona XtraBackup
1

Hi All

As i want to acquire some knowledge about percona xtrabackup as i have already read about before and i want to know about xtrabackup performance when compared with mysqldump. Is this right where we can have some differences b/w these two. can you tell some tips and any references for implementing xtrabackup in my opensource project.

2

Hi sekhar;

Percona has a lot of great guides for getting started with the basics of Xtrabackup:
[url]Percona XtraBackup

I would start by taking a look at those guides, and then see what specific questions you have.

As far as performance goes, generally speaking, the larger the dataset, the quicker Xtrabackup would be when compared to mysqldump (simply based on the way they work; not that one tool is “better” than the other). That aside, these tools have different uses/benefits in general, so I would not necessarily pick one over the other just based on performance.

Below is a section from the official MySQL docs that talks about the various general backup types. When reading it, just know that when they talk about “MySQL Enterprise Backup”, you can substitute that with Xtrabackup, as Xtrabackup basically works the same. This will help you decide what type(s) of backups you really need (i.e. mysqldump=logical backup, Xtrabackup=physical backup).

Backup types:
[url]http://dev.mysql.com/doc/refman/5.5/en/backup-types.html[/url]

Additional mysqldump info:
[url]http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html[/url]

-Scott