The JusDB Database Engineering Blog

MySQL offers multiple replication topologies — traditional async replication, semi-sync, Group Replication, and InnoDB Cluster. Understanding the trade-offs determines whether your failover takes seconds or minutes.

Learn how JusDB optimized a TimescaleDB cluster ingesting billions of IoT readings monthly, achieving 10× faster writes and 65% storage reduction.

Design PostgreSQL HA with Patroni 4.1, a protected quorum DCS, HAProxy role checks, explicit durability choices, and rehearsed switchover and recovery.

PostgreSQL PITR lets you recover your database to any point in time — down to the second — by replaying WAL segments on top of a base backup. Here's how to set it up correctly.

Monitor PostgreSQL streaming replication lag, replication slots, and standby health to ensure HA readiness

A complete guide to PostgreSQL replication — streaming replication setup, logical replication for selective table sync, synchronous standby configuration, monitoring replication lag, and failover with Patroni.

RTO and RPO drive backup decisions. This guide covers mysqldump, XtraBackup, pgBackRest, WAL archiving, S3 object lock, and the 3-2-1-1-0 backup rule.

Running a single PMM server is a single point of failure for your database monitoring. Here's how to set up PMM in an HA configuration with failover and shared storage.

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

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

Use Percona XtraBackup to take hot physical backups of MySQL InnoDB — setup, verification, and restore steps

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