… now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the… will be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the…
Post: Living with backups
November 6, 2008 By 28 Comments
…. Just imagine what happens to all the cached data during backup run when the process is reading several times more information…/snapshot -c -z -v -f – mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql directory… database work so much. ionice -c3 /root/backup-tools/tar … ionice -c2 -n7 /root/backup-tools/tar … Please cosult ionice man page…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… as drop-in replacement of innodbackup tool and InnoDB Hot Backup online backup. 2) Do we need to run patched MySQL, because… xtrabackup contains the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote… not want to deal with bazaar and Launchpad. The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup, at the end of procedure… not want to deal with bazaar and Launchpad. The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can…
Post: Verifying backup integrity with CHECK TABLES
February 1, 2012 By 4 Comments
… is “check your backups for corruption instead of your live server.” You need to do this anyway — a backup that isn’t checked… (at least periodically) that your backups are recoverable. The usual procedure goes like this: copy your backup somewhere, start a server instance… their dev/staging environment every day with last night’s backup, which is a great way to make failures obvious, as…
Comment: Site was down today, support and web hosting.
September 3, 2007 By 27 Comments
Dear Peter, In regards to backups, I should point you in the direction of a product … r1soft.com We’re evaluating it for mysql backups (no load, real awesome live backups), and it’s been very exciting. I myself…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
…/5.6/en/mysqlbinlog-backup.html ). This can be used as a foundation of our live binary log backups. The wrapper script below… still overwritten hence we make a backup first. #!/bin/sh source $1 cd $BACKUPDIR echo “Backup dir: $BACKUPDIR ” while : do LASTFILE=`ls…” mv $LASTFILE $LASTFILE.orig$TIMESTAMP fi touch $LASTFILE echo “Starting live binlog backup” $MBL –raw –read-from-remote-server –stop-never –host…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… undo space, which means LVM is pretty much unusable for backups or required space is very small – created without good understanding… I need 5MB of undo space per second of backup. Now say my backup takes 1 hour which is 3600 second – This… have to be same 15K RPM RAID10 volume your data lives. It can be single SATA hard drive (and so you…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… test of backup + restore: Populate server Take a validation snapshot (mysqldump) Take the backup (via innobackupex) Clean datadir Restore from backup Take restored… MySQL / Percona server and the appropriate xtrabackup binary. The tests live in dbqp/percona_tests/xtrabackup_basic and are named basic…
Comment: Percona XtraBackup 1.4
February 12, 2011 By 10 Comments
Does xtrabackup performs LIVE incremental backup as well? Is -no-lock option works with xtrabackup? I know that it works with innobackupex script but I am not sure if we can perform LIVE incremental backup? Please advise.
