… are just too useful for backups (most apply also for btrfs). Let’s review them. Snapshots ZFS does snapshot, like LVM but… since it is a copy on write filesystem, the snapshots are free, no… snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… I used: Locate an existing snapshot that contains the schema you are interested in (/tmp/snapshot/2013-06-03_11-30/orig… Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex –apply-log –export /tmp/snapshot/2013… the .exp and .ibd files from the snapshot to the new instance: cp /tmp/snapshot/2013-06-03_11-30/orig/*[.exp…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…: Percona XtraBackup 2.1.2 would hang when performing State Snapshot Transfer. Bug fixed #1182698. Release notes with all the bugfixes… hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the following benefits: Backups that…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup… extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot campatibility – this is obvious…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… space do you need for undo. LVM Snapshot works kind of like Multi Versioning in Innodb – when you write the new data… volume per second. Now keep in account Innodb double write buffer (so writes to Innodb tablespace are double) and the fact you… you better to use your experience – run the backup and see how snapshot growths during the process so you can see how…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
… LVM gives very high penalty when snapshots are enabled (leave along if you try to run backup at this time) and so… still astonishing. The final run I did is emulating how Innodb would do buffer pool flushes – calling fsync every 100 writes… of this behavior you may consider not starting backups instantly after LVM snapshot is creating but allowing it to settle a bit…
Comment: 10 things you need to know about backup solutions for MySQL
March 4, 2009 By 23 Comments
… take InnoDB backups by copying the files, as long as a) MySQL is shut down, OR b) you’ve taken a filesystem snapshot with something like LVM or a SAN snapshot. The bad backup software just copies the files while the server is running (which won’t give a usable backup for…
Post: Living with backups
November 6, 2008 By 28 Comments
…: /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… it right. Even though it’s always the case for InnoDB tablespaces, other MySQL data files do not comply with this…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical… tool, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB…
