| Snapshot
Options |
|
|
|
|
|
|
|
|
|
|
|
|
| • | Take master off-line |
||||||||||
| – | Use tar/zip/etc to grab all the data |
||||||||||
| – | Include InnoDB/BDB data files/logs |
||||||||||
| – | Very fast, no contention problems |
||||||||||
| • | Keep master on-line |
||||||||||
| – | Use mysqlsnapshot to grab the data |
||||||||||
| – | Tables will be read-locked |
||||||||||
| – | Relatively fast |
||||||||||
