Which is the fastest, most reliable, and working method to produce physical database backups?
Options from the top of my mind:
- lvm snapshots (or other snapshotting technology)
- cold backups
The 3 of them have been (or still are) in use at WMF in the past.
Either could be combined (or not) with a delayed slave system.
The method should be automatizable and have a small disk footprint. Features should be evaluated and compared for what we want to do: fast recovery and in the future, automatic provisioning of crashed and new hosts.