Not the answer you need?
Register and ask your own question!

Percona xtrabackup knowledgebase

sekharsekhar EntrantLegacy User Role Beginner
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.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi sekhar;

    Percona has a lot of great guides for getting started with the basics of Xtrabackup:
    http://www.percona.com/doc/percona-xtrabackup/2.2/

    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:
    http://dev.mysql.com/doc/refman/5.5/en/backup-types.html

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

    -Scott
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.