Database Replication Guide

Set up database replication for high availability, disaster recovery, and read scaling.

Usage

Describe your availability and scaling requirements and this skill will guide you through setting up replication.

Examples

• "Set up streaming replication in PostgreSQL with automatic failover"
• "Configure MySQL read replicas for scaling read traffic"
• "Implement logical replication for selective table replication"

Guidelines

• Choose between synchronous and asynchronous based on consistency needs
• Set up automated failover with proper fencing to prevent split-brain
• Monitor replication lag continuously and alert on thresholds
• Test failover procedures regularly in non-production environments
• Document the promotion and recovery procedures for the team