4 ms·
FYI: On Linux, you can do instant snapshots with LVM. This is pretty useful as it's possible to snapshot an InnoDB database as it's running without losing data.
by rbranson 16y ago
FYI: On Linux, you can do instant snapshots with LVM. This is pretty useful as it's possible to snapshot an InnoDB database as it's running without losing data.
- davcro 16y agoThis doesn't work at scale. The IO performance with LVM is terrible. I lost a lot of money trying to implement this. Percona wrote Xtrabackup as a replacement for LVM. Documentation: http://www.mysqlperformanceblog.com/2009/02/05/disaster-lvm-performance-in-snapshot-mode/ http://www.mysqlperformanceblog.com/2009/02/05/disaster-lvm-... http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/ http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-op...
- spudlyo 16y agoThe write performance with LVM is terrible. LVM snapshots on read slaves or during times when you have sufficient write capacity work as advertised.