3 ms·
This technique using LVM snapshots always struck me as the optimal way to achieve negligible-downtime backups of even largish databases: http://blog.dbadojo.co
by gojomo 18y ago
This technique using LVM snapshots always struck me as the optimal way to achieve negligible-downtime backups of even largish databases:
http://blog.dbadojo.com/2007/09/mysql-backups-using-lvm-snapshots.html http://blog.dbadojo.com/2007/09/mysql-backups-using-lvm-snap...
(Haven't done it myself, though.)
- chrisbolt 18y agoWe've been using this at work for a while now, and it's a good way of getting consistent backups. Only drawbacks are that I think it only works with MyISAM tables, and writes block for a few seconds while the snapshot is created.