First page Back Continue Last page Overview Graphics
Backup Agents and Tools
Raw: Snapshot Gotchas
If backing up or scripting the backup of InnoDB table types, any snapshots are fine since the files on disk can always be considered consistent.
However, when performing LVM/filesystem snapshots on My/ISAM tables, you must first issue a FLUSH TABLES WITH READ LOCKS before starting the snapshot and then an UNLOCK TABLES after the snapshot is complete:
Any Snapshots with My/ISAM table types:
FLUSH TABLES WITH READ LOCK
-do snapshot here-
UNLOCK TABLES
After the snapshot is complete, then you can mount the snapshot and back it up to your backup media.
Notes: