一、环境说明
centos7.8 X86_64位 最小化安装 下载rpm包:percona-xtrabackup-84-8.4.0-1.1.el9.x86_64.rpm
二、Supported storage engines
Percona XtraBackup can back up data from InnoDB, XtraDB, MyISAM, MyRocks tables on MySQL 8.4 servers and Percona Server for MySQL with XtraDB, Percona Server for MySQL 8.4, and Percona XtraDB Cluster 8.4.
Percona XtraBackup 8.4 supports the MyRocks storage engine. An incremental backup on the MyRocks storage engine does not determine if an earlier full or incremental backup contains duplicate files. Percona XtraBackup copies all MyRocks files each time it takes a backup.
三、Limitations
Percona XtraBackup 8.4 does not support making backups of databases created in versions before 8.4 of MySQL, Percona Server for MySQL or Percona XtraDB Cluster.
四、关于Percona XtraBackup 8.4.0-1介绍
4.1、关于XtraBackup 8.4.0-1适用备份数据库版本重要说明
Percona XtraBackup 8.4.0-1 在2024-08-20发布
Percona XtraBackup 8.4.0-1 is based on MySQL 8.4 Long Term Supported (LTS) Release. This release allows taking backups of Percona Server for MySQL and MySQL 8.4.0, 8.4.1, 8.4.2 and future 8.4 LTS releases.
Use the Percona XtraBackup 8.0 series to take backups of Percona Server for MySQL 8.0.x and MySQL 8.0.x series.
Use the Percona XtraBackup Innovation series, the latest version is 8.3.0-1, to take backups of Percona Server for MySQL Innovation series and MySQL Innovation series.
4.2、Bug fixes：
PXB-3302: When a MySQL instance had an exceptionally large number of Global Transaction Identifier (GTID) sets, the GTID of the last change in the Xtrabackup log output got truncated. This truncation did not occur in the full output found in the xtrabackup_binlog_info and xtrabackup_info files.
4.3、Deprecated or removed：
1、The terms MASTER and SLAVE have been replaced with SOURCE and REPLICA to align with MySQL 8.4.0. Find the full list of removed (MASTER/SLAVE) terminology in the MySQL Deprecation and Removal Notes.
the MySQL8.4.0 Deprecation and Removal Notes 可以参考MySQL官方地址: https:///doc/relnotes/mysql/8.4/en/news-8-4-0.html
2、Percona XtraBackup 8.4.0-1 removes support for the Keyring file plugin. Use the Keyring file component instead.
3、The --stats mode of operation for the xtrabackup binary has been removed.
官方说明地址: https:///percona-xtrabackup/8.4/release-notes/8.4.0-1.html
五、rpm包安装Percona-XtraBackup-8.4.0-1
rpm包安装 Percona-XtraBackup-8.4.0-1文件 官方文档:
https:///percona-xtrabackup/8.4/yum-download-rpm.html https:///percona-xtrabackup/8.4/#installation-guides
Percona-XtraBackup-8.4.0-1下载rpm安装包:
wget https:///downloads/Percona-XtraBackup-8.4/Percona-XtraBackup-8.4.0-1/binary/redhat/7/x86_64/percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm?_gl=1*ne1ojb*_gcl_au*MjY5MTYwMjM4LjE3MzM2NTg3ODc.
yum localinstall percona-xtrabackup-84-8.4.0-1.1.el9.x86_64.rpm
[root@master-db ~]# yum localinstall percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm --skip-broken
安装提示:
base/x86_64/filelists_db | 7.1 MB 00:00:00
extras/x86_64/filelists_db | 217 kB 00:00:00
Packages skipped because of dependency problems:
libev-4.15-7.el7.x86_64 from extras
percona-xtrabackup-84-8.4.0-1.1.el7.x86_64 from /percona-xtrabackup-84-8.4.0-1.1.el7.x86_64
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 from base
1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 from base
perl-DBD-MySQL-4.023-6.el7.x86_64 from base
perl-DBI-1.627-4.el7.x86_64 from base
perl-Data-Dumper-2.145-3.el7.x86_64 from base
perl-Digest-1.17-245.el7.noarch from base
perl-Digest-MD5-2.52-3.el7.x86_64 from base
perl-IO-Compress-2.061-2.el7.noarch from base
perl-Net-Daemon-0.48-5.el7.noarch from base
perl-PlRPC-0.2020-14.el7.noarch from base
rsync-3.1.2-10.el7.x86_64 from base
yum install缺少的noarch包:
yum install libev-4.15-7.el7.x86_64 perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 perl-DBD-MySQL-4.023-6.el7.x86_64 perl-DBD-MySQL-4.023-6.el7.x86_64 perl-Digest-1.17-245.el7.noarch perl-Digest-MD5-2.52-3.el7.x86_64 rsync-3.1.2-10.el7.x86_64 -y
**再次 yum localinstall安装 提示需要安装zstd: **
[root@master-db ~]# yum localinstall percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror
Examining percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm: percona-xtrabackup-84-8.4.0-1.1.el7.x86_64
Marking percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-84.x86_64 0:8.4.0-1.1.el7 will be installed
--> Processing Dependency: zstd for package: percona-xtrabackup-84-8.4.0-1.1.el7.x86_64
Loading mirror speeds from cached hostfile
--> Finished Dependency Resolution
Error: Package: percona-xtrabackup-84-8.4.0-1.1.el7.x86_64 (/percona-xtrabackup-84-8.4.0-1.1.el7.x86_64)
Requires: zstd
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@master-db ~]#
yum install zstd
提示如下:
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
base | 3.6 kB 00:00:00
extras | 2.9 kB 00:00:00
updates | 2.9 kB 00:00:00
No package zstd available.
Error: Nothing to do
需要启用 epel存储库:
sudo yum install epel-release
sudo yum install zstd
再次安装 percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm 安装成功:
[root@master-db ~]# yum localinstall percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror
Examining percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm: percona-xtrabackup-84-8.4.0-1.1.el7.x86_64
Marking percona-xtrabackup-84-8.4.0-1.1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package percona-xtrabackup-84.x86_64 0:8.4.0-1.1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================
Installing:
percona-xtrabackup-84 x86_64 8.4.0-1.1.el7 /percona-xtrabackup-84-8.4.0-1.1.el7.x86_64 225 M
Transaction Summary
=============================================================================================================================================================================================
Install 1 Package
Total size: 225 M
Installed size: 225 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : percona-xtrabackup-84-8.4.0-1.1.el7.x86_64 1/1
Verifying : percona-xtrabackup-84-8.4.0-1.1.el7.x86_64 1/1
Installed:
percona-xtrabackup-84.x86_64 0:8.4.0-1.1.el7
Complete!
[root@master-db ~]# which xtrabackup
/bin/xtrabackup
