xtrabackup8.0.27备份失败
问题描述:mysql8.0.27备份出现中断,重新备份发现xtrabackup备份失败,xtrabackup与mysql版本不匹配,后来想起来时mysql进行了升级,8.0.27->8.0.29升级,导致备份软件和数据库版本不一致,mysql5.7的innodbxtrabackup基本没什么问题,在8.0以上就比较明显。去重新下载8.0.29版本匹配的xtrabackup时,发现我用百度正常搜索就找不到下载的链接,但是连上vpn外网就有正常的下载链接
[root@orch2 backup]# $xtrDir --defaults-file=$mysql_cnf --user=$mysql_user --password=$mysql_password --socket=$mysql_socket --compress --compress-threads=2 --backup --target-dir=$target_dir xtrabackup: recognized server arguments: --datadir=/data/db_orch/data --tmpdir=/data/db_orch/tmp --log_bin=/data/db_orch/binlog/orch-bin --log-bin-index=/data/db_orch/binlog/orch-bin.index --server-id=1330620 --innodb_open_files=63000 --innodb_data_home_dir=/data/db_orch/data --innodb_log_group_home_dir=/data/db_orch/data --innodb_log_file_size=8G --innodb_log_files_in_group=4 --innodb_undo_directory=/data/db_orch/ulog --innodb_undo_tablespaces=3 --innodb_flush_log_at_trx_commit=2 --innodb_flush_method=O_DIRECT --innodb_io_capacity=2000 --innodb_buffer_pool_size=32G --innodb_log_buffer_size=32M --innodb_max_dirty_pages_pct=85 --innodb_adaptive_hash_index=1 --innodb_data_file_path=ibdata1:512M:autoextend --innodb_write_io_threads=18 --innodb_read_io_threads=10 xtrabackup: recognized client arguments: --user=root --password=* --socket=/data/db_orch/mysql.sock --compress --compress-threads=2 --backup=1 --target-dir=/backup/13306/2022-09-21 /root/percona-xtrabackup/bin/xtrabackup version 8.0.27-19 based on MySQL server 8.0.27 Linux (x86_64) (revision id: 50dbc8dadda) Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at - line 749. BEGIN failed--compilation aborted at - line 749. 220921 10:23:51 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /data/db_orch/mysql.sock Error: Unsupported server version 8.0.29. Please upgrade PXB, if a new version is available. To continue with risk, use the option --no-server-version-check.
百度正常搜索就显示不了下载链接
vpn连上外网下载
换上最新版的xtrabackup8.0.29,备份成功