| Snapshot
Options Contd. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Keep master on-line |
|||||||||||
| – | Use LOAD DATA FROM
MASTER |
|||||||||||
| – | The security tables don’t replicate (bug!) |
|||||||||||
| – | Slowest, because indexes are re-built |
|||||||||||
| – | Best for small data sizes |
|||||||||||
| • | Remember to reset the master’s binlog |
|||||||||||
| – | RESET
MASTER command |
|||||||||||
| • | mysqldump |
|||||||||||
| – | Use for small data |
|||||||||||
