The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

45 canonical articlesBrowse the complete archive

Popular Searches

Replication Articles

← Clear filter

Showing 9 of 45 articles

PostgreSQL Logical Replication: Setup, Use Cases, and Limitations

Configure PostgreSQL logical replication for selective table sync, zero-downtime upgrades, and multi-tenant setups

PostgreSQL9 minNov 8, 2022
Read

Apache Kafka for Database Engineers: A Practical Introduction

Understand Kafka from a database perspective — partitions, offsets, consumer groups, and durability guarantees

Kafka11 minSep 28, 2022
Read

MySQL Replication Filters: Selective Replication for Specific Databases and Tables

MySQL replication filters let you replicate only specific databases or tables — but misconfiguration can silently drop transactions. Here's how to use binlog-do-db, replicate-do-db, and replicate-do-table safely.

MySQL8 minSep 24, 2022
Read

MySQL Replication Lag: Causes, Diagnosis, and Fixes

A comprehensive guide to MySQL replication lag — why it happens, why Seconds_Behind_Master lies, how to measure accurately with pt-heartbeat, and how to fix it with multi-threaded replication and LOGICAL_CLOCK parallelism.

MySQL13 minSep 15, 2022
Read

MySQL GTID Replication: Complete Setup and Failover Guide

GTIDs eliminate manual binlog position tracking in MySQL replication. This guide covers enabling GTIDs, CHANGE MASTER TO MASTER_AUTO_POSITION, and failover.

MySQL9 minAug 11, 2022
Read

Airbyte: Open-Source ELT for Database Replication

Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms

11 minJul 14, 2022
Read

Mastering MySQL Group Replication: The Road to Fault-Tolerant Databases

Build fault-tolerant MySQL clusters with Group Replication. Learn multi-primary vs single-primary modes, conflict resolution, network partitioning handling, and failover strategies.

MySQL4 minJul 12, 2022
Read

MySQL Galera Cluster: Setup, Tuning, and Common Pitfalls

Set up MySQL Galera Cluster for synchronous multi-master replication — configuration, split-brain avoidance, and monitoring

MySQL13 minApr 18, 2022
Read

ProxySQL Read/Write Splitting for MySQL Replication: Complete Setup Guide

ProxySQL's read/write splitting routes SELECT queries to replicas and writes to the primary automatically — but getting the configuration right requires understanding hostgroups, query rules, and lag-aware routing.

MySQL9 minFeb 20, 2022
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed