---
title: "What is DB Replication?"  
description: "What is DB Replication?"  
author: "Anubhav Sharma"  
published: 2026-01-26  
updated: 2026-01-26  
canonical: https://www.mindstick.com/interview/34444/what-is-db-replication  
category: "database"  
tags: ["database"]  
reading_time: 3 minutes  

---

# What is DB Replication?

> **DB Replication** ([Database Replication](https://www.ibm.com/think/topics/data-replication)) is the process of **copying data from one database to one or more other databases** so that all of them stay in sync.

- In simple terms:\ **the same data exists in multiple databases.**

### How DB Replication Works

- One database acts as the **Primary (Master)**
- Other databases act as **Replicas (Slaves)**
- Changes (INSERT, UPDATE, DELETE) on the primary are **copied to replicas**

### Why DB Replication Is Used

- **High availability** – database still works if one server fails
- **Read scaling** – read queries can go to replicas
- **Disaster recovery** – backup databases are ready
- **Performance improvement** – reduces load on the main DB

### Types of DB Replication

- **Synchronous** – data is written to all replicas immediately
- **Asynchronous** – replicas update after a short delay (most common)
- **Semi-synchronous** – hybrid approach

### Example

- Writes → Primary DB
- Reads → Replica DBs

Used heavily in **MySQL, PostgreSQL, SQL Server, MongoDB**, and cloud databases.

### DB Replication vs Sharding

- **Replication** = same data copied
- [**Sharding**](https://answers.mindstick.com/blog/33/database-sharding-a-practical-guide-to-scaling-modern-applications) = data split into parts

**In one line:**\
DB Replication keeps **multiple databases in sync** to improve **availability, performance, and reliability**.

## Answers

### Answer by Anubhav Sharma

> **DB Replication** ([Database Replication](https://www.ibm.com/think/topics/data-replication)) is the process of **copying data from one database to one or more other databases** so that all of them stay in sync.

- In simple terms:\ **the same data exists in multiple databases.**

### How DB Replication Works

- One database acts as the **Primary (Master)**
- Other databases act as **Replicas (Slaves)**
- Changes (INSERT, UPDATE, DELETE) on the primary are **copied to replicas**

### Why DB Replication Is Used

- **High availability** – database still works if one server fails
- **Read scaling** – read queries can go to replicas
- **Disaster recovery** – backup databases are ready
- **Performance improvement** – reduces load on the main DB

### Types of DB Replication

- **Synchronous** – data is written to all replicas immediately
- **Asynchronous** – replicas update after a short delay (most common)
- **Semi-synchronous** – hybrid approach

### Example

- Writes → Primary DB
- Reads → Replica DBs

Used heavily in **MySQL, PostgreSQL, SQL Server, MongoDB**, and cloud databases.

### DB Replication vs Sharding

- **Replication** = same data copied
- [**Sharding**](https://answers.mindstick.com/blog/33/database-sharding-a-practical-guide-to-scaling-modern-applications) = data split into parts

**In one line:**\
DB Replication keeps **multiple databases in sync** to improve **availability, performance, and reliability**.


---

Original Source: https://www.mindstick.com/interview/34444/what-is-db-replication

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.