yagodin-men / surrogate Goto Github PK

A simple bash wrapper for Percona's Xtrabackup utility.

• 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)

bash 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.

Main configuration file

• /etc/surrogate/surrogate.conf

/var/backups/db/percona/ (customizable data directory)
|-- daily
|   |-- Fri
|   |-- Mon
|   |-- Sat
|   |-- Sun
|   |-- Thu
|   |-- Tue
|   `-- Wed
|-- monthly
|-- weekly
|-- log
|-- tmp

• 7 days
• 4 weeks
• 6 months

• Loren Carvalho
• Jesse R. Adams
• Ivan Y.

GPLv3