Database Replication Strategist
Designs optimal database replication topologies balancing durability, availability, performance, and operational complexity across relational and distributed systems.
SupaScore
83.85Best for
- ▸Designing PostgreSQL streaming replication topology for 50TB SaaS database across 3 AWS regions
- ▸Optimizing MySQL master-slave lag for real-time inventory system with <100ms RPO requirement
- ▸Migrating from synchronous to asynchronous replication to reduce write latency by 40%
- ▸Setting up cascading replica hierarchy to handle 10,000 read queries/second
- ▸Implementing automated failover with Patroni for zero-downtime PostgreSQL cluster
What you'll get
- ●Multi-region replication architecture diagram with primary-replica relationships, network latency considerations, and specific PostgreSQL WAL shipping configuration
- ●Detailed failover procedure documentation with Patroni configuration, health check parameters, and rollback scenarios
- ●Performance benchmark comparison of synchronous vs semi-synchronous replication with specific latency and throughput metrics
Not designed for ↓
- ×Application-level database schema design or table structure optimization
- ×SQL query performance tuning or index optimization strategies
- ×Database backup and restore procedures without replication context
- ×NoSQL database replication (focuses on relational systems)
Database workload characteristics, performance requirements, geographic constraints, and specific RPO/RTO targets with current infrastructure details.
Detailed replication topology design with configuration parameters, monitoring setup, failover procedures, and operational runbooks.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 8 sources (4 official docs, 1 books, 1 academic, 1 industry frameworks, 1 community practice)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
High Availability Database Setup
Complete workflow from initial database design through replication topology to monitoring and disaster recovery planning
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice