Notes on <High Performance MySQL> -- Ch11: Backup and Recovery

Chapter 11 Backup and Recovery

Overview

Considerations and Tradeoffs

What Can You Afford to Lose?

Online or Offline Backups?

-          Innodb_fast_shutdown

-          FLUSH TABLES WITH READ LOCK

FLUSH TABLES WITH READ LOACK is not as expensive as shutting down, because most of your caches are still in memory and the server is still “warm”.

Logical or Raw Backups?

What to Back Up

Storage Engines and Consistency

Replication

Managing and Backing Up Binary Logs

Backing Up Data

Recovering from a Backup

Backup and Recovery Speed

Backup Tools

Scripting Backups