Steps to Install Percona XtraBackup for MySQL

The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, tightly compressed, highly secure full backups on transactional systems so that applications remain fully available during planned maintenance windows. Percona Xtrabackup also supports incremental backup where it can copy the data that has changed since the last backup. You can have many incremental backups between each full backup. For every incremental backup, you need information on the last one you did so it knows where to start the new one.

Below are the high-level steps we will follow to setup XtraBackup
1. Download Percona XtraBackup repository
2. Install dependent rpms
3. Install Percona XtraBackup package

Step 1. Download Percona XtraBackup repository: Use OS yum command to download Percona XtraBackup repo rpm.

[root@test-machine01 ~]#
[root@test-machine01 ~]# yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
Loaded plugins: langpacks, ulninfo
percona-release-latest.noarch.rpm                                                                                                                                      |  20 kB  00:00:00
Examining /var/tmp/yum-root-0Meokx/percona-release-latest.noarch.rpm: percona-release-1.0-27.noarch
Marking /var/tmp/yum-root-0Meokx/percona-release-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package percona-release.noarch 0:1.0-27 will be installed
--> Finished Dependency Resolution
mysql-connectors-community/x86_64                                                                                                                                      | 2.6 kB  00:00:00
mysql-tools-community/x86_64                                                                                                                                           | 2.6 kB  00:00:00
mysql80-community/x86_64                                                                                                                                               | 2.6 kB  00:00:00

Dependencies Resolved

==============================================================================================================================================================================================
 Package                                       Arch                                 Version                                Repository                                                    Size
==============================================================================================================================================================================================
Installing:
 percona-release                               noarch                               1.0-27                                 /percona-release-latest.noarch                                32 k

Transaction Summary
==============================================================================================================================================================================================
Install  1 Package

Total size: 32 k
Installed size: 32 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : percona-release-1.0-27.noarch                                                                                                                                              1/1
* Enabling the Percona Original repository
<*> All done!
* Enabling the Percona Release repository
<*> All done!
The percona-release package now contains a percona-release script that can enable additional repositories for our newer products.

For example, to enable the Percona Server 8.0 repository use:

  percona-release setup ps80

Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products.

For more information, please visit:
  https://www.percona.com/doc/percona-repo-config/percona-release.html

  Verifying  : percona-release-1.0-27.noarch                                                                                                                                              1/1

Installed:
  percona-release.noarch 0:1.0-27

Complete!
[root@test-machine01 ~]#
[root@test-machine01 ~]#



[root@test-machine01 ~]# yum list |grep percona-xtrabackup
percona-xtrabackup.x86_64               2.3.10-1.el7               percona-release-x86_64
percona-xtrabackup-22.x86_64            2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-22-debuginfo.x86_64  2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-24.x86_64            2.4.24-1.el7               percona-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64  2.4.24-1.el7               percona-release-x86_64
percona-xtrabackup-80.x86_64            8.0.26-18.1.el7            percona-release-x86_64
percona-xtrabackup-80-debuginfo.x86_64  8.0.26-18.1.el7            percona-release-x86_64
percona-xtrabackup-debuginfo.x86_64     2.3.10-1.el7               percona-release-x86_64
percona-xtrabackup-test.x86_64          2.3.10-1.el7               percona-release-x86_64
percona-xtrabackup-test-22.x86_64       2.2.13-1.el7               percona-release-x86_64
percona-xtrabackup-test-24.x86_64       2.4.24-1.el7               percona-release-x86_64
percona-xtrabackup-test-80.x86_64       8.0.26-18.1.el7            percona-release-x86_64
[root@test-machine01 ~]#

Step 2. Install dependent rpms: Please note XtraBackup package require libev.so.4 rpm. Use OS wget command to download this rpm directly to the server. Once rpm is downloaded use OS command yum localinstall to install it.

[root@test-machine01 ~]# yum install percona-xtrabackup-80.x86_64
--> Running transaction check
---> Package percona-xtrabackup-80.x86_64 0:8.0.26-18.1.el7 will be installed
--> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-80-8.0.26-18.1.el7.x86_64
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution
Error: Package: percona-xtrabackup-80-8.0.26-18.1.el7.x86_64 (percona-release-x86_64)
           Requires: libev.so.4()(64bit)
 You could try using --skip-broken to work around the problem

 You could try running: rpm -Va --nofiles --nodigest
[root@test-machine01 ~]#


 [root@test-machine01 tmp]#
[root@test-machine01 tmp]# wget http://mirror.centos.org/centos/7/extras/x86_64/Packages/libev-4.15-7.el7.x86_64.rpm
--2021-11-10 14:33:12--  http://mirror.centos.org/centos/7/extras/x86_64/Packages/libev-4.15-7.el7.x86_64.rpm
Resolving mirror.centos.org (mirror.centos.org)... 45.141.59.244, 2001:4de0:aaae::194
Connecting to mirror.centos.org (mirror.centos.org)|45.141.59.244|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 45072 (44K) [application/x-rpm]
Saving to: âlibev-4.15-7.el7.x86_64.rpmâ

100%[====================================================================================================================================================>] 45,072      --.-K/s   in 0.002s

2021-11-10 14:33:12 (18.9 MB/s) - âlibev-4.15-7.el7.x86_64.rpmâ saved [45072/45072]

[root@test-machine01 tmp]# ls -ltr
total 204
-rw-r--r--. 1 root   root      45072 Sep  8  2017 libev-4.15-7.el7.x86_64.rpm
-rw-r--r--. 1 root   root     159714 Aug 19 18:12 pg_profile--0.3.4.tar.gz
drwx------. 2 root   root          6 Nov  4 11:29 vmware-root_870-2731086752
drwxr-xr-x. 2 oracle oinstall      6 Nov  9 10:16 hsperfdata_oracle
[root@test-machine01 tmp]# 

[root@test-machine01 tmp]# yum localinstall libev-4.15-7.el7.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining libev-4.15-7.el7.x86_64.rpm: libev-4.15-7.el7.x86_64
Marking libev-4.15-7.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package libev.x86_64 0:4.15-7.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================
 Package                                Arch                                    Version                                       Repository                                                 Size
==============================================================================================================================================================================================
Installing:
 libev                                  x86_64                                  4.15-7.el7                                    /libev-4.15-7.el7.x86_64                                   86 k

Transaction Summary
==============================================================================================================================================================================================
Install  1 Package

Total size: 86 k
Installed size: 86 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : libev-4.15-7.el7.x86_64                                                                                                                                                    1/1
  Verifying  : libev-4.15-7.el7.x86_64                                                                                                                                                    1/1

Installed:
  libev.x86_64 0:4.15-7.el7

Complete!
[root@test-machine01 tmp]#

Step 3. Install Percona XtraBackup package: Once the above steps are done. We can go ahead and install percona-xtrabackup-80.x86_64. Please note Percona XtraBackup 8.0 does not support making backups of databases created in versions prior to 8.0 of MySQL, Percona Server for MySQL, or Percona XtraDB Cluster. As the changes that MySQL 8.0 introduced in data dictionaries, redo log, and undo log are incompatible with previous versions, it is currently impossible for Percona XtraBackup 8.0 to also support versions prior to 8.0. Once installation is done using command xtrabackup -v & xtrabackup --help to get the installed version and full options.

[root@test-machine01 tmp]#
[root@test-machine01 tmp]# yum install percona-xtrabackup-80.x86_64
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-80.x86_64 0:8.0.26-18.1.el7 will be installed
--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-80-8.0.26-18.1.el7.x86_64
--> Processing Dependency: perl(Digest::MD5) for package: percona-xtrabackup-80-8.0.26-18.1.el7.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.0.1.el7 will be installed
--> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.023-6.0.1.el7.x86_64
--> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.023-6.0.1.el7.x86_64
---> Package perl-Digest-MD5.x86_64 0:2.52-3.el7 will be installed
--> Processing Dependency: perl(Digest::base) >= 1.00 for package: perl-Digest-MD5-2.52-3.el7.x86_64
--> Running transaction check
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Digest.noarch 0:1.17-245.el7 will be installed
--> Running transaction check
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Running transaction check
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================
 Package                                             Arch                               Version                                      Repository                                          Size
==============================================================================================================================================================================================
Installing:
 percona-xtrabackup-80                               x86_64                             8.0.26-18.1.el7                              percona-release-x86_64                              14 M
Installing for dependencies:
 perl-Compress-Raw-Bzip2                             x86_64                             2.061-3.el7                                  ol7_latest                                          32 k
 perl-Compress-Raw-Zlib                              x86_64                             1:2.061-4.el7                                ol7_latest                                          57 k
 perl-DBD-MySQL                                      x86_64                             4.023-6.0.1.el7                              ol7_latest                                         140 k
 perl-DBI                                            x86_64                             1.627-4.el7                                  ol7_latest                                         801 k
 perl-Data-Dumper                                    x86_64                             2.145-3.el7                                  ol7_latest                                          47 k
 perl-Digest                                         noarch                             1.17-245.el7                                 ol7_latest                                          22 k
 perl-Digest-MD5                                     x86_64                             2.52-3.el7                                   ol7_latest                                          29 k
 perl-IO-Compress                                    noarch                             2.061-2.el7                                  ol7_latest                                         259 k
 perl-Net-Daemon                                     noarch                             0.48-5.el7                                   ol7_latest                                          50 k
 perl-PlRPC                                          noarch                             0.2020-14.el7                                ol7_latest                                          35 k

Transaction Summary
==============================================================================================================================================================================================
Install  1 Package (+10 Dependent packages)

Total download size: 15 M
Installed size: 18 M
Is this ok [y/d/N]: y
Downloading packages:
(1/11): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                                                                                                                 |  32 kB  00:00:01
(2/11): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                                                                                                                  |  57 kB  00:00:01
(3/11): perl-DBD-MySQL-4.023-6.0.1.el7.x86_64.rpm                                                                                                                      | 140 kB  00:00:00
(4/11): perl-Data-Dumper-2.145-3.el7.x86_64.rpm                                                                                                                        |  47 kB  00:00:00
(5/11): perl-Digest-1.17-245.el7.noarch.rpm                                                                                                                            |  22 kB  00:00:00
(6/11): perl-Digest-MD5-2.52-3.el7.x86_64.rpm                                                                                                                          |  29 kB  00:00:00
(7/11): perl-DBI-1.627-4.el7.x86_64.rpm                                                                                                                                | 801 kB  00:00:00
(8/11): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                                                                                                          |  50 kB  00:00:00
(9/11): perl-PlRPC-0.2020-14.el7.noarch.rpm                                                                                                                            |  35 kB  00:00:00
(10/11): perl-IO-Compress-2.061-2.el7.noarch.rpm                                                                                                                       | 259 kB  00:00:00
warning: /var/cache/yum/x86_64/7Server/percona-release-x86_64/packages/percona-xtrabackup-80-8.0.26-18.1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8507efa5: NOKEY  00:00:00 ETA
Public key for percona-xtrabackup-80-8.0.26-18.1.el7.x86_64.rpm is not installed
(11/11): percona-xtrabackup-80-8.0.26-18.1.el7.x86_64.rpm                                                                                                              |  14 MB  00:00:13
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                         1.1 MB/s |  15 MB  00:00:13
Retrieving key from file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Importing GPG key 0x8507EFA5:
 Userid     : "Percona MySQL Development Team (Packaging key) <[email protected]>"
 Fingerprint: 4d1b b29d 63d9 8e42 2b21 13b1 9334 a25f 8507 efa5
 Package    : percona-release-1.0-27.noarch (@/percona-release-latest.noarch)
 From       : /etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                               1/11
  Installing : perl-Digest-1.17-245.el7.noarch                                                                                                                                           2/11
  Installing : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                                                         3/11
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                       4/11
  Installing : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                         5/11
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                6/11
  Installing : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                       7/11
  Installing : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                           8/11
  Installing : perl-DBI-1.627-4.el7.x86_64                                                                                                                                               9/11
  Installing : perl-DBD-MySQL-4.023-6.0.1.el7.x86_64                                                                                                                                    10/11
  Installing : percona-xtrabackup-80-8.0.26-18.1.el7.x86_64                                                                                                                             11/11
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                1/11
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                         2/11
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                       3/11
  Verifying  : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                                                         4/11
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                       5/11
  Verifying  : perl-DBD-MySQL-4.023-6.0.1.el7.x86_64                                                                                                                                     6/11
  Verifying  : perl-Digest-1.17-245.el7.noarch                                                                                                                                           7/11
  Verifying  : perl-DBI-1.627-4.el7.x86_64                                                                                                                                               8/11
  Verifying  : percona-xtrabackup-80-8.0.26-18.1.el7.x86_64                                                                                                                              9/11
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                              10/11
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                          11/11

Installed:
  percona-xtrabackup-80.x86_64 0:8.0.26-18.1.el7

Dependency Installed:
  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7      perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7      perl-DBD-MySQL.x86_64 0:4.023-6.0.1.el7      perl-DBI.x86_64 0:1.627-4.el7
  perl-Data-Dumper.x86_64 0:2.145-3.el7             perl-Digest.noarch 0:1.17-245.el7                perl-Digest-MD5.x86_64 0:2.52-3.el7          perl-IO-Compress.noarch 0:2.061-2.el7
  perl-Net-Daemon.noarch 0:0.48-5.el7               perl-PlRPC.noarch 0:0.2020-14.el7

Complete!
[root@test-machine01 tmp]#
[root@test-machine01 tmp]#

[root@test-machine01 tmp]#
[root@test-machine01 tmp]# xtrabackup -v
xtrabackup version 8.0.26-18 based on MySQL server 8.0.26 Linux (x86_64) (revision id: 4aecf82)
[root@test-machine01 tmp]#
[root@test-machine01 tmp]#
[root@test-machine01 ~]# xtrabackup --help
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
The following groups are read: xtrabackup mysqld
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=#

Reference : Percona XtraBackup – Documentation: https://www.percona.com/doc/percona-xtrabackup/2.4/index.html

This document is just for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.

Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to understand more about our pursuit.

BACKUP AND RECOVERY, MYSQL, XTRABACKUP

Steps to Install Percona XtraBackup for MySQL

Related Articles