Backup Disaster Recovery

aj-geddes/useful-ai-prompts/skills/backup-disaster-recovery

作者 aj-geddes3f5182cfd739无许可证355 个星标收录于 2026年10月8日更新于 2026年10月8日仓库7个月前更新

Implement backup strategies, disaster recovery plans, and data restoration procedures for protecting critical infrastructure and data.

AI 生成的概览

为关键基础设施设计备份策略、灾难恢复计划和数据恢复流程。

功能
该技能指导备份与灾难恢复策略的设计与实施,涵盖数据库备份配置、恢复脚本、跨区域故障转移以及灾难恢复计划模板。它会产出配置示例、恢复流程和规划文档,并附带一个模式校验脚本和一个迁移 SQL 模板。
适用场景
适用于规划数据保护、业务连续性或灾难恢复的场景,包括时间点恢复、跨区域故障转移、数据迁移以及合规或审计要求。
运行要求
运行 shell 脚本(scripts/validate-schema.sh),并包含参考文档和一个 SQL 迁移模板。数据库备份示例涉及 PostgreSQL 连接设置和凭据,如 POSTGRES_HOST、POSTGRES_USER 和 POSTGRES_PASSWORD。

Backup and Disaster Recovery

Table of Contents

Overview

Design and implement comprehensive backup and disaster recovery strategies to ensure data protection, business continuity, and rapid recovery from infrastructure failures.

When to Use

  • Data protection and compliance
  • Business continuity planning
  • Disaster recovery planning
  • Point-in-time recovery
  • Cross-region failover
  • Data migration
  • Compliance and audit requirements
  • Recovery time objective (RTO) optimization

Quick Start

Minimal working example:

yaml
# postgres-backup-cronjob.yamlapiVersion: v1kind: ConfigMapmetadata:  name: backup-script  namespace: databasesdata:  backup.sh: |    #!/bin/bash    set -euo pipefail
    BACKUP_DIR="/backups/postgresql"    RETENTION_DAYS=30    DB_HOST="${POSTGRES_HOST}"    DB_PORT="${POSTGRES_PORT:-5432}"    DB_USER="${POSTGRES_USER}"    DB_PASSWORD="${POSTGRES_PASSWORD}"
    export PGPASSWORD="$DB_PASSWORD"
    # Create backup directory    mkdir -p "$BACKUP_DIR"
    # Full backup    BACKUP_FILE="$BACKUP_DIR/full-$(date +%Y%m%d-%H%M%S).sql"// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

GuideContents
Database Backup Configuration [blocked]Database Backup Configuration
Disaster Recovery Plan Template [blocked]Disaster Recovery Plan Template
Backup and Restore Script [blocked]Backup and Restore Script
Cross-Region Failover [blocked]Cross-Region Failover

Best Practices

✅ DO

  • Perform regular backup testing
  • Use multiple backup locations
  • Implement automated backups
  • Document recovery procedures
  • Test failover procedures regularly
  • Monitor backup completion
  • Use immutable backups
  • Encrypt backups at rest and in transit

❌ DON'T

  • Rely on a single backup location
  • Ignore backup failures
  • Store backups with production data
  • Skip testing recovery procedures
  • Over-compress backups beyond recovery speed needs
  • Forget to verify backup integrity
  • Store encryption keys with backups
  • Assume backups are automatically working

来源与署名

来源:aj-geddes/useful-ai-prompts位于skills/backup-disaster-recovery提交3f5182c

许可证: 无许可证

内容归原作者所有。SourceWeft 从公开仓库中收录这些内容。

举报或申请下架