MySQL全实例备份失败

问题概述：

使用MySQL全实例备份时失败

问题描述：

配置了MySQL全实例备份的备份集发起备份后失败，页面显示内容如下：

MySQL客户端操作系统层面查看xtrabackup版本报错：

[root@mysql01 bin]# ./xtrabackup8 --version
./xtrabackup8: error while loading shared libraries: libprotobuf-lite.so.3.19.4: cannot open shared object file: No such file or directory

影响范围：

UniSpace 2.0.x/2.1.x/2.2.x/2.3.x

MySQL 8.x.x

Xtrabackup 8.x.x

解决方案：

1、 检查xtrabackup配置，能够正确输出版本信息

[root@mysql01 bin]# ./xtrabackup --version
2024-09-18T09:49:58.655464+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/usr/local/mysql-8.0.24/data --innodb_file_per_table=1 --innodb_buffer_pool_size=512M --innodb_flush_method=O_DIRECT --log_bin=mysql-bin --server-id=31 
./xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)

2、 检查页面配置，填写正确的Xtrabackup二进制路径

3、 【可选】创建两个脚本文件，赋予可执行权限，填写Xtrabackup二进制路径为脚本文件路径（需要根据实际情况更改脚本内路径信息）

vim xtrabackup

#!/bin/bash

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/datadmp/urman-agent/libs/xtrabackup_libs

XTRABACKUP="/datadmp/urman-agent/bin/xtrabackup8"

$XTRABACKUP "$@"

 

vim xbstream

#!/bin/bash

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/datadmp/urman-agent/libs/xtrabackup_libs

XTRABACKUP="/datadmp/urman-agent/bin/xbstream"

$XTRABACKUP "$@"

 

[root@mysql01 bin]# chmod +x x*
[root@mysql01 bin]# ll
total 2
-rwxr-xr-x. 1 root  root  162 Sep 18 10:55 xbstream
-rwxr-xr-x. 1 root  root  165 Sep 18 10:55 xtrabackup