Backup & Restore

Procedures for backing up and restoring critical data on MEGATRON.

What to Back Up

DataLocationPriorityMethod
K3s etcd/var/lib/rancher/k3s/server/db/CriticalK3s snapshot
Application databasesK3s PVCsCriticalpg_dump / Volume snapshots
Research data~/Papers/ (234 GB)Highrsync to NAS/Mac Studio
Cloudflare tunnel config/etc/cloudflared/HighFile copy
SSH keys~/.ssh/HighEncrypted backup
Helm valuesVariousMediumGit
Docker volumes/var/lib/docker/volumes/MediumVolume export

K3s Etcd Snapshot

# Create snapshot
k3s etcd-snapshot save --name manual-backup-$(date +%Y%m%d)

# List snapshots
k3s etcd-snapshot list

# Restore from snapshot
k3s server --cluster-reset --cluster-reset-restore-path=/path/to/snapshot

Database Backups

# PostgreSQL (example for data namespace)
kubectl exec -n data postgres-postgresql-0 -- pg_dumpall -U postgres > backup.sql

# MariaDB (Docker, Coolify)
docker exec bibliotheca-db mysqldump -u root -p --all-databases > mariadb-backup.sql

Research Data Sync

# Sync to Mac Studio
rsync -avz --progress ~/Papers/ mac-studio:~/Papers-backup/

# Sync to SMB share
rsync -avz ~/Papers/ /mnt/sunny/backups/papers/

TODO: expand with automated backup schedules, retention policies, Longhorn snapshot configuration, and disaster recovery testing procedures.