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 rcloneConfigure 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
EOFRun 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 rootAutomate 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 -deleteOption 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-80Run 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 mysqlAutomate
# 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.