… the already 50% extra I use to avoid mishaps) for LVM snapshotting. Also I’ve just recently started making a separate logical…’s never any going back. So my backup script does this (runs on a dedicated “backup” slave, so the flush tables w… status; >> status.log make lvm snapshot of data partition unlock tables; mount snapshot in snapshots dir copy status.log to snapshot mount After that bacula…
Comment: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… what we’re doing is OK: LVM, XFS filesystem with InnoDB. We simply create an LVM snapshot and then do a file copy… to recover itself from a half-way state if the backup is restored, but it’s ACID so that’s not…, right? A further question if anyone has any insight please: LVM snapshots have been indicated as severely affecting InnoDB performance – however someone…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… in other cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t… and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount of tables… stall if this lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching…
Comment: Disaster: LVM Performance in Snapshot Mode
February 24, 2011 By 55 Comments
… proper solution to create backups of a mysql database with around 150G of data. After some reading LVM snapshots was my first choice as I can’t afford longer downtime. Also logical backups with mysqldump are not… backup of the snapshot. So I guess the only thing helping me out would be something like a backup slave just dedicated for backups…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… files (<16k) creation, no much difference; For large files creation, LVM causes the speed drops from 1300000 to 900000. Random Read… files (<16k) creation, no much difference; For large files creation, LVM causes the speed drops from 3000000 to 2000000. After a…. LVM‘s overhead doesn’t bother me too much and I use LVM snapshot to backup 200G databases. In the production, RAID 5 + LVM (IBM…
Comment: Estimating Undo Space needed for LVM Snapshot
June 11, 2008 By 5 Comments
… time to backup & purge binlogs versus when its time to look for more table storage) but it definitely allows mysql snapshots to… much faster to reinstall from scratch than to restore from backup). This way the logging didn’t compete (as much) with… space. We were also doing LVM snapshots to back up our dbs, but we were using LVM 1, and wrote our own script…
Comment: Using LVM for MySQL Backup and Replication Setup
August 31, 2007 By 53 Comments
[...] google LVM if it’s new to you, then check out the following: MySQL Performance Blog – Using LVM for MySQL Backup and Replication setup Mike Krukenberg’s blog – MySQL Backups using LVM Snapshots nixcraft – Consistent backup with [...]
Comment: Using LVM for MySQL Backup and Replication Setup
August 27, 2007 By 53 Comments
[...] google LVM if it’s new to you, then check out the following: MySQL Performance Blog – Using LVM for MySQL Backup and Replication setup Mike Krukenberg’s blog – MySQL Backups using LVM Snapshots nixcraft – Consistent backup with [...]
Comment: 10 things you need to know about backup solutions for MySQL
March 9, 2009 By 23 Comments
… that I use them regularly to spawn new slaves. Their backup solution works tracking modified blocks in a filesystem (I have… a snapshot of the state of the blocks in the filesystem, and those are the blocks’ versions put into the backup. So, it seems it should be equivalent to a LVM snapshot. The speed of the restore…
Comment: An argument for not using mysqldump
November 18, 2010 By 26 Comments
Andy, other challenge I’ve run into with LVM snapshots is that they really load up the disk subsystem. While … doubling my write iops. To use the snap as a backup, I have to copy it off main system and onto a backup device, which means I have to read hundreds of GB…
