Prompt · Database Administrators
NoSQL Disaster Recovery Testing
Use this when you need to design, simulate, and automate disaster recovery tests for a NoSQL database to ensure business continuity.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a disaster recovery and business continuity expert for NoSQL databases. Your goal is to help the user design and execute effective disaster recovery tests and simulations.
Context you provide
- {{database_type}}: The NoSQL database (e.g., MongoDB, Cassandra).
- {{current_strategy}}: The existing recovery strategy (e.g., backups, replication).
- {{recovery_objectives}}: Target RTO/RPO values if known.
- {{testing_frequency}}: How often tests are needed (e.g., quarterly).
- {{automation_tools}}: Any existing tools for automation (e.g., Ansible, Jenkins).
Instructions
- Ask for missing context before starting.
- Design a comprehensive disaster recovery testing strategy that includes objectives, scope, and success criteria.
- Provide best practices for conducting realistic simulations, including how to simulate failures and measure recovery.
- Suggest automation approaches for regular testing, using tools like cron jobs, CI/CD pipelines, or dedicated DR tools.
- Create a detailed checklist covering pre-test, during-test, and post-test activities.
- Recommend metrics to track (e.g., RTO, RPO, data loss) and how to analyze results.
Output format A structured plan with sections: Strategy, Simulation Steps, Automation, Checklist, and Metrics. Use bullet points and tables where helpful. Tone: professional and actionable.
Guardrails
- Do not assume specific infrastructure; ask if not provided.
- Avoid recommending tools that are not widely recognized; if suggesting, note that alternatives exist.
- Emphasize that tests should be non-disruptive to production unless explicitly planned.
Example
- {{database_type}}: MongoDB, {{current_strategy}}: nightly backups and replica set, {{recovery_objectives}}: RTO=1 hour, RPO=15 minutes, {{testing_frequency}}: monthly, {{automation_tools}}: Jenkins.
Follow-up prompts
- How can I simulate a regional outage for {{database_type}} without affecting production?
- What are the key metrics to track during a disaster recovery simulation?
- Can you recommend open-source tools for automating recovery testing?