Backup Procedures | Geode Database

<h2 id="backup-procedures" class="position-relative d-flex align-items-center group"> Backup 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="backup-procedures" aria-haspopup="dialog" aria-label="Share link: Backup Procedures"> Share link </button> </h2><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>This guide covers comprehensive backup strategies for Geode, including full backups, incremental backups, cloud storage integration, point-in-time recovery, and automated backup 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>Geode provides robust backup capabilities for data protection: <table> <thead> <tr> <th>Feature</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td>Full Backups</td> <td>Complete database snapshot</td> </tr> <tr> <td>Incremental Backups</td> <td>Changes since last full backup</td> </tr> <tr> <td>Point-in-Time Recovery</td> <td>Restore to specific timestamp</td> </tr> <tr> <td>Cloud Storage</td> <td>S3-compatible object storage</td> </tr> <tr> <td>Compression</td> <td>gzip compression for space efficiency</td> </tr> <tr> <td>Encryption</td> <td>Server-side encryption for security</td> </tr> <tr> <td>Verification</td> <td>Integrity checking with checksums</td> </tr> </tbody> </table> Key Metrics: <ul> <li>RTO (Recovery Time Objective): < 5 minutes for full restore</li> <li>RPO (Recovery Point Objective): < 15 minutes with incremental backups</li> </ul> <h3 id="backup-types" class="position-relative d-flex align-items-center group"> Backup Types <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-types" aria-haspopup="dialog" aria-label="Share link: Backup Types"> 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>A complete snapshot of the entire database: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create full backup to local directory geode backup \ --dest /backups/geode \ --mode full \ --compression gzip # Create full backup to S3 geode backup \ --dest s3://my-bucket/geode-backups \ --mode full \ --compression gzip # Output: # Backup started: 2026-01-28 02:00:00 UTC # Backup ID: 1738012345 # Mode: full # Compressing data... # Uploading to destination... # Backup completed successfully # Size: 2.3 GB (compressed from 5.1 GB) # Duration: 45s # Checksum: sha256:abc123... </code></pre></div>Use Cases: <ul> <li>Initial backup for new deployment</li> <li>Weekly baseline backup</li> <li>Before major upgrades or changes</li> <li>Archival purposes</li> </ul> <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>Only changes since the last full backup: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create incremental backup geode backup \ --dest s3://my-bucket/geode-backups \ --mode incremental \ --parent 1738012345 # Reference to full backup # Output: # Incremental backup started # Parent backup: 1738012345 (2026-01-28 02:00:00 UTC) # Backup ID: 1738098745 # Scanning for changes... # Changes detected: 156 MB # Compressing data... # Uploading... # Backup completed successfully # Size: 45 MB (compressed) # Duration: 8s </code></pre></div>Benefits: <ul> <li>80-90% faster than full backups</li> <li>Lower storage costs</li> <li>Reduced network bandwidth</li> <li>Faster backup windows</li> </ul> <h4 id="continuous-wal-archiving" class="position-relative d-flex align-items-center group"> Continuous WAL Archiving <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="continuous-wal-archiving" aria-haspopup="dialog" aria-label="Share link: Continuous WAL Archiving"> Share link </button> </h4>Archive Write-Ahead Log segments for point-in-time recovery: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># geode.yaml backup: wal_archiving: enabled: true destination: s3://my-bucket/geode-wal interval: 5m # Archive every 5 minutes compression: gzip retention_hours: 168 # 7 days of WAL </code></pre></div>Benefits: <ul> <li>RPO < 5 minutes</li> <li>Enables PITR to any point</li> <li>Continuous protection</li> </ul> <h3 id="s3-cloud-storage" class="position-relative d-flex align-items-center group"> S3 Cloud Storage <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-storage" aria-haspopup="dialog" aria-label="Share link: S3 Cloud Storage"> Share link </button> </h3> <h4 id="aws-s3-configuration" class="position-relative d-flex align-items-center group"> AWS S3 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="aws-s3-configuration" aria-haspopup="dialog" aria-label="Share link: AWS S3 Configuration"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Configure AWS credentials export AWS_ACCESS_KEY_ID='AKIAIOSFODNN7EXAMPLE' export AWS_SECRET_ACCESS_KEY='wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY' export AWS_REGION='us-east-1' # Create backup geode backup \ --dest s3://my-bucket/geode-backups \ --mode full </code></pre></div> <h4 id="s3-compatible-storage" class="position-relative d-flex align-items-center group"> S3-Compatible Storage <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-compatible-storage" aria-haspopup="dialog" aria-label="Share link: S3-Compatible Storage"> Share link </button> </h4>MinIO: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">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' geode backup --dest s3://geode-backups/production --mode full </code></pre></div>Digital Ocean Spaces: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">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' geode backup --dest s3://my-space/geode-backups --mode full </code></pre></div>Backblaze B2: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">export AWS_ACCESS_KEY_ID='B2_KEY_ID' export AWS_SECRET_ACCESS_KEY='B2_APP_KEY' export AWS_ENDPOINT_URL='https://s3.us-west-002.backblazeb2.com' export AWS_REGION='us-west-002' geode backup --dest s3://my-b2-bucket/geode-backups --mode full </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 prefix region: 'us-east-1' endpoint: '' # Empty for AWS S3 access_key_id: '${AWS_ACCESS_KEY_ID}' secret_access_key: '${AWS_SECRET_ACCESS_KEY}' # Storage options compression: true # gzip compression encryption: true # Server-side encryption (SSE-S3) storage_class: 'STANDARD_IA' # Infrequent Access for cost savings # Retention retention_days: 90 # Auto-delete old backups # Performance multipart_threshold: 100MB # Use multipart for files > 100MB max_concurrent_uploads: 10 # Parallel upload threads </code></pre></div> <h3 id="backup-commands" class="position-relative d-flex align-items-center group"> Backup Commands <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-commands" aria-haspopup="dialog" aria-label="Share link: Backup Commands"> Share link </button> </h3> <h4 id="create-backup" class="position-relative d-flex align-items-center group"> Create 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="create-backup" aria-haspopup="dialog" aria-label="Share link: Create Backup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Full backup with all options geode backup \ --dest s3://bucket/backups \ --mode full \ --compression gzip \ --verify \ --retention-days 90 \ --label "pre-upgrade-backup" # Incremental backup geode backup \ --dest s3://bucket/backups \ --mode incremental \ --parent <backup-id> </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">geode backup --dest s3://bucket/backups --list # Output: # Backup ID Type Size Timestamp Status Label # 1738012345 full 2.3 GB 2026-01-28 02:00:00 complete weekly # 1738098745 incremental 156 MB 2026-01-29 02:00:00 complete - # 1738185145 incremental 89 MB 2026-01-30 02:00:00 complete - # 1738271545 full 2.4 GB 2026-02-04 02:00:00 complete weekly # Filter by type geode backup --dest s3://bucket/backups --list --type full # Filter by date range geode backup --dest s3://bucket/backups --list \ --since "2026-01-01" \ --until "2026-01-31" </code></pre></div> <h4 id="verify-backup" class="position-relative d-flex align-items-center group"> Verify 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="verify-backup" aria-haspopup="dialog" aria-label="Share link: Verify Backup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Verify backup integrity geode backup \ --dest s3://bucket/backups \ --verify \ --backup-id 1738012345 # Output: # Verifying backup 1738012345... # Downloading metadata... # Checking file integrity (SHA256)... # [OK] manifest.json # [OK] data/nodes.db # [OK] data/edges.db # [OK] data/indexes/btree_001.idx # [OK] data/indexes/hash_001.idx # [OK] wal/segment_001.wal # [OK] wal/segment_002.wal # # Verification Summary: # Total files: 127 # Verified: 127 # Failed: 0 # Status: VALID </code></pre></div> <h4 id="delete-backup" class="position-relative d-flex align-items-center group"> Delete 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="delete-backup" aria-haspopup="dialog" aria-label="Share link: Delete Backup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Delete specific backup geode backup \ --dest s3://bucket/backups \ --delete \ --backup-id 1738012345 # Prune old backups geode backup \ --dest s3://bucket/backups \ --prune \ --older-than-days 90 </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://bucket/backups \ --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>Restore to a specific timestamp: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Restore to specific point in time geode restore \ --source s3://bucket/backups \ --backup-id 1738012345 \ --target /var/lib/geode/data \ --pitr-timestamp "2026-01-28 10:30:00" # Output: # Restoring base backup 1738012345... # Base backup restored: 2026-01-28 02:00:00 # # Applying WAL segments... # Segment: wal_000001.gz (02:00:00 - 02:05:00) # Segment: wal_000002.gz (02:05:00 - 02:10:00) # ... # Segment: wal_000102.gz (10:25:00 - 10:30:00) # # Stopping replay at: 2026-01-28 10:30:00 # Recovery complete # Last transaction: txn_1738012345678 </code></pre></div> <h4 id="incremental-restore" class="position-relative d-flex align-items-center group"> Incremental 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="incremental-restore" aria-haspopup="dialog" aria-label="Share link: Incremental Restore"> Share link </button> </h4>Restore chain of incremental backups: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Restore full + all incremental backups geode restore \ --source s3://bucket/backups \ --backup-id 1738271545 \ --target /var/lib/geode/data \ --include-incrementals # Output: # Backup chain detected: # 1. 1738012345 (full, 2026-01-28 02:00:00) # 2. 1738098745 (incremental, 2026-01-29 02:00:00) # 3. 1738185145 (incremental, 2026-01-30 02:00:00) # 4. 1738271545 (incremental, 2026-01-31 02:00:00) # # Restoring base backup... # Applying incremental 1738098745... # Applying incremental 1738185145... # Applying incremental 1738271545... # Restore complete </code></pre></div> <h3 id="automated-backup" class="position-relative d-flex align-items-center group"> Automated 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="automated-backup" aria-haspopup="dialog" aria-label="Share link: Automated Backup"> 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 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" | \ mail -s "[ALERT] Geode Backup Failure" "$ALERT_EMAIL" exit 1 } trap 'handle_error $LINENO' ERR log "=== Starting backup ===" # Determine backup type DOW=$(date +%u) if [ "$DOW" -eq 7 ]; then # Full backup on Sunday log "Creating full backup (Sunday)" BACKUP_ID=$(geode backup \ --dest "$BUCKET" \ --mode full \ --compression gzip \ --verify \ --label "weekly-$(date +%Y%m%d)" 2>&1 | \ grep "Backup ID" | awk '{print $3}') echo "$BACKUP_ID" > /var/lib/geode/last-full-backup log "Full backup completed: $BACKUP_ID" else # Incremental backup on other days log "Creating incremental backup" PARENT=$(cat /var/lib/geode/last-full-backup) BACKUP_ID=$(geode backup \ --dest "$BUCKET" \ --mode incremental \ --parent "$PARENT" \ --compression gzip \ --verify 2>&1 | \ grep "Backup ID" | awk '{print $3}') log "Incremental backup completed: $BACKUP_ID" fi # 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: $BACKUP_ID" | \ mail -s "[OK] Geode Backup Success" "$ALERT_EMAIL" </code></pre></div> <h4 id="cron-schedule" class="position-relative d-flex align-items-center group"> Cron Schedule <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="cron-schedule" aria-haspopup="dialog" aria-label="Share link: Cron Schedule"> 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 backup 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" class="position-relative d-flex align-items-center group"> Systemd Timer <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" aria-haspopup="dialog" aria-label="Share link: Systemd Timer"> 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] OnCalendar=*-*-* 02:00:00 Persistent=true RandomizedDelaySec=300 [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 list-timers geode-backup.timer </code></pre></div> <h3 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> </h3> <h4 id="3-2-1-rule" class="position-relative d-flex align-items-center group"> 3-2-1 Rule <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="3-2-1-rule" aria-haspopup="dialog" aria-label="Share link: 3-2-1 Rule"> Share link </button> </h4><ul> <li>3 copies of data (production + 2 backups)</li> <li>2 different storage types (local + cloud)</li> <li>1 offsite copy (different region)</li> </ul> <h4 id="recommended-schedule" class="position-relative d-flex align-items-center group"> Recommended Schedule <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="recommended-schedule" aria-haspopup="dialog" aria-label="Share link: Recommended Schedule"> Share link </button> </h4><table> <thead> <tr> <th>Backup Type</th> <th>Frequency</th> <th>Retention</th> <th>Storage</th> </tr> </thead> <tbody> <tr> <td>Full</td> <td>Weekly (Sunday)</td> <td>90 days</td> <td>S3 Standard-IA</td> </tr> <tr> <td>Incremental</td> <td>Daily</td> <td>30 days</td> <td>S3 Standard</td> </tr> <tr> <td>WAL Archive</td> <td>Every 5 min</td> <td>7 days</td> <td>S3 Standard</td> </tr> <tr> <td>Monthly Archive</td> <td>Monthly</td> <td>1 year</td> <td>S3 Glacier</td> </tr> </tbody> </table> <h4 id="configuration-example" class="position-relative d-flex align-items-center group"> Configuration Example <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="configuration-example" aria-haspopup="dialog" aria-label="Share link: Configuration Example"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># geode.yaml - Complete backup configuration backup: # S3 storage s3: enabled: true bucket: 'geode-backups' prefix: 'production' region: 'us-east-1' encryption: true storage_class: 'STANDARD_IA' # Automated schedule schedule: enabled: true full_backup: '0 2 * * 0' # Sunday 2 AM incremental_backup: '0 2 * * 1-6' # Mon-Sat 2 AM retention_days: 90 # WAL archiving for PITR wal_archiving: enabled: true destination: s3://geode-backups/wal interval: 5m retention_hours: 168 # Verification verify: enabled: true after_backup: true weekly_full_verify: true # Notifications notifications: email: enabled: true recipients: ['[email protected]'] on_success: false on_failure: true webhook: enabled: true url: 'https://hooks.slack.com/...' </code></pre></div> <h3 id="monitoring-backups" class="position-relative d-flex align-items-center group"> Monitoring 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="monitoring-backups" aria-haspopup="dialog" aria-label="Share link: Monitoring Backups"> Share link </button> </h3> <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"># Exposed backup metrics geode_backup_last_success_timestamp geode_backup_last_failure_timestamp geode_backup_duration_seconds geode_backup_size_bytes geode_backup_age_hours geode_backup_total{status="success|failure"} </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"># prometheus/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" - alert: BackupFailed expr: increase(geode_backup_total{status="failure"}[1h]) > 0 labels: severity: critical annotations: summary: "Geode backup failed" - alert: BackupSlow expr: geode_backup_duration_seconds > 3600 labels: severity: warning annotations: summary: "Backup taking longer than expected" </code></pre></div> <h4 id="monitoring-script" class="position-relative d-flex align-items-center group"> 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="monitoring-script" aria-haspopup="dialog" aria-label="Share link: 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" MAX_AGE_HOURS=26 # Get latest backup LATEST=$(geode backup --dest "$BUCKET" --list --format json | \ jq -r '.backups[0].timestamp') 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 "CRITICAL: Backup is $AGE_HOURS hours old" exit 2 fi echo "OK: Backup is $AGE_HOURS hours old" exit 0 </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-best-practices" class="position-relative d-flex align-items-center group"> Backup 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="backup-best-practices" aria-haspopup="dialog" aria-label="Share link: Backup Best Practices"> Share link </button> </h4><ol> <li>Test restores regularly: Monthly restore verification</li> <li>Encrypt backups: Enable server-side encryption</li> <li>Use compression: Reduce storage costs and transfer time</li> <li>Verify integrity: Check backups after creation</li> <li>Monitor backup age: Alert if backup older than 26 hours</li> <li>Document procedures: Maintain runbooks for restore</li> </ol> <h4 id="storage-best-practices" class="position-relative d-flex align-items-center group"> Storage 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="storage-best-practices" aria-haspopup="dialog" aria-label="Share link: Storage Best Practices"> Share link </button> </h4><ol> <li>Use appropriate storage class: Standard-IA for backups</li> <li>Enable versioning: Protect against accidental deletion</li> <li>Configure lifecycle policies: Automatic transition to Glacier</li> <li>Cross-region replication: DR copy in different region</li> <li>Set retention policies: Auto-delete old backups</li> </ol> <h4 id="security-best-practices" class="position-relative d-flex align-items-center group"> Security 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="security-best-practices" aria-haspopup="dialog" aria-label="Share link: Security Best Practices"> Share link </button> </h4><ol> <li>Encrypt at rest: SSE-S3 or SSE-KMS</li> <li>Encrypt in transit: HTTPS for S3 access</li> <li>IAM least privilege: Minimal permissions for backup</li> <li>Audit access: Enable S3 access logging</li> <li>Separate backup credentials: Don’t use admin credentials</li> </ol> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <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="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="backup-fails-with-timeout" class="position-relative d-flex align-items-center group"> Backup Fails with Timeout <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-fails-with-timeout" aria-haspopup="dialog" aria-label="Share link: Backup Fails with Timeout"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Increase timeout export GEODE_BACKUP_TIMEOUT_MS=600000 # 10 minutes # Use incremental backups for large datasets geode backup --mode incremental --parent <id> </code></pre></div> <h4 id="s3-permission-denied" class="position-relative d-flex align-items-center group"> S3 Permission Denied <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-permission-denied" aria-haspopup="dialog" aria-label="Share link: S3 Permission Denied"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Test S3 access aws s3 ls s3://my-bucket/ # Check IAM policy has required permissions: # - s3:PutObject # - s3:GetObject # - s3:ListBucket # - s3:DeleteObject (for pruning) </code></pre></div> <h4 id="restore-fails-with-corruption" class="position-relative d-flex align-items-center group"> Restore Fails with Corruption <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-fails-with-corruption" aria-haspopup="dialog" aria-label="Share link: Restore Fails with Corruption"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Verify backup integrity geode backup --verify --backup-id <id> # Try previous backup geode backup --list geode restore --backup-id <previous-id> </code></pre></div> <h4 id="slow-backup-performance" class="position-relative d-flex align-items-center group"> Slow Backup Performance <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="slow-backup-performance" aria-haspopup="dialog" aria-label="Share link: Slow Backup Performance"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Increase parallel uploads export AWS_MAX_CONCURRENT_REQUESTS=20 # Use faster compression geode backup --compression lz4 # Check network bandwidth iperf3 -c s3.amazonaws.com -p 443 </code></pre></div> <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/operations/disaster-recovery/" >Disaster Recovery</a> - Complete DR procedures</li> <li><a href="/docs/operations/monitoring/" >Monitoring</a> - Backup monitoring setup</li> <li><a href="/docs/guides/migration-guide/" >Migration Guide</a> - Backup-based migration</li> <li><a href="/docs/guides/backup-automation/" >Backup Automation</a> - Advanced automation</li> </ul>