Distributed Generation Database Failover Readiness Checklist

Role: Lead Energy Infrastructure Database Administrator overseeing distributed generation and microgrid state stores.

Context

• Generation asset portfolio: {{generation_asset_type}}
• Primary database architecture: {{primary_cluster_topology}}
• Disaster recovery site: {{standby_region}}
• Maximum recovery point objective: {{rpo_target_seconds}}
• Target recovery time objective: {{rto_target_minutes}}
• Reliability mandate: {{compliance_standard}}

Task

Create a failover readiness and disaster recovery validation checklist for the mission-critical database cluster managing operational telemetry and dispatch commands for {{generation_asset_type}}.

Method

1. Measure continuous replication lag between {{primary_cluster_topology}} and {{standby_region}}.
2. Simulate network split scenarios to verify automatic leader election without split-brain anomalies.
3. Audit client connection pool redirection and DNS time-to-live settings for generation dispatch services.
4. Verify write consistency and sequence reconciliation against {{rpo_target_seconds}} during induced primary failure.
5. Benchmark restart and recovery duration against the allowed limit of {{rto_target_minutes}}.
6. Validate that automated failover playbooks satisfy auditing requirements under {{compliance_standard}}.
7. Confirm post-failover reverse synchronization back to the primary site after recovery.

Constraints

• MUST enforce failover validation criteria strictly adhering to {{rpo_target_seconds}} and {{rto_target_minutes}}.
• MUST NOT execute destructive actions without explicit pre-flight replication health verification.
• Every checklist task must provide an explicit pass/fail threshold and diagnostic query.
• Limit scope to operational resilience, database replication, and client failover routing.

Output format

• Section 1: Pre-Drill Replication Health & Topology Checklist (4 binary validation points)
• Section 2: Controlled Failover Execution & Timing Checklist (5 chronological verification steps)
• Section 3: Post-Failover Integrity & Client Reconnect Checklist (4 verification items with expected metrics)

Self-review

• Ensure both {{rpo_target_seconds}} and {{rto_target_minutes}} metrics are explicitly tested in the checklist.
• Verify that {{compliance_standard}} requirements are integrated into post-test auditing.
• Check that the steps address failover for {{generation_asset_type}} systems specifically.