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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed