Databases Advanced

What is Replication?

The process of copying and maintaining database data across multiple servers for redundancy, failover, and read scaling.

Database replication copies data from a primary server to one or more replicas. Synchronous replication waits for replicas to confirm writes (strong consistency but slower). Asynchronous replication is faster but may have slight data lag.

Use cases include high availability (automatic failover), read scaling (distribute reads across replicas), geographic distribution (replicas near users), and disaster recovery. PostgreSQL supports streaming replication and logical replication.

Learn More About This Topic

PostgreSQL Backup, Replication & High Availability

Directly covers this topic

Redis Fundamentals

Closely related

MariaDB Administration

Closely related

Related Terms

A version-controlled change to a database schema that can be applied and reversed systematically.

Query Optimization

The process of improving database query performance through indexing, query rewriting, and schema design techniques.

A virtual table defined by a SQL query that provides a simplified or restricted view of data from one or more tables.

Window Function

An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.

MVCC (Multi-Version Concurrency Control)

A technique where the database maintains multiple versions of data to allow concurrent reads and writes without locking.

A column or set of columns that uniquely identifies each row in a database table.

View All Databases Terms →