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.
Big Data and SQL 