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

xtrabackup - is it a complete replacement for innobackupex?

hydrapolichydrapolic EntrantCurrent User Role Beginner
For some time, we've been using innobackupex an it works great (thanks for it). I saw that innobackup is deprecated and should be replaced with xtrabackup binary, but according to the documnetation, that could not backup anything besides InnoDB. I was thinking some other "wrapper" will be introduced, but I didn't find anything.

Today I just blindly tried out xtrabackup and it seems like it backups also frm, myisam...

...
160902 06:03:38 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
160902 06:03:38 Executing FLUSH TABLES WITH READ LOCK...
...
160902 06:03:38 [01] Copying ./mysql/column_stats.MYD to /backup/mysql/column_stats.MYD
160902 06:03:38 [01] ...done
160902 06:03:38 [01] Copying ./mysql/column_stats.MYI to /backup/mysql/column_stats.MYI
160902 06:03:38 [01] ...done
160902 06:03:38 [01] Copying ./mysql/column_stats.frm to /backup/mysql/column_stats.frm
160902 06:03:38 [01] ...done
160902 06:03:38 [01] Copying ./mysql/columns_priv.MYD to /backup/mysql/columns_priv.MYD
160902 06:03:38 [01] ...done
160902 06:03:38 [01] Copying ./mysql/columns_priv.MYI to /backup/mysql/columns_priv.MYI
160902 06:03:38 [01] ...done
160902 06:03:38 [01] Copying ./mysql/columns_priv.frm to /backup/mysql/columns_priv.frm
...
160902 06:03:40 Executing UNLOCK TABLES
160902 06:03:40 All tables unlocked

Should the documentation (https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup_bin/limitation.html) be updated then?

Thanks

Comments

  • ShahriyarRShahriyarR Contributor Inactive User Role Beginner
    Yes it is.
    Xtrabackup is a complete replacement for Innobackupex and in fact with newest version innobackupex is a symlink:
    [root@ps-pxb-5 bin]# ls -l
    total 60128
    lrwxrwxrwx. 1 root root       10 Aug 31 16:46 innobackupex -> xtrabackup
    -rwxr-xr-x. 1 root root  3991760 Aug 31 16:39 xbcloud
    -rwxr-xr-x. 1 root root     3020 Jul 19 18:28 xbcloud_osenv
    -rwxr-xr-x. 1 root root  3874930 Aug 31 16:39 xbcrypt
    -rwxr-xr-x. 1 root root  3912393 Aug 31 16:39 xbstream
    -rwxr-xr-x. 1 root root 49776302 Aug 31 16:44 xtrabackup
    

    I have created a doc issue to update documentation. Thank you.

    https://bugs.launchpad.net/percona-xtrabackup/+bug/1620521
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.