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

ETL (Extract, Transform, Load)

A data pipeline process that extracts data from sources, transforms it into a suitable format, and loads it into a destination system.

An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.

A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.

An SQL operation that combines rows from two or more tables based on a related column between them.

ORM (Object-Relational Mapping)

A technique that lets you interact with a database using object-oriented code instead of writing raw SQL queries.

A query that transforms rows into columns, creating a pivot table view of aggregated data.

View All Databases Terms →