Friday, January 11, 2013

Backing up Database from EBS to S3


General Steps

  1. freeze the database (flush all tables with read lock)
  2. freeze the file system (xfs freeze)
  3. take the snapshot
  4. unfreeze file system
  5. unfreeze database


Use xfs on EBS and ephermeral volumes (fast to format and supports freezing)

~20MB/sec for a single stream transfer to S3

Snapshots are incremental, compressed and performed in the background by EBS

Snapshots can be corrupt, take them often

No comments:

Post a Comment