Skip to content

Latest commit

 

History

History
executable file
·
68 lines (47 loc) · 1.51 KB

README.md

File metadata and controls

executable file
·
68 lines (47 loc) · 1.51 KB
Raw

Surrogate

A simple bash wrapper for Percona's Xtrabackup utility.

Bring back life form. Priority One. All other priorities rescinded.

Prerequisites

  • Qpress, included in the installer, otherwise you can get a copy here.

  • Percona 5.5+

  • Percona Xtrabackup 2.0.1 or later

  • Ample disk space (even with compression backups are only 2:1 ratio)

Usage

sh surrogate -<flag> <argument>

  • -h Usage
  • -b Performs a backup, either incremental or full depending on the argument you supply, for example: "surrogate -b full" -- Accepts either "full" or "inc" as an argument
  • -r Restore using default digest location
  • -c Restore, accepts a file containing a list of directories to restore.

Configuration

Main configuration file

  • /etc/surrogate/surrogate.conf

Xtrabackup tuning configuration (for future versions, not currently used)

  • /etc/surrogate/xtrabackup.conf

Retention directory tree

/data (customizable data directory)
|-- backups
|   |-- daily
|   |   |-- Fri
|   |   |-- Mon
|   |   |-- Sat
|   |   |-- Sun
|   |   |-- Thu
|   |   |-- Tue
|   |   `-- Wed
|   |-- monthly
|   `-- weekly
|-- log
|   `-- bin
|-- mysql (or your my.cnf datadir)
|-- tmp

Default rotation policy (configurable in surrogate.conf)

  • 7 days
  • 4 weeks
  • 6 months

Authors

License

GPLv3