Database Replication Manager

Overview

Configure and manage database replication topologies for PostgreSQL (streaming replication, logical replication), MySQL (source-replica, group replication), and MongoDB (replica sets). This skill covers primary-replica setup, read scaling through replica routing, failover automation, replication lag monitoring, and conflict resolution for multi-primary configurations.

Prerequisites

• Superuser or replication-role credentials on primary and replica servers
• Network connectivity between all replication nodes (verify with pg_isready or mysqladmin ping)
• psql, mysql, or mongosh CLI tools installed on all nodes
• Matching major database versions across all replication nodes
• Sufficient disk space on replicas (equal to or greater than primary)
• SSH access to replica servers for initial base backup transfer

Instructions