xtarbackup与mysql 版本不匹配

 unknow  redo  log  格式 。重新下载xtarbackup 与mysql 版本匹配的介质。

mysql> GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';

mysql> GRANT SELECT ON performance_schema.keyring_component_status TO bkpuser@'localhost'

mysql> FLUSH PRIVILEGES;

再试看看 OVER

[root@node02 ~]# xtrabackup --host=172.22.0.13 --port=13306 --user=backupuser --password=123456 --databases=xtr_test --backup --target-dir=/data/backupzxk/
xtrabackup: recognized server arguments: --datadir=/data/mysql/data --open_files_limit=65535 --innodb_buffer_pool_size=4G --innodb_data_file_path=ibdata1:1024M:autoextend --innodb_flush_log_at_trx_commit=2 --innodb_log_buffer_size=8M --innodb_log_file_size=1024M --innodb_log_files_in_group=3 --innodb_max_dirty_pages_pct=50 --innodb_file_per_table=1 --innodb_io_capacity=2000
xtrabackup: recognized client arguments: --socket=/data/mysql/data/mysql.sock --host=172.22.0.13 --port=13306 --user=backupuser --password=* --databases=xtr_test --backup=1 --target-dir=/data/backupzxk/
xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda)
230419 10:34:16 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=172.22.0.13;port=13306;mysql_socket=/data/mysql/data/mysql.sock' as 'backupuser' (using password: YES).
230419 10:34:16 version_check Connected to MySQL server
230419 10:34:16 version_check Executing a version check against the server...
230419 10:34:16 version_check Done.
230419 10:34:16 Connecting to MySQL server host: 172.22.0.13, user: backupuser, password: set, port: 13306, socket: /data/mysql/data/mysql.sock
Using server version 8.0.27
230419 10:34:16 Executing LOCK INSTANCE FOR BACKUP...
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/mysql/data
xtrabackup: open files limit requested 65535, set to 1024000
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:1024M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
Number of pools: 1
xtrabackup: inititialize_service_handles suceeded
230419 10:34:16 Connecting to MySQL server host: 172.22.0.13, user: backupuser, password: set, port: 13306, socket: /data/mysql/data/mysql.sock
xtrabackup: Redo Log Archiving is not set up.
230419 10:34:16 >> log scanned up to (18277917)
xtrabackup: Generating a list of tablespaces
xtrabackup: Generating a list of tablespaces
Scanning './'
Completed space ID check of 2 files.
Allocated tablespace ID 2 for xtr_test/t1, old maximum was 0
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
230419 10:34:16 [01] Copying ./ibdata1 to /data/backupzxk/ibdata1
230419 10:34:17 >> log scanned up to (18277917)
230419 10:34:18 >> log scanned up to (18277917)
230419 10:34:18 [01] ...done
230419 10:34:18 [01] Copying ./xtr_test/t1.ibd to /data/backupzxk/xtr_test/t1.ibd
230419 10:34:18 [01] ...done
230419 10:34:19 [01] Copying ./mysql.ibd to /data/backupzxk/mysql.ibd
230419 10:34:19 [01] ...done
230419 10:34:19 [01] Copying ./undo_002 to /data/backupzxk/undo_002
230419 10:34:19 [01] ...done
230419 10:34:19 [01] Copying ./undo_001 to /data/backupzxk/undo_001
230419 10:34:19 [01] ...done
230419 10:34:19 >> log scanned up to (18277917)
230419 10:34:19 Starting to backup non-InnoDB tables and files
230419 10:34:19 [01] Skipping ./mysqld.log.
230419 10:34:19 [01] Skipping ./auto.cnf.
230419 10:34:19 [01] Skipping ./ibdata1.
230419 10:34:19 [01] Skipping ./ib_logfile1.
230419 10:34:19 [01] Skipping ./ib_logfile2.
230419 10:34:19 [01] Skipping ./#ib_16384_0.dblwr.
230419 10:34:19 [01] Skipping ./#ib_16384_1.dblwr.
230419 10:34:19 [01] Skipping ./undo_001.
230419 10:34:19 [01] Skipping ./undo_002.
230419 10:34:19 [01] Skipping ./ib_logfile0.
230419 10:34:19 [01] Skipping ./mysql.ibd.
230419 10:34:19 [01] Skipping ./ca-key.pem.
230419 10:34:19 [01] Skipping ./ca.pem.
230419 10:34:19 [01] Skipping ./server-key.pem.
230419 10:34:19 [01] Skipping ./server-cert.pem.
230419 10:34:19 [01] Skipping ./client-key.pem.
230419 10:34:19 [01] Skipping ./client-cert.pem.
230419 10:34:19 [01] Skipping ./private_key.pem.
230419 10:34:19 [01] Skipping ./public_key.pem.
230419 10:34:19 [01] Skipping ./binlog.000001.
230419 10:34:19 [01] Skipping ./binlog.000002.
230419 10:34:19 [01] Skipping ./ib_buffer_pool.
230419 10:34:19 [01] Skipping ./ibtmp1.
230419 10:34:19 [01] Skipping ./binlog.000003.
230419 10:34:19 [01] Skipping ./binlog.index.
230419 10:34:19 [01] Skipping ./mysql.sock.lock.
230419 10:34:19 [01] Skipping ./mysqld.pid.
230419 10:34:19 Finished backing up non-InnoDB tables and files
230419 10:34:19 Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
230419 10:34:20 Selecting LSN and binary log position from p_s.log_status
230419 10:34:20 [00] Copying /data/mysql/data/binlog.000004 to /data/backupzxk/binlog.000004 up to position 196
230419 10:34:20 [00] ...done
230419 10:34:20 [00] Writing /data/backupzxk/binlog.index
230419 10:34:20 [00] ...done
230419 10:34:20 [00] Writing /data/backupzxk/xtrabackup_binlog_info
230419 10:34:20 [00] ...done
230419 10:34:20 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '18277917'
xtrabackup: Stopping log copying thread at LSN 18278668.
Starting to parse redo log at lsn = 18277907
230419 10:34:20 >> log scanned up to (18278720)

230419 10:34:21 Executing UNLOCK INSTANCE
230419 10:34:21 All tables unlocked
230419 10:34:21 [00] Copying ib_buffer_pool to /data/backupzxk/ib_buffer_pool
230419 10:34:21 [00] ...done
230419 10:34:21 Backup created in directory '/data/backupzxk/'
MySQL binlog position: filename 'binlog.000004', position '196', GTID of the last change 'b3a14c5e-ddc9-11ed-acf6-fefcfe223af9:1-17'
230419 10:34:21 [00] Writing /data/backupzxk/backup-my.cnf
230419 10:34:21 [00] ...done
230419 10:34:21 [00] Writing /data/backupzxk/xtrabackup_info
230419 10:34:21 [00] ...done
xtrabackup: Transaction log of lsn (18277917) to (18278730) was copied.
230419 10:34:22 completed OK!
[root@node02 ~]#