Percona XtraBackup is free and open source backup tool for MySQL. Percona distributes XtraBackup via package repositories for RedHat and Debian.

Unfortunately there are no packages for Mac OS. In this post I will describe how to build XtraBackup for Mac OS.

Dependencies

To build and use XtraBackup on Mac OS you need to install some additional packages. I will use MacPorts to install the dependencies.

# port install cmake p5.16-dbd-mysql

Building XtraBackup for Mac OS

Download the source code from https://www.percona.com/downloads/XtraBackup/LATEST/

# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.2.10/source/tarball/percona-xtrabackup-2.2.10.tar.gz

Untar the archive:

# tar zxf percona-xtrabackup-2.2.10.tar.gz

Build the binaries.

# cd percona-xtrabackup-2.2.10
# cmake -DBUILD_CONFIG=xtrabackup_release && make

XtraBackup comes with a perl script innobackupex that can be found in storage/innobase/xtrabackup/. The script is a wrapper around few binaries XtraBackup needs to work. They are built in storage/innobase/xtrabackup/src: xbcrypt, xbstream and xtrabackup.

Installing XtraBackup for Mac OS

To install XtraBackup use a Makefile:

# make -C storage/innobase/xtrabackup/ install

It will install XtraBackup in /usr/local/xtrabackup/ . The binaries will be placed in /usr/local/xtrabackup/bin/ so make sure it’s in the $PATH.

XtraBackup Package

For your convenience we built and packaged XtraBackup for Mac OS. The package installs the binaries in /opt/local/bin which should be in your $PATH. I tested XtraBackup on OS X 10.10 Yosemite.

The post Building XtraBackup for Mac OS appeared first on Backup and Data Recovery for MySQL.