环境:
环境:
OS:openEuler 24.03 (LTS-SP2)(安装时候没有图形界面的选择项可选)
##############################xtrabackup备份##############################
1.获取介质
percona-xtrabackup-8.4.0-2-Linux-x86_64.glibc2.17.tar.gz
下载地址
https://www.percona.com/downloads
2.解压安装
[root@localhost soft]# tar -xvf percona-xtrabackup-8.4.0-2-Linux-x86_64.glibc2.17.tar.gz
[root@localhost soft]# mv percona-xtrabackup-8.4.0-2-Linux-x86_64.glibc2.17 /opt/xtrabackup-8.4.0-2
3.备份
/opt/xtrabackup-8.4.0-2/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/tmp/mysql.sock --no-version-check --compress-threads=4 --backup --stream=xbstream --parallel=4 | gzip > /tmp/mybak20250910.xb.gz
报错误:
/opt/xtrabackup-8.4.0-2/bin/xtrabackup: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
解决办法：
[root@localhost soft]#wget https://mirrors.aliyun.com/centos/8/AppStream/x86_64/os/Packages/compat-openssl10-1.0.2o-3.el8.x86_64.rpm
[root@localhost soft]# yum install make
[root@localhost soft]#rpm -ivh compat-openssl10-1.0.2o-3.el8.x86_64.rpm
安装glibc.2.28版本也是报错误
percona-xtrabackup-8.4.0-4-Linux-x86_64.glibc2.28.tar.gz
[root@localhost soft]# /opt/xtrabackup-8.4.0-4/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/tmp/mysql.sock --no-version-check --compress-threads=4 --backup --stream=xbstream --parallel=4| gzip > /tmp/mybak20250910.xb.gz
/opt/xtrabackup-8.4.0-4/bin/xtrabackup: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory
解决办法:
dnf search openssl
dnf install compat-openssl11-devel.x86_64