Prompt lesson · 22 prompts
Replication and Redundancy prompts for Database Administrators
22 ready-to-use prompts from our AI for Database Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Monitor Database Replication Status
Use this when you need to check the real-time status of database replication, identify errors or delays, and set up monitoring for your replication processes.
Role You are a database operations specialist focused on replication health and data consistency. Your goal is to help monitor replication status, diagnose issues, and ensure data is accurately synchronized.
Context you provide
- {{database_name}}: The name or identifier of the database you are monitoring.
- {{replication_type}}: The type of replication in use (e.g., master-slave, multi-master, logical).
- {{monitoring_tool}}: Any existing monitoring tools or dashboards you use (optional).
Instructions
- Ask for any missing context before starting.
- Describe the key metrics and indicators to check for replication health (e.g., lag, error logs, sync status).
- Provide a step-by-step guide to query or inspect the replication status for {{database_name}}.
- Explain how to interpret common errors and delays, and what actions to take for each.
- Suggest how to set up proactive monitoring and alerts for replication issues.
Output format Provide a structured response with sections: Key Metrics, Status Check Steps, Common Issues & Resolutions, and Monitoring Setup. Use concise, technical language.
Guardrails
- Do not claim to have live access to the database; provide instructions and interpretation guidance only.
- Flag any assumptions about the replication setup that may affect the analysis.
- Stay focused on replication monitoring; do not cover general database performance tuning.
Example database_name: prod_users, replication_type: master-slave, monitoring_tool: Prometheus.
Open this prompt Analysis · Intermediate
Troubleshoot Database Replication Issues
Use this when you need to diagnose and resolve problems in database replication, such as network issues, configuration errors, or constraint violations.
Role You are a database reliability engineer with deep expertise in replication troubleshooting. Your goal is to guide systematic diagnosis and resolution of replication failures, minimizing downtime and data loss.
Context you provide
- {{database_name}}: The specific database system (e.g., PostgreSQL, MySQL, MongoDB).
- {{replication_setup}}: Brief description of the replication topology (e.g., primary-secondary, multi-node).
- {{symptom}}: The exact error message or observed issue (e.g., replication lag, failure, constraint violation).
- {{recent_changes}}: Any recent changes to network, configuration, or schema that might have caused the issue.
Instructions
- If any required input is missing, ask for it before proceeding.
- Based on the symptom, propose a step-by-step troubleshooting approach, including:
- Checking replication status and logs.
- Verifying network connectivity and firewall rules.
- Reviewing configuration parameters for both primary and replica.
- Inspecting for schema mismatches or constraint violations.
- For each step, explain what to look for and how to interpret the results.
- Provide potential solutions for common issues, and indicate when to escalate to vendor support.
- Suggest preventive measures to avoid similar issues in the future.
Output format Provide a structured troubleshooting guide in markdown, with numbered steps, diagnostic commands, and expected outputs. Use tables for common errors and fixes. Keep the tone practical and actionable.
Guardrails
- Do not assume specific log formats or commands; if uncertain, recommend checking official documentation.
- Do not recommend destructive actions (e.g., dropping data) without explicit user confirmation.
- Flag any steps that require production access or maintenance windows.
Example
- database_name: PostgreSQL, replication_setup: primary with two streaming replicas, symptom: 'replication stopped with error: could not receive data from WAL stream', recent_changes: upgraded to PostgreSQL 15.
Open this prompt Analysis · Intermediate
Configure Database Replication Settings
Use this when you need step-by-step guidance on setting up or troubleshooting replication parameters in a database system.
Open this prompt Planning · Intermediate
Implement Database Redundancy Strategies
Use this when you need to design and implement redundancy measures like failover servers or distributed systems for your database infrastructure.
Open this prompt Planning · Intermediate
Manage Database Backup and Restore
Use this when you need to create backup schedules, execute backups, or restore data from backups for your database systems.
Open this prompt Planning · Intermediate
Test Database Replication and Redundancy
Use this when you need to design and execute test scenarios to validate the reliability of database replication and redundancy mechanisms.
Open this prompt Planning · Intermediate
Optimize Database Replication Performance
Use this when you need to improve the speed and efficiency of database replication, including network tuning, configuration adjustments, and compression techniques.
Open this prompt Analysis · Advanced
Document Replication and Redundancy
Use this when you need to create comprehensive documentation for database replication and redundancy processes, including guides and best practices.
Open this prompt Creating · Intermediate
Upgrade Database Replication Technologies
Use this when you need to plan and execute an upgrade or migration of database replication technologies with minimal downtime and risk.
Open this prompt Planning · Advanced
Develop Disaster Recovery Plan
Use this when you need to create or refine a disaster recovery plan, including defining recovery objectives and identifying critical data.
Open this prompt Planning · Intermediate
Build Replication Monitoring System
Use this when you need to design or improve an automated system that monitors database replication and provides real-time alerts.
Open this prompt Planning · Advanced
Optimize Replication Performance
Use this when you need to analyze and improve the performance of database replication, identifying bottlenecks and applying best practices.
Open this prompt Analysis · Advanced
Plan Redundancy Strategy
Use this when you need to devise a comprehensive redundancy strategy, including failover mechanisms, backup solutions, and disaster recovery plans for your database.
Open this prompt Planning · Intermediate
Troubleshoot Replication Issues
Use this when you need to diagnose and resolve database replication problems quickly, such as network issues, data conflicts, or lag.
Open this prompt Analysis · Intermediate
Test Redundancy Measures
Use this when you need to design and execute tests to validate your database redundancy measures, ensuring data integrity and availability under failure scenarios.
Open this prompt Planning · Intermediate
Automate Replication Processes
Use this when you want to automate your database replication tasks to improve efficiency, reduce manual errors, and streamline operations.
Open this prompt Automation · Advanced
Audit Database Redundancy Configurations
Use this when you need to perform a systematic audit of your database redundancy setups to ensure compliance, identify vulnerabilities, and improve efficiency.
Open this prompt Analysis · Advanced
Enhance Replication Security
Use this when you need to strengthen the security of database replication, including encryption, access controls, and authentication.
Open this prompt Planning · Intermediate
Estimate Redundancy Capacity
Use this when you need to estimate the redundancy capacity required for your database infrastructure based on data growth and availability needs.
Open this prompt Analysis · Intermediate
Design Replication Monitoring Dashboard
Use this when you need to design or improve a dashboard for monitoring database replication status and performance.
Open this prompt Planning · Intermediate
Document Redundancy Configurations
Use this when you need to create comprehensive documentation for your database redundancy configurations and processes to support team knowledge sharing and operational consistency.
Open this prompt Creating · Beginner
Ensure Replication Policy Compliance
Use this when you need to audit database replication setups against internal policies and implement corrective actions for compliance.
Open this prompt Analysis · Intermediate