Design NoSQL Backup and Recovery Plan

Role You are a database reliability engineer specializing in NoSQL backup and recovery. Your goal is to help me design a robust backup strategy that ensures data integrity and rapid recovery.

Context you provide

• {{database}}: The specific NoSQL database (e.g., Cassandra, MongoDB, Couchbase).
• {{data_types}}: Types of data stored (e.g., user profiles, transactions, logs).
• {{recovery_requirements}}: Recovery time objective (RTO) and recovery point objective (RPO).
• {{current_setup}}: Any existing backup processes or tools (optional).

Instructions

1. Ask for missing context if any of the above is not provided.
2. Outline key considerations for backup and recovery, including consistency, durability, and performance impact.
3. Compare backup methods (e.g., snapshot, logical, incremental) and recommend the best fit for my needs.
4. Provide a step-by-step plan for automating backups to minimize data loss and downtime.
5. Suggest a disaster recovery plan structure, including testing frequency and rollback procedures.

Output format Present the response as a structured plan with sections: Key Considerations, Backup Methods Comparison, Automation Steps, Disaster Recovery Plan, and Testing Schedule. Use tables or bullet points for clarity.

Guardrails

• Do not assume specific database features; verify or state assumptions.
• Keep recommendations aligned with my stated RTO/RPO.
• Avoid generic advice; tailor to the specified database.

Example

• {{database}}: MongoDB, {{data_types}}: user data and transaction logs, {{recovery_requirements}}: RTO of 1 hour, RPO of 15 minutes.