Database Replication
Database replication is the process of copying and synchronizing data from a primary database to one or more secondary databases, used to improve read scalability, availability, and disaster recovery.
20 resources across 4 libraries
Glossary Terms(9)
Couchbase
Couchbase is a distributed NoSQL Document Database that stores JSON documents and combines high-performance key-value access with a SQL-like query language (N1…
RavenDB
RavenDB is an open-source, ACID-compliant NoSQL Document Database built primarily for the .NET ecosystem, designed to combine document flexibility with transac…
Amazon Aurora
Amazon Aurora is a fully managed relational database service on AWS that is compatible with MySQL and PostgreSQL, built on a cloud-native, distributed storage…
Azure Cosmos DB
Azure Cosmos DB is Microsoft's fully managed, globally distributed Multi-Model Database service that supports multiple data models and APIs — including documen…
Memcached
Memcached is an open-source, high-performance, distributed in-memory key-value store used primarily to cache the results of database queries, API calls, and pa…
CAP Theorem
The CAP theorem states that a distributed data system can provide at most two of three guarantees simultaneously during a network partition: Consistency, Avail…
Sharding
Sharding is a database scaling technique that splits a large dataset horizontally across multiple independent database instances (shards), each holding a subse…
Database Replication
Database replication is the process of copying and synchronizing data from a primary database to one or more secondary databases, used to improve read scalabil…
Change Data Capture (CDC)
Change Data Capture (CDC) is a set of techniques for detecting and capturing row-level inserts, updates, and deletes in a source database as they happen, so th…
Study Notes(1)
Cheat Sheets(1)
Interview Questions(9)
What is Database Replication?
Database replication is the process of continuously copying data from one database server (the primary) to one or more other servers (replicas), so multiple co…
What is a Master-Slave Replication Topology?
A master-slave replication topology has exactly one server (the master) accepting all writes, while one or more slave servers continuously receive and apply a…
What is a Master-Master Replication Topology?
A master-master (multi-master) replication topology lets two or more servers each accept writes independently, and every master streams its changes to every ot…
Synchronous vs Asynchronous Replication: What is the Difference?
Synchronous replication waits for at least one replica to confirm it received a write before the primary reports the transaction as committed, while asynchrono…
What Causes Replication Lag and How Do You Reduce It?
Replication lag is the delay between a write committing on the primary and that same write becoming visible on a replica, and it is typically caused by network…
What is Quorum-Based Replication for Reads and Writes?
Quorum-based replication requires a write to be acknowledged by a minimum number of replicas (W) and a read to consult a minimum number of replicas (R) out of…
What is Transaction Log Shipping and How is it Used?
Transaction log shipping is a high-availability technique where the write-ahead or transaction log records generated on a primary database are continuously cop…
What is Database Replication in System Design?
Database replication is the process of copying data from a primary database to one or more replica databases so the system gains redundancy for fault tolerance…
What Are Read Replicas and How Do They Scale Reads?
A read replica is a copy of a primary database that continuously receives updates via replication and serves read-only queries, letting an application scale re…