备份与灾难恢复策略指南 - 数据库备份、跨区域故障转移、业务连续性规划

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

207 周安装量

144 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill backup-disaster-recovery

数据库开发运维安全

🇨🇳中文介绍

备份与灾难恢复

概述

设计和实施全面的备份与灾难恢复策略，以确保数据保护、业务连续性，并能从基础设施故障中快速恢复。

使用场景

数据保护与合规性
业务连续性规划
灾难恢复规划
时间点恢复
跨区域故障转移
数据迁移
合规与审计要求
恢复时间目标优化

快速开始

最小工作示例：

# postgres-backup-cronjob.yaml
apiVersion: v1
kind: ConfigMap
metadata:
  name: backup-script
  namespace: databases
data:
  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"
// ... (完整实现请参阅参考指南)

参考指南

references/ 目录下的详细实现：

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
数据库备份配置	数据库备份配置
灾难恢复计划模板	灾难恢复计划模板
备份与恢复脚本	备份与恢复脚本
跨区域故障转移	跨区域故障转移

🇺🇸English

Backup and Disaster Recovery

Overview
When to Use
Quick Start
Reference Guides
Best Practices

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:

# postgres-backup-cronjob.yaml
apiVersion: v1
kind: ConfigMap
metadata:
  name: backup-script
  namespace: databases
data:
  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:

Guide	Contents
Database Backup Configuration	Database Backup Configuration
Disaster Recovery Plan Template	Disaster Recovery Plan Template
Backup and Restore Script	Backup and Restore Script
Cross-Region Failover	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

Weekly Installs

162

Repository

aj-geddes/usefu…-prompts

GitHub Stars

121

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubFail SocketWarn SnykPass

Installed on

opencode139

gemini-cli136

codex131

cursor125

github-copilot118

claude-code106