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.

A category of databases that store data in non-tabular formats, optimized for specific data models and access patterns.

A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.

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.

The process of organizing database tables to reduce data redundancy and improve data integrity.

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

View All Databases Terms →