Comments on: Tips for taking MySQL backups using LVM

By: LenZ

LenZ — Wed, 04 Aug 2010 08:12:34 +0000

Hi Shlomi! Good post, thanks for providing this background information and the plug for mylvmbackup. I’ve added a link to your post to the “Documentation and Links” section on the project page at http://lenzg.net/mylvmbackup/#Docs

Cheers!

LenZ

By: shlomi

shlomi — Tue, 03 Aug 2010 17:17:54 +0000

@Andrew – more time to suffer, but the pain is lighter. This is my experience.

By: Andrew

Andrew — Tue, 03 Aug 2010 16:08:09 +0000

In many cases, this seems like this technique may lead to priority inversion by increasing the time the snapshot is open and increasing the time for suffering under snapshot write overhead.

By: shlomi

shlomi — Tue, 03 Aug 2010 14:07:32 +0000

@Vojtech,

With regard to XtraBackup: I use it frequently. I’ve had some occasions where, due to problems with innodb tablespace, it was unable to perform the backup (failed either while mid-taking the backup or at recovery time). Failure actually looks more like a bug.

The advantage of LVM snapshot is that it is DB-unaware.

By: Vojtech Kurka

Vojtech Kurka — Tue, 03 Aug 2010 11:39:28 +0000

Some important notes:
– ionice works only with CFQ IO scheduler. However, CFQ is usually not recommended for MySQL
– LVM snapshots are costly, if I was looking for a new binary backup solution, I would choose XtraBackup instead of LVM