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.

40 canonical articlesBrowse the complete archive

Popular Searches

Latest Articles

Showing 12 of 40 articles

Database Disaster Recovery Runbook: RTO, RPO, and PITR Procedures

Build a production database DR runbook covering RTO/RPO definitions, failover steps, PITR recovery commands, and a verification checklist. Test it quarterly.

AWS7 minOct 14, 2025
Read

Multi-Region Database Architecture: Active-Passive, Aurora Global, and Read Routing

Design multi-region database topologies for global latency and DR. Compares active-passive, Aurora Global Database replication, and application-level read routing patterns.

AWS7 minOct 9, 2025
Read

Zero-Downtime PostgreSQL Major Version Upgrade with Logical Replication

Upgrade PostgreSQL major versions with sub-second downtime using logical replication. Step-by-step guide covering schema copy, subscription setup, lag monitoring, and sequence resync.

PostgreSQL1 minSep 22, 2025
Read

Aerospike 7.0: Strong Consistency and Sub-Millisecond Latency at Scale

Aerospike 7.0 delivers 1 million writes per second with sub-millisecond latency using its Hybrid Memory Storage architecture. Learn when Aerospike beats Redis and Cassandra, and how to configure it for production.

4 minSep 9, 2025
Read

PostgreSQL 17 Logical Replication: Failover Slots and Row Filtering

Logical replication in PostgreSQL has a critical gap: slots do not survive failover. PostgreSQL 17 finally fixes this with failover slots, plus adds row and column filtering for selective replication.

PostgreSQL8 minJun 10, 2025
Read

MySQL Group Replication vs Galera Cluster: A 2025 Comparison

MySQL Group Replication and Galera Cluster both promise multi-primary high availability, but they behave very differently under load, network partitions, and node failures.

MySQL9 minJun 3, 2025
Read

MySQL Group Replication: Single-Primary Cluster Setup

Configure MySQL Group Replication (MGR) with Paxos-based consensus for fault-tolerant clustering. Covers prerequisites, bootstrap, joining nodes, and health monitoring.

MySQL1 minMar 14, 2025
Read

MongoDB 8.0 Replication: New Features, Improvements, and What Changed

MongoDB 8.0 brings significant replication improvements including faster elections, durable oplog writes, and changes to write concern behavior. Here's what changed and how to take advantage of it.

MongoDB8 minMar 11, 2025
Read

PostgreSQL Disaster Recovery: Backup, Restore, and PITR

Choose PostgreSQL backup and recovery methods from explicit RTO and RPO, preserve continuous WAL, verify manifests, and rehearse isolated restores.

PostgreSQL7 minFeb 19, 2025
Read

MongoDB Replica Set Operations: Adding Members, Failover, and Lag Diagnosis

Day-to-day MongoDB replica set operations: adding/removing members, triggering elections, diagnosing replication lag, and managing oplog size.

MongoDB1 minFeb 12, 2025
Read

TiDB's Raft-Based Replication: How Distributed Consensus Keeps Your Data Safe

TiDB uses Raft consensus protocol through TiKV to replicate every region across three or more nodes. Here's how leader election, log replication, and region management work in practice.

TiDB9 minMay 20, 2024
Read

PostgreSQL 17 Incremental Backup: pg_basebackup and pg_combinebackup Explained

PostgreSQL 17 finally adds native incremental backup support — allowing subsequent backups to capture only changed blocks since the last full backup.

PostgreSQL9 minFeb 9, 2024
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