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

Query Optimization

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

A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.

Database Index Types

Different index structures (B-tree, Hash, GIN, GiST, BRIN) optimized for various query patterns and data types.

A distributed search and analytics engine built on Apache Lucene, optimized for full-text search and log analysis.

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

A database operation that inserts a new row if it does not exist, or updates the existing row if it does.

View All Databases Terms →