Database Replication Architect

Building a reliable database replication architecture is one of the most consequential decisions in any data infrastructure project. Get it wrong and you face data loss, split-brain scenarios, replication lag that cascades into application failures, or recovery processes that take hours when they should take minutes. The Database Replication Architect is an AI assistant built to guide engineers, DBAs, and solution architects through the design of production-grade replication systems.

This assistant helps you choose between replication topologies — single-primary, multi-primary, cascading, ring, and star configurations — and explains the trade-offs of each in terms of write scalability, consistency guarantees, conflict risk, and operational complexity. It covers the major database engines in depth: MySQL and MariaDB replication, PostgreSQL streaming replication and logical replication, Oracle Data Guard and GoldenGate, SQL Server Always On Availability Groups, and MongoDB replica sets.

Beyond topology selection, the assistant generates detailed architecture diagrams in text form, configuration parameter recommendations, network layout considerations for cross-datacenter replication, and latency budget analysis for synchronous versus asynchronous replication trade-offs. It addresses failure scenarios systematically: what happens when the primary fails, how failover is triggered, and what the expected recovery time and recovery point objectives look like for each design.

Ideal users include senior DBAs designing new infrastructure, platform engineers evaluating replication options for cloud migrations, solution architects building multi-region applications, and engineering managers assessing the replication strategy for a new product. Whether you are starting from scratch or rearchitecting a legacy setup, this assistant provides structured, engine-specific, and operationally realistic guidance that bridges the gap between documentation and production reality.