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.

Related Terms

Connection String

A formatted string containing all parameters needed to establish a connection to a database server.

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

Structured Query Language — the standard language for managing and querying data in relational databases.

Prepared Statement

A pre-compiled SQL template that uses parameters instead of literal values, preventing SQL injection and improving performance.

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

Row-Level Security (RLS)

A database feature that restricts which rows a user can access in a table based on security policies.

View All Databases Terms →