… to stream incremental backups, lifting a limitation from previous versions where it was only possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… information while performing a backup when given the –galera-info option to innobackupex. XtraBackup now supports compressed backups. These backups can be done in… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as …multiple backups, plus there are higher network bandwidth requirements to transfer uncompressed backup. What is about compression tool ? The classical tool used for backup compression…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
If someone asks me about MySQL Backup advice my first question would be if they have LVM … based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while…. Easy to Integrate Do you want to compress backup ? Backup it to tape, FTP or any network backup software – it is easy as you…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable …Com_assign_to_keycacheblogpercona.commanual Com_backup_tableblogpercona.commanual Com_beginblogpercona.commanual …commanual skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona….
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is… tool could both update the backup and store the rollback changes or if dealing with read-only compressed backup create the roll-forward recovery log, which also can be easily compressed. What tool would need…
Post: Living with backups
November 6, 2008 By 28 Comments
… 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-tools/write_backup.sh This will read /mnt/snapshot/mysql directory at 15000000 bytes…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… at Launchpad. Bugs Fixed Streaming backups did not work for compressed InnoDB tables due to missing support for compressed pages in tar4ibd. Bug…). The –slave-info option now works correctly with –safe-slave-backup when either –no-lock or –incremental is also specified. Bug… tablespaces. Note that this fix may not work correctly with MySQL 5.5 or Percona Server 5.5 prior to version…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… InnoDB Hot Backup online backup. 2) Do we need to run patched MySQL, because the build instruction mentions the patch for MySQL ? A: xtrabackup… of MySQL: community release, enterprise release, percona builds, ourdelta distributions. You do not need to patch MySQL to run backup. The patch for MySQL… in InnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape, or compressed without needs to…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…-slave-backup-timeout to innobackupex. (Daniel Nichter) Other Changes Eliminated some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL… quoted. Bug #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5…
