With xtrabackup, it only has to lock tables that aren’t InnoDB, it has the ability to take backups of InnoDB tables *without* taking locks and without any overhead of block device or filesystem snapshots.
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…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup… you’re not using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… Innodb Backups – we mainly use LVM (or other snapshot) based backup which is the most typical solution. The second most common one is cold backup…
