sa-charts/运维/mysql-backup.md

1. 安装xtrabackup

sudo yum install https://www.percona.com/downloads/percona-release/redhat/0.1-10/percona-release-0.1-10.noarch.rpm sudo yum install percona-xtrabackup-80

2. ​全量备份加速方案​

xtrabackup --backup --user=root --password=nczl@sino_db \
--parallel=4 --compress --compress-threads=4 \
--target-dir=/data/backup/full_$(date +%Y%m%d) | gzip > backup.xbstream.gz



xtrabackup --backup --user=root --password=nczl@sino_db \
--incremental-basedir=/data/backup/full_$(date +%Y%m%d) \
--target-dir=/data/backup/inc_$(date +%Y%m%d) \
--parallel=4 --compress --compress-threads=4 | gzip > inc.xbstream.gz


xtrabackup --user=root --password=nczl@sino_db --decompress --target-dir=/data/backup/full_20250508



xtrabackup --prepare --apply-log-only --target-dir=/data/backup/full_20250508 \
--use-memory=32G

rsync -avz -e ssh /data/backup/full_20250508 root@192.168.3.123/data/backup/full_20250508