Automated Backup Guide | Geode Database

Implementing robust automated backup strategies is critical for production Geode deployments. This guide covers automated backup configuration, scheduling, testing, and disaster recovery procedures. <h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>Geode supports multiple backup strategies: <ul> <li>Full Backups: Complete database snapshot</li> <li>Incremental Backups: Changes since last full backup</li> <li>Point-in-Time Recovery (PITR): Restore to specific timestamp</li> <li>Cloud Storage: S3-compatible object storage integration</li> <li>Automated Scheduling: Cron-based backup automation</li> </ul> Recovery Time Objective (RTO): < 5 minutes for full restore Recovery Point Objective (RPO): < 15 minutes with incremental backups <h3 id="s3-cloud-backup-configuration" class="position-relative d-flex align-items-center group"> S3 Cloud Backup Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="s3-cloud-backup-configuration" aria-haspopup="dialog" aria-label="Share link: S3 Cloud Backup Configuration"> Share link </button> </h3> <h4 id="prerequisites" class="position-relative d-flex align-items-center group"> Prerequisites <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prerequisites" aria-haspopup="dialog" aria-label="Share link: Prerequisites"> Share link </button> </h4>S3-Compatible Storage: <ul> <li>Amazon S3</li> <li>Digital Ocean Spaces</li> <li>MinIO</li> <li>Wasabi</li> <li>Backblaze B2</li> </ul> Required Credentials: <ul> <li>Access Key ID</li> <li>Secret Access Key</li> <li>Region (for AWS)</li> <li>Endpoint URL (for non-AWS providers)</li> </ul> <h4 id="environment-setup" class="position-relative d-flex align-items-center group"> Environment Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="environment-setup" aria-haspopup="dialog" aria-label="Share link: Environment Setup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># AWS S3 export AWS_ACCESS_KEY_ID='AKIAIOSFODNN7EXAMPLE' export AWS_SECRET_ACCESS_KEY='wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY' export AWS_REGION='us-east-1' # Digital Ocean Spaces export AWS_ACCESS_KEY_ID='DO_SPACES_KEY' export AWS_SECRET_ACCESS_KEY='DO_SPACES_SECRET' export AWS_ENDPOINT_URL='https://nyc3.digitaloceanspaces.com' export AWS_REGION='us-east-1' # Required but not used by DO # MinIO export AWS_ACCESS_KEY_ID='minio_access_key' export AWS_SECRET_ACCESS_KEY='minio_secret_key' export AWS_ENDPOINT_URL='https://minio.example.com:9000' export AWS_REGION='us-east-1' </code></pre></div> <h4 id="server-configuration" class="position-relative d-flex align-items-center group"> Server Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="server-configuration" aria-haspopup="dialog" aria-label="Share link: Server Configuration"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># geode.yaml backup: s3: enabled: true bucket: 'geode-production-backups' prefix: 'prod' # Optional: organize by environment region: 'us-east-1' endpoint: '' # Leave empty for AWS S3 access_key_id: '${AWS_ACCESS_KEY_ID}' secret_access_key: '${AWS_SECRET_ACCESS_KEY}' compression: true # gzip compression encryption: true # Server-side encryption retention_days: 90 # Auto-delete old backups schedule: enabled: true full_backup: '0 2 * * 0' # Weekly on Sunday at 2 AM incremental_backup: '0 2 * * 1-6' # Daily at 2 AM except Sunday </code></pre></div> <h3 id="manual-backup-operations" class="position-relative d-flex align-items-center group"> Manual Backup Operations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="manual-backup-operations" aria-haspopup="dialog" aria-label="Share link: Manual Backup Operations"> Share link </button> </h3> <h4 id="full-backup" class="position-relative d-flex align-items-center group"> Full Backup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="full-backup" aria-haspopup="dialog" aria-label="Share link: Full Backup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create full backup geode backup \ --dest s3://geode-backups/production \ --mode full \ --compression gzip # Output: # Backup started: backup-20260123-020000 # Backup ID: 1738012345 # Compressing data... # Uploading to S3: s3://geode-backups/production/backup-1738012345.tar.gz # Backup completed successfully # Size: 2.3 GB (compressed from 5.1 GB) # Duration: 45s </code></pre></div> <h4 id="incremental-backup" class="position-relative d-flex align-items-center group"> Incremental Backup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="incremental-backup" aria-haspopup="dialog" aria-label="Share link: Incremental Backup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create incremental backup (delta since last full) geode backup \ --dest s3://geode-backups/production \ --mode incremental \ --parent 1738012345 # Output: # Incremental backup started # Parent backup: 1738012345 (2026-01-23 02:00:00) # Backup ID: 1738098745 # Changes: 156 MB # Duration: 8s </code></pre></div> <h4 id="list-backups" class="position-relative d-flex align-items-center group"> List Backups <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="list-backups" aria-haspopup="dialog" aria-label="Share link: List Backups"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># List all backups geode backup \ --dest s3://geode-backups/production \ --list # Output: # Backup ID Type Size Timestamp Status # 1738012345 full 2.3 GB 2026-01-23 02:00:00 complete # 1738098745 incremental 156 MB 2026-01-24 02:00:00 complete # 1738185145 incremental 89 MB 2026-01-25 02:00:00 complete # 1738271545 incremental 134 MB 2026-01-26 02:00:00 complete </code></pre></div> <h4 id="verify-backup-integrity" class="position-relative d-flex align-items-center group"> Verify Backup Integrity <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="verify-backup-integrity" aria-haspopup="dialog" aria-label="Share link: Verify Backup Integrity"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Verify backup without restoring geode backup \ --dest s3://geode-backups/production \ --verify \ --backup-id 1738012345 # Output: # Verifying backup 1738012345... # Downloading metadata... # Checking file integrity (SHA256)... # ✓ data/nodes.db: OK # ✓ data/edges.db: OK # ✓ data/indexes/: OK # ✓ wal/: OK # Backup integrity: VALID </code></pre></div> <h3 id="automated-backup-scripts" class="position-relative d-flex align-items-center group"> Automated Backup Scripts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="automated-backup-scripts" aria-haspopup="dialog" aria-label="Share link: Automated Backup Scripts"> Share link </button> </h3> <h4 id="backup-script" class="position-relative d-flex align-items-center group"> Backup Script <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="backup-script" aria-haspopup="dialog" aria-label="Share link: Backup Script"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">#!/bin/bash # /usr/local/bin/geode-backup.sh set -euo pipefail # Configuration BUCKET="s3://geode-production-backups" RETENTION_DAYS=90 LOG_FILE="/var/log/geode/backup.log" ALERT_EMAIL="[email protected]" # Logging function log() { echo "[$(date +'%Y-%m-%d %H:%M:%S')] $*" | tee -a "$LOG_FILE" } # Error handler handle_error() { log "ERROR: Backup failed at line $1" echo "Geode backup failed. Check $LOG_FILE for details." | \ mail -s "Geode Backup Failure" "$ALERT_EMAIL" exit 1 } trap 'handle_error $LINENO' ERR log "Starting backup" # Determine backup type (full on Sunday, incremental otherwise) DOW=$(date +%u) if [ "$DOW" -eq 7 ]; then log "Performing full backup (Sunday)" BACKUP_ID=$(geode backup \ --dest "$BUCKET" \ --mode full \ --compression gzip | \ grep "Backup ID" | \ awk '{print $3}') echo "$BACKUP_ID" > /var/lib/geode/last-full-backup log "Full backup completed: $BACKUP_ID" else log "Performing incremental backup" PARENT=$(cat /var/lib/geode/last-full-backup) BACKUP_ID=$(geode backup \ --dest "$BUCKET" \ --mode incremental \ --parent "$PARENT" \ --compression gzip | \ grep "Backup ID" | \ awk '{print $3}') log "Incremental backup completed: $BACKUP_ID" fi # Verify backup integrity log "Verifying backup integrity" geode backup \ --dest "$BUCKET" \ --verify \ --backup-id "$BACKUP_ID" >> "$LOG_FILE" 2>&1 # Prune old backups log "Pruning backups older than $RETENTION_DAYS days" geode backup \ --dest "$BUCKET" \ --prune \ --older-than-days "$RETENTION_DAYS" >> "$LOG_FILE" 2>&1 log "Backup completed successfully" # Send success notification echo "Backup completed successfully. ID: $BACKUP_ID" | \ mail -s "Geode Backup Success" "$ALERT_EMAIL" </code></pre></div> <h4 id="crontab-configuration" class="position-relative d-flex align-items-center group"> Crontab Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="crontab-configuration" aria-haspopup="dialog" aria-label="Share link: Crontab Configuration"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Install backup script sudo cp geode-backup.sh /usr/local/bin/ sudo chmod +x /usr/local/bin/geode-backup.sh # Add to crontab sudo crontab -e # Daily backups at 2 AM 0 2 * * * /usr/local/bin/geode-backup.sh >> /var/log/geode/backup-cron.log 2>&1 </code></pre></div> <h4 id="systemd-timer-alternative-to-cron" class="position-relative d-flex align-items-center group"> Systemd Timer (Alternative to Cron) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="systemd-timer-alternative-to-cron" aria-haspopup="dialog" aria-label="Share link: Systemd Timer (Alternative to Cron)"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-ini" data-lang="ini"># /etc/systemd/system/geode-backup.service [Unit] Description=Geode Automated Backup Wants=geode-backup.timer [Service] Type=oneshot User=geode Group=geode ExecStart=/usr/local/bin/geode-backup.sh StandardOutput=append:/var/log/geode/backup.log StandardError=append:/var/log/geode/backup.log [Install] WantedBy=multi-user.target </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-ini" data-lang="ini"># /etc/systemd/system/geode-backup.timer [Unit] Description=Geode Backup Timer Requires=geode-backup.service [Timer] # Daily at 2 AM OnCalendar=daily OnCalendar=*-*-* 02:00:00 Persistent=true [Install] WantedBy=timers.target </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Enable timer sudo systemctl daemon-reload sudo systemctl enable geode-backup.timer sudo systemctl start geode-backup.timer # Check status sudo systemctl status geode-backup.timer sudo systemctl list-timers geode-backup.timer </code></pre></div> <h3 id="restore-procedures" class="position-relative d-flex align-items-center group"> Restore Procedures <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="restore-procedures" aria-haspopup="dialog" aria-label="Share link: Restore Procedures"> Share link </button> </h3> <h4 id="full-restore" class="position-relative d-flex align-items-center group"> Full Restore <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="full-restore" aria-haspopup="dialog" aria-label="Share link: Full Restore"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Stop Geode server sudo systemctl stop geode # Backup current data (safety) sudo mv /var/lib/geode/data /var/lib/geode/data.backup-$(date +%Y%m%d) # Restore from backup geode restore \ --source s3://geode-backups/production \ --backup-id 1738012345 \ --target /var/lib/geode/data # Verify data integrity geode verify --data-dir /var/lib/geode/data # Start server sudo systemctl start geode # Verify server health geode query "RETURN 1 AS health_check" </code></pre></div> <h4 id="point-in-time-recovery-pitr" class="position-relative d-flex align-items-center group"> Point-in-Time Recovery (PITR) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="point-in-time-recovery-pitr" aria-haspopup="dialog" aria-label="Share link: Point-in-Time Recovery (PITR)"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Restore to specific timestamp geode restore \ --source s3://geode-backups/production \ --backup-id 1738012345 \ --target /var/lib/geode/data \ --pitr-timestamp "2026-01-23 10:30:00" # Process: # 1. Restore base backup (full backup 1738012345) # 2. Apply WAL segments up to specified timestamp # 3. Stop at exact recovery point # # Output: # Restoring base backup... # Applying WAL segments... # - wal/segment-001.log (2026-01-23 02:05:00 - 03:00:00) # - wal/segment-002.log (2026-01-23 03:00:00 - 04:00:00) # ... # - wal/segment-009.log (2026-01-23 10:00:00 - 10:35:12) # Stopping at 2026-01-23 10:30:00 # Recovery complete </code></pre></div> <h4 id="automated-restore-script" class="position-relative d-flex align-items-center group"> Automated Restore Script <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="automated-restore-script" aria-haspopup="dialog" aria-label="Share link: Automated Restore Script"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">#!/bin/bash # /usr/local/bin/geode-restore.sh set -euo pipefail BUCKET="$1" BACKUP_ID="$2" TARGET="${3:-/var/lib/geode/data}" PITR_TIMESTAMP="${4:-}" echo "Stopping Geode server..." sudo systemctl stop geode echo "Creating safety backup of current data..." if [ -d "$TARGET" ]; then sudo mv "$TARGET" "${TARGET}.before-restore-$(date +%Y%m%d-%H%M%S)" fi echo "Restoring from backup $BACKUP_ID..." if [ -n "$PITR_TIMESTAMP" ]; then geode restore \ --source "$BUCKET" \ --backup-id "$BACKUP_ID" \ --target "$TARGET" \ --pitr-timestamp "$PITR_TIMESTAMP" else geode restore \ --source "$BUCKET" \ --backup-id "$BACKUP_ID" \ --target "$TARGET" fi echo "Verifying data integrity..." geode verify --data-dir "$TARGET" echo "Starting Geode server..." sudo systemctl start geode # Wait for server to start sleep 5 echo "Verifying server health..." geode query "RETURN 1 AS health_check" echo "Restore completed successfully" # Usage: # ./geode-restore.sh s3://geode-backups/production 1738012345 # ./geode-restore.sh s3://geode-backups/production 1738012345 /var/lib/geode/data "2026-01-23 10:30:00" </code></pre></div> <h3 id="disaster-recovery-testing" class="position-relative d-flex align-items-center group"> Disaster Recovery Testing <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="disaster-recovery-testing" aria-haspopup="dialog" aria-label="Share link: Disaster Recovery Testing"> Share link </button> </h3> <h4 id="monthly-dr-test" class="position-relative d-flex align-items-center group"> Monthly DR Test <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="monthly-dr-test" aria-haspopup="dialog" aria-label="Share link: Monthly DR Test"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">#!/bin/bash # /usr/local/bin/geode-dr-test.sh set -euo pipefail BUCKET="s3://geode-backups/production" TEST_DIR="/tmp/geode-dr-test-$(date +%Y%m%d)" REPORT_FILE="/var/log/geode/dr-test-$(date +%Y%m%d).log" log() { echo "[$(date +'%Y-%m-%d %H:%M:%S')] $*" | tee -a "$REPORT_FILE" } log "=== Disaster Recovery Test Started ===" # Get latest backup LATEST_BACKUP=$(geode backup --dest "$BUCKET" --list | \ grep "full" | \ head -1 | \ awk '{print $1}') log "Testing restore of backup: $LATEST_BACKUP" # Create test directory mkdir -p "$TEST_DIR" # Restore to test directory log "Restoring backup..." START_TIME=$(date +%s) geode restore \ --source "$BUCKET" \ --backup-id "$LATEST_BACKUP" \ --target "$TEST_DIR" >> "$REPORT_FILE" 2>&1 END_TIME=$(date +%s) RESTORE_DURATION=$((END_TIME - START_TIME)) log "Restore completed in ${RESTORE_DURATION}s (RTO target: 300s)" # Verify data integrity log "Verifying data integrity..." geode verify --data-dir "$TEST_DIR" >> "$REPORT_FILE" 2>&1 # Start test server log "Starting test server..." geode serve \ --data-dir "$TEST_DIR" \ --listen 127.0.0.1:3142 & SERVER_PID=$! sleep 5 # Run validation queries log "Running validation queries..." QUERY_COUNT=$(geode query "MATCH (n) RETURN count(n)" --server 127.0.0.1:3142 | \ jq -r '.result.rows[0].count') log "Node count: $QUERY_COUNT" # Stop test server kill $SERVER_PID # Cleanup rm -rf "$TEST_DIR" # Generate report log "=== Disaster Recovery Test Summary ===" log "Backup ID: $LATEST_BACKUP" log "Restore Duration: ${RESTORE_DURATION}s (RTO: 300s)" log "RTO Status: $([ $RESTORE_DURATION -lt 300 ] && echo 'PASS' || echo 'FAIL')" log "Data Integrity: VERIFIED" log "Node Count: $QUERY_COUNT" log "Test Status: SUCCESS" # Schedule monthly # 0 3 1 * * /usr/local/bin/geode-dr-test.sh </code></pre></div> <h3 id="monitoring-and-alerting" class="position-relative d-flex align-items-center group"> Monitoring and Alerting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="monitoring-and-alerting" aria-haspopup="dialog" aria-label="Share link: Monitoring and Alerting"> Share link </button> </h3> <h4 id="backup-monitoring-script" class="position-relative d-flex align-items-center group"> Backup Monitoring Script <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="backup-monitoring-script" aria-haspopup="dialog" aria-label="Share link: Backup Monitoring Script"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">#!/bin/bash # /usr/local/bin/geode-backup-monitor.sh BUCKET="s3://geode-backups/production" ALERT_EMAIL="[email protected]" MAX_AGE_HOURS=26 # Alert if no backup in 26 hours # Get latest backup timestamp LATEST=$(geode backup --dest "$BUCKET" --list | \ head -2 | \ tail -1 | \ awk '{print $4" "$5}') LATEST_EPOCH=$(date -d "$LATEST" +%s) NOW_EPOCH=$(date +%s) AGE_HOURS=$(( (NOW_EPOCH - LATEST_EPOCH) / 3600 )) if [ $AGE_HOURS -gt $MAX_AGE_HOURS ]; then echo "WARNING: Last backup is ${AGE_HOURS} hours old (max: ${MAX_AGE_HOURS})" | \ mail -s "Geode Backup Alert" "$ALERT_EMAIL" exit 1 fi echo "OK: Last backup is ${AGE_HOURS} hours old" exit 0 # Run hourly # 0 * * * * /usr/local/bin/geode-backup-monitor.sh </code></pre></div> <h4 id="prometheus-metrics" class="position-relative d-flex align-items-center group"> Prometheus Metrics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prometheus-metrics" aria-haspopup="dialog" aria-label="Share link: Prometheus Metrics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># prometheus.yml scrape_configs: - job_name: 'geode-backups' static_configs: - targets: ['localhost:9090'] metrics_path: '/metrics' # Exposed metrics: # geode_backup_last_success_timestamp # geode_backup_duration_seconds # geode_backup_size_bytes # geode_backup_age_hours </code></pre></div> <h4 id="alert-rules" class="position-relative d-flex align-items-center group"> Alert Rules <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="alert-rules" aria-haspopup="dialog" aria-label="Share link: Alert Rules"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># alerts.yml groups: - name: geode_backups rules: - alert: BackupTooOld expr: geode_backup_age_hours > 26 for: 1h labels: severity: critical annotations: summary: "Geode backup is too old" description: "Last backup is {{ $value }} hours old (max: 26)" - alert: BackupFailed expr: increase(geode_backup_failures_total[1h]) > 0 labels: severity: critical annotations: summary: "Geode backup failed" description: "{{ $value }} backup failures in last hour" - alert: BackupSlowDuration expr: geode_backup_duration_seconds > 600 labels: severity: warning annotations: summary: "Geode backup duration exceeded threshold" description: "Backup took {{ $value }}s (max: 600s)" </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3> <h4 id="backup-strategy" class="position-relative d-flex align-items-center group"> Backup Strategy <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="backup-strategy" aria-haspopup="dialog" aria-label="Share link: Backup Strategy"> Share link </button> </h4>3-2-1 Rule: <ul> <li>3 copies of data (production + 2 backups)</li> <li>2 different storage types (local + cloud)</li> <li>1 offsite copy (different region/provider)</li> </ul> Backup Schedule: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Full backup: Weekly (Sunday 2 AM) Incremental backups: Daily (Monday-Saturday 2 AM) WAL archival: Continuous (every 5 minutes) Retention: 90 days </code></pre></div> <h4 id="testing-requirements" class="position-relative d-flex align-items-center group"> Testing Requirements <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="testing-requirements" aria-haspopup="dialog" aria-label="Share link: Testing Requirements"> Share link </button> </h4>Monthly DR Tests: <ul> <li>Full restore to test environment</li> <li>Verify data integrity</li> <li>Measure RTO (should be < 5 minutes)</li> <li>Test PITR accuracy</li> </ul> Quarterly Full DR Drills: <ul> <li>Complete failover simulation</li> <li>Document recovery procedures</li> <li>Update runbooks</li> <li>Train operations team</li> </ul> <h4 id="security" class="position-relative d-flex align-items-center group"> Security <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="security" aria-haspopup="dialog" aria-label="Share link: Security"> Share link </button> </h4>Encryption: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">backup: s3: encryption: true # Server-side encryption (AES-256) sse_kms_key_id: 'arn:aws:kms:us-east-1:123456789:key/...' # Optional KMS </code></pre></div>Access Control: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Principal": {"AWS": "arn:aws:iam::123456789:user/geode-backup"}, "Action": ["s3:PutObject", "s3:GetObject", "s3:ListBucket"], "Resource": [ "arn:aws:s3:::geode-backups/*", "arn:aws:s3:::geode-backups" ] } ] } </code></pre></div> <h4 id="performance-optimization" class="position-relative d-flex align-items-center group"> Performance Optimization <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-optimization" aria-haspopup="dialog" aria-label="Share link: Performance Optimization"> Share link </button> </h4>Compression: <ul> <li>Use gzip for general workloads (good compression, fast)</li> <li>Use zstd for better compression (requires more CPU)</li> <li>Disable for pre-compressed data</li> </ul> Parallel Uploads: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Configure parallel uploads export AWS_MAX_CONCURRENT_REQUESTS=10 export AWS_MAX_BANDWIDTH=100MB/s </code></pre></div>Incremental Strategy: <ul> <li>Reduces backup time by 80-90%</li> <li>Lower network bandwidth usage</li> <li>Faster recovery for recent data</li> </ul> <h3 id="related-documentation" class="position-relative d-flex align-items-center group"> Related Documentation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-documentation" aria-haspopup="dialog" aria-label="Share link: Related Documentation"> Share link </button> </h3><ul> <li><a href="/docs/guides/migration-guide/" >Migration Guide</a> - Backup and restore procedures</li> <li><a href="/docs/configuration/server-configuration/" >Server Configuration</a> - Backup configuration options</li> <li><a href="/docs/guides/troubleshooting/" >Troubleshooting Guide</a> - Backup troubleshooting</li> <li><a href="/docs/recovery/" >Disaster Recovery</a> - Complete DR procedures</li> </ul> <h3 id="summary" class="position-relative d-flex align-items-center group"> Summary <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="summary" aria-haspopup="dialog" aria-label="Share link: Summary"> Share link </button> </h3>Automated backup implementation checklist: ✅ Configure S3 credentials - Set up cloud storage access ✅ Enable automated backups - Schedule full + incremental backups ✅ Test restore procedures - Verify backups work (monthly) ✅ Implement monitoring - Alert on backup failures ✅ Document procedures - Maintain DR runbooks ✅ Practice DR drills - Regular failover testing Key Metrics: <ul> <li>RTO: < 5 minutes (full restore)</li> <li>RPO: < 15 minutes (with incremental backups)</li> <li>Backup frequency: Daily</li> <li>Retention: 90 days</li> <li>Test frequency: Monthly</li> </ul> Automated backups ensure business continuity and data protection for production Geode deployments.