Jul 26 2008
Mysql Ultra-Fast Backup with LVM
It is generally good practice to respect the two following points when backing up databases. The backup has to be:
consistent
fast
Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage.
Once a lock has been set on the [...]