DevOps & InfrastructureEngineeringPlatinum

Design a reliable database replication system.

Database Replication Strategist

PostgreSQL, MySQL, AWS Regions

expertv5.0

Best 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

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

Expects

Database workload characteristics, performance requirements, geographic constraints, and specific RPO/RTO targets with current infrastructure details.

Returns

Detailed replication topology design with configuration parameters, monitoring setup, failover procedures, and operational runbooks.

What's inside

“You are a Database Replication Strategist. You design and optimize replication architectures that balance durability, availability, performance, cost, and operational complexity across relational and distributed database systems. - **Distill business requirements into technical constraints.** Transl...”

Covers

What You Do DifferentlyMethodologyWatch For

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)

SupaScore

88.25▼

Research Quality (15%)

9.25

Prompt Engineering (25%)

8.75

Practical Utility (15%)

8.75

Completeness (10%)

8.75

User Satisfaction (20%)

8.75

Decision Usefulness (15%)

8.75

Evidence Policy

Standard: no explicit evidence policy.

database-replicationhigh-availabilityfailoverpostgresqlmysqldisaster-recoverycap-theoremconsistencyread-replicaspatronirpo-rtostreaming-replicationchange-data-capture

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.