…compressed backup, performing a compressed/uncompressed incremental backup would fail because xtrabackup_checkpoints was compressed. This has been fixed by omitting xtrabackup_checkpoints from compression…
Post: Living with backups
November 6, 2008 By 28 Comments
… backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files… compressed archive. For example: /root/backup-tools/tar –read-rate=15000000 -C /mnt/snapshot -c -z -v -f – mysql | ssh backup@storage-host /root/backup… full block and then only perform a regular cached read on the last few bytes and append them to the target file. But…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
…and is the current stable release of Percona Xtrabackup. If the innodb_file_per_table server option is being used and… Fixed Streaming backups did not work for compressed InnoDB tables due to missing support for compressed pages … this fix may not work correctly with MySQL 5.5 or Percona Server 5.5…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… InnoDB: Mutexes and rw_locks use GCC atomic builtins 120619 13:21:17 InnoDB: Compressed tables use zlib … pool 120619 13:21:18 InnoDB: highest supported file format is Barracuda. 120619 13:21:18 InnoDB: … threads, c2 and c3 are acting as backup nodes. If you are using HaProxy for MySQL you can break …
Post: Announcing Percona XtraBackup 2.0.3
October 1, 2012 By 1 Comment
… free disk space on the server to copy files. As this option removes backup files, it must be used with caution. Bugs Fixed… incremental backups. Bug fixed #1043762 (Laurynas Biveinis). A regression was introduced in fix for bug #932623 which caused incorrect handling of compressed tablespaces with the page size of 16K, that were created between the last full or incremental and the next incremental backup…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
…time to announce the next version of backup software from Percona – XtraBackup 1.1. … handling barracuda compressed table format Bug #498660: innobackupex doesn’t pass –defaults-files to mysql child proc …on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…the outline of improvements available in MySQL 5.6 which I thought …Innodb – Improvements to Innodb Compression – Fast Page Checksums (CRC32) – 4K and 8K Page sizes for …Partitioned Tables – Remote Binlog Backup – Innodb Transportable Tablespaces – New configuration files defaults – User Defined …
Post: xtrabackup-0.9.5rc
October 24, 2009 By 13 Comments
…of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed …XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/. The Debian package … on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system…
Comment: Living with backups
November 18, 2008 By 28 Comments
…… My new backup slave performs the whole backup (~60GB uncompressed dump, though using on-the-fly compression with Gzip the file end up slightly… performance in all tested kernels – side read operation are fast and MySQL starts lagging slightly. – Using CFQ with default class, side read…
