15.4 Other Database backup options

  • Physical File Backup: Stop MySQL, copy /var/lib/mysql/, restart MySQL.
  • Standard Logical Backup (mysqldump):
  1. mysqldump -u sfs -p'sfs' SFArchive > /path/to/backup/SFArchive_db_backup.sql
  • Restore Logical Backup
  1. mysql -u sfs -p'sfs' -e "CREATE DATABASE SFArchive;"  
  2. mysql -u sfs -p'sfs' SFArchive < /path/to/backup/SFArchive_db_backup.sql

 

  • Hot Backups with Percona XtraBackup:  
    1. https://www.percona.com/downloads
    2. (Not Supported by SFS Media or ScaleLogic)

 

  • Automated Scheduled Backups: Use cron to automate mysqldump or physical backups.

 

  • Replication-Based Backups: Use mysqldump or physical backup methods on the replica.

 

  • Cloud or Remote Backups: rclone copy /backups s3:your-bucket/sfs-backups

 

  • Disaster Recovery: Rebuilding from Tape: Use the SF Archive Web UI or CLI to initiate a full tape scan/import.

Tips: Test backup and restore procedures regularly. Store backups offsite or in a secure, redundant location. Automate and monitor backup jobs for failures. Back up both the database and the /usr/share/SFS/connectionInfo.txt configuration file.