commvault xtrabackup全实例备份失败 处于未决状态（下）

接上篇 commvault服务器端报错和xtrabackup本地备份报错一致，所以排除commvault软件本身问题。

查看数据库表 show databases;
SELECT Host, User, plugin from user;出现如下报错：
ERROR 1046 (3D000): No database selected
解决方案：先use mysql;use命令选择数据库

xtrabackup备份
xtrabackup --backup -uroot -p --target-dir=/usr/local/mysql/data
xtrabackup version 8.0.4 based on MySQL server 8.0.13 Linux (x86_64) (revision id: c2c0777)
220824 22:35:38 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/usr/local/mysql/mysql.sock’ as ‘root’ (using password: YES).
Failed to connect to MySQL server: DBI connect(‘;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/usr/local/mysql/mysql.sock’,‘root’,…) failed: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at - line 1535.
220824 22:35:38 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /usr/local/mysql/mysql.sock
Using server version 8.0.28
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
Number of pools: 1
Unknown redo log format (4). Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/ upgrading-downgrading.html.

更改plugin试试
ALTER USER ‘root’@‘%’ IDENTIFIED WITH caching_sha2_password BY ‘123456’;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
解决方法：刷新 flush privileges;

新建了一个用户
CREATE USER ‘shauser’@'localhost’IDENTIFIED WITH mysql_native_password BY ‘password’;
grant all privileges on . to shauser@‘localhost’ with grant option;
flush privileges;


“Xtrabackup8.0.11还不支持备份MySQL8.0.20
MySQL修改redo log格式版本的原因是在MySQL 8.0中，由于undo表空间ID值的变化,undo表空间修改的重做日志记录的大小增加了,导致需要额外的字节存储,redo log记录大小的变化导致写I/O较多的工作负载的性能下降(官方记录是10%),为了解决这个问题，对redo log日志格式进行了修改(优化)

mysql降级到8.19后解决。”

目前mysql 是8.0.28
xtrabackup --version
xtrabackup: recognized server arguments: --datadir=/usr/local/mysql/data
xtrabackup version 8.0.4 based on MySQL server 8.0.13 Linux (x86_64) (revision id: c2c0777)

经排查 xtrabackup8.0.4不支持mysql8.0.28

https://docs.percona.com/percona-xtrabackup/8.0/index.html

接下来测试：xtrabackup8.0.11—mysql8.0.19
xtrabackup 8.0.28/29–mysql8.0.28