John Babb johnbabb
johnbabb
/ percona-xtrabackup.sh
Created
December 1, 2016 17:08
— forked from jaygooby/percona-xtrabackup.sh
Call via crontab on whatever schedule suits you; keep n full mysql Percona xtrabackups of your mysql database, with binary logs applied. Also does a full mysqldump that can then have the binary logs applied to restore to a point-in-time backup via the binlogs. Copy all of this (backup, mysqldump, binlogs) to S3.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # Carries out a full mysqldump, calls percona-xtrabackup and then | |
| # copies the sql dump, the percona backup and your mysql bin logs | |
| # to S3 using s3cmd http://s3tools.org/s3cmd | |
| # | |
| # TODO: extract out the S3 backup stuff to make it optional, and so | |
| # other s3 programs can replace the s3cmd call. | |
| # TODO: the if [ $? == 0 ] alert blocks should be a function | |
| # TODO: make the if [ $? == 0 ] if [ $? != 0 ] more consistent - test |