Percona XtraBackup for MySQL

You can use Percona XtraBackup to perform a physical backup of a MySQL datadir without stopping client access. This backup process is much faster than using mysqldump.

If you wish to install it on Linux/Debian/Ubuntu, follow the instructions here. I’ll show you how to install it on a Mac in this blog.

User@Mac% brew install percona-xtrabackup

If you haven’t installed brew on your mac, it will throw the following error
zsh: command not found: brew

Use the following commands to configure homebrew:

echo ‘eval “$(/opt/homebrew/bin/brew shellenv)”‘ >> /Users/youruser/.zprofile
eval “$(/opt/homebrew/bin/brew shellenv)”

Once the above commands are executed, you will be able to execute the brew install command as stated above. This will install the xtrabackup tool on your machine. To check if the installation is succeeded, please execute the below command:

User@Mac% xtrabackup

It will let you know where the xtrabackup is installed, its version, default options, and the available variables that can be used as arguments.

Hope you find this article helpful.

Please subscribe for more interesting updates.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s