sudo apt update && sudo apt install -y percona-xtrabackup-80 mydumper mysql-client

CREATE USER 'bkp_user'@'localhost' IDENTIFIED BY 'Str0ngP@ss!';
GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkp_user'@'localhost';

#!/bin/bash
DEST=/backup/full/$(date +%F)
xtrabackup --user=bkp_user --password='Str0ngP@ss!' --backup --target-dir=$DEST
tar -czf $DEST.tar.gz -C $DEST .
aws s3 cp $DEST.tar.gz s3://mybackup/full/

#!/bin/bash
DEST=/backup/inc/$(date +%Y%m%d%H)
mydumper -u bkp_user -p 'Str0ngP@ss!' -B app_db -o $DEST -t 4 -c
aws s3 sync $DEST s3://mybackup/inc/$(date +%Y%m%d%H)

log_bin=mysql-bin
binlog_format=ROW
expire_logs_days=7

# 全量恢复
aws s3 cp s3://mybackup/full/2025-09-01.tar.gz - | tar -xz -C /backup/restore
xtrabackup --prepare --target-dir=/backup/restore
systemctl stop mysql
xtrabackup --copy-back --target-dir=/backup/restore
# 增量恢复
myloader -d /backup/inc/2025090101 -u root
# 应用binlog
mysqlbinlog --start-datetime="2025-09-01 01:00:00" mysql-bin.000012 | mysql -u root

- job_name: mysql_backup
  static_configs:
    - targets: 【'localhost:9104'】
  params:
    collect【】:
      - backup_duration
      - backup_size