Database Replication articles

1/17/2025 • EN

Logical replication in Postgres: Basics

A technical guide to setting up and understanding logical replication between two PostgreSQL databases, including setup steps and limitations.

Database Replication Logical Replication Postgres 17 postgresql

Phil Eaton

12/3/2024 • EN

Failover Replication Slots with Postgres 17

Explains how Postgres 17 introduces built-in failover replication slots, improving high availability for logical replication and CDC tools like Debezium.

change data capture Database Replication Failover Logical Replication postgresql

Gunnar Morling

12/19/2023 • EN

Using Stand-by Servers for Postgres Logical Replication

Explores PostgreSQL 16's new feature for logical replication from standby servers, covering setup, benefits, and integration with CDC tools like Debezium.

change data capture Database Replication Logical Replication postgres Stand By Servers

Gunnar Morling

11/27/2019 • EN

Use replica database for read-only transactions

A guide to configuring a Spring Boot application to route read-only database transactions to a replica instance for performance optimization.

AWS Rds Database Replication Mariadb Read Only Transactions spring boot

Paweł Chudzik

11/1/2018 • EN

Azure SQL DB Readable Secondary

Explains how to configure and use the Read Scale-Out feature for Azure SQL Database Premium tier to offload read workloads to secondary replicas.

Azure SQL Database Database Replication Disaster Recovery High Availability Read Scale Out

Niko Neugebauer

2/9/2007 • EN

MySQL Replication

A practical guide to setting up MySQL replication, covering master-slave configuration, log files, and initial data synchronization.

Binlog Data Synchronization Database Replication mysql Server ID

Hynek Schlawack