All guides

Back up MySQL / MariaDB to NordenVault

Two approaches for MySQL and MariaDB. From simple dumps to hot physical backups with Percona XtraBackup.

Prerequisites

  • A NordenVault account with S3 credentials
  • Your NordenVault bucket name
  • MySQL 5.7+ or MariaDB 10.3+ running on the server

Your S3 endpoint is s3.nordenvault.com

Option 1: mysqldump + rclone

Logical backup using mysqldump with rclone to upload. Works with both MySQL and MariaDB. Best for databases under 50 GB.

Install rclone

# Debian/Ubuntu
sudo apt install rclone

# macOS
brew install rclone

Configure rclone

cat >> ~/.config/rclone/rclone.conf << 'EOF'
[nordenvault]
type = s3
provider = Other
endpoint = https://s3.nordenvault.com
access_key_id = YOUR_ACCESS_KEY
secret_access_key = YOUR_SECRET_KEY
region = us-east-1
EOF

Run a backup

# Dump all databases (consistent snapshot)
mysqldump -u root --single-transaction --routines --triggers \
  --all-databases | gzip > /tmp/mysql-all-$(date +%Y%m%d).sql.gz

# Upload to NordenVault
rclone copy /tmp/mysql-all-*.sql.gz nordenvault:YOUR_BUCKET/mysql/

# Verify
rclone ls nordenvault:YOUR_BUCKET/mysql/

Restore

# Download the backup
rclone copy nordenvault:YOUR_BUCKET/mysql/mysql-all-20260613.sql.gz /tmp/

# Restore
gunzip < /tmp/mysql-all-20260613.sql.gz | mysql -u root

Automate with cron

# Daily at 2 AM, keep last 7 days locally
0 2 * * * mysqldump -u root --single-transaction --routines --triggers --all-databases | gzip > /tmp/mysql-$(date +\%Y\%m\%d).sql.gz && rclone copy /tmp/mysql-$(date +\%Y\%m\%d).sql.gz nordenvault:YOUR_BUCKET/mysql/ && find /tmp -name 'mysql-*.sql.gz' -mtime +7 -delete

Option 2: Percona XtraBackup (xbcloud)

Hot physical backup without locking tables. Streams directly to S3 storage. Recommended for large InnoDB databases.

Install Percona XtraBackup

# Debian/Ubuntu (Percona repo)
sudo apt install percona-xtrabackup-80

# RHEL/Rocky
sudo yum install percona-xtrabackup-80

Run a backup (stream to S3)

xtrabackup --backup --stream=xbstream --target-dir=/tmp/xb | \
  xbcloud put --storage=s3 \
    --s3-endpoint=s3.nordenvault.com \
    --s3-access-key=YOUR_ACCESS_KEY \
    --s3-secret-key=YOUR_SECRET_KEY \
    --s3-bucket=YOUR_BUCKET \
    --s3-region=us-east-1 \
    --parallel=4 \
    mysql-backup-$(date +%Y%m%d)

Restore

# Download from S3
xbcloud get --storage=s3 \
  --s3-endpoint=s3.nordenvault.com \
  --s3-access-key=YOUR_ACCESS_KEY \
  --s3-secret-key=YOUR_SECRET_KEY \
  --s3-bucket=YOUR_BUCKET \
  --s3-region=us-east-1 \
  mysql-backup-20260613 | xbstream -x -C /tmp/restore

# Prepare the backup
xtrabackup --prepare --target-dir=/tmp/restore

# Stop MySQL and replace data directory
sudo systemctl stop mysql
sudo rm -rf /var/lib/mysql/*
xtrabackup --move-back --target-dir=/tmp/restore
sudo chown -R mysql:mysql /var/lib/mysql
sudo systemctl start mysql

Automate

# Daily full backup at 3 AM
0 3 * * * xtrabackup --backup --stream=xbstream --target-dir=/tmp/xb | xbcloud put --storage=s3 --s3-endpoint=s3.nordenvault.com --s3-access-key=YOUR_ACCESS_KEY --s3-secret-key=YOUR_SECRET_KEY --s3-bucket=YOUR_BUCKET --s3-region=us-east-1 mysql-$(date +\%Y\%m\%d)

Which option should I choose?

mysqldump + rclone for databases under 50 GB. Simple, portable dumps that work across MySQL versions. Locks tables briefly during the dump.

Percona XtraBackup for large InnoDB databases. Hot backups with no table locks. Streams directly to NordenVault without writing to local disk first.