… a lengthy “warm up” time. If provisioning a slave, this means your new slave will end up with a warmed up buffer… was only possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup… at once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility is added This utility has…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to … Xtrabackup. Many other tools have similar option. This option can be especially helpful when backing up data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… the appropriate xtrabackup binary. The tests live in dbqp/percona_tests/xtrabackup_basic and are named basic_test.py and slave_test.py, respectively. To run them: $./dbqp.py –suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… online Percona XtraBackup documentation. This release is purely composed of bug fixes and is the current stable release of Percona XtraBackup. In this release we now compile the xtrabackup binary against more recent MySQL and…, it would erroneously try to restart the slave if the host was not a slave, causing innobackupex to exit with a non…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… passed directly to the xtrabackup binary. (Vadim Tkachenko) Added option –safe-slave-backupto innobackupex. (Daniel Nichter) Added option –safe-slave-backup-timeout to innobackupex. (Daniel Nichter) Other Changes Eliminated some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… to a regression introduced in XtraBackup 1.6.2, innobackupex –copy-back did not work if the xtrabackup binary was not specified explicitly with the –ibbackupoption. Bug Fixed: #817132 (Alexey Kopytov). The –slave-info option now…, #745168, #849872, #785556 (Ignacio Nin) Improvements and fixes on the XtraBackup Documentation: #837754, #745185, #836907 (Rodrigo Gadea) More Information For more…
Post: Btw xtrabackup is not only backup..
May 7, 2009 By 12 Comments
… understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done…. Here is command innobackupex-1.5.1 –stream=tar /tmp/ –slave-info | ssh user@DESTSERVER “tar xfi – -C /DESTDIR” When it…
Post: XtraBackup 1.6.4 respin
December 22, 2011 By 2 Comments
Very shortly after the XtraBackup 1.6.4 binaries hit the downloads site and repositories, … start a slave from a backup. This was caught and fixed really quickly and we’ve re-spun the XtraBackup 1.6… backup produced with the faulty version will have “xtrabackup ping 5″ in the xtrabackup_binlog_info file As I mentioned before, the…
Post: Hint: throttling xtrabackup
May 20, 2009 By Leave a Comment
Using xtrabackup for copying files can really saturate your disks, and that … -” , read may be so intensive so your mysqld feels impact, slave getting behind, etc… For this there is a nice small…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, and it is quite easy to add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is… big difference – with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception of a network packet (not… during this period. I believe that, with integration with Percona XtraBackup and its incremental backup features, it is possible to have…
