The JusDB Database Engineering Blog

MongoDB's Slot-Based Execution (SBE) engine introduced a plan cache memory leak affecting certain MongoDB versions — here's how to detect, mitigate, and fix it.

AWS DMS can migrate terabytes of data with zero downtime — but default settings leave significant performance on the table. Here's how to tune DMS for production-grade migrations.

In 2026, more database versions are hitting end-of-life than any year in recent history.

Master InnoDB buffer pool internals: page management, chunk allocation, LRU algorithm, and tuning strategies for maximum cache efficiency.

Benchmark MySQL with sysbench OLTP workloads. Covers setup, read/write and read-only suites, interpreting TPS and 95th percentile latency, and comparing before/after changes.

Use pgbench to benchmark PostgreSQL before and after configuration changes. Covers scale factor selection, TPC-B and read-only workloads, custom SQL scripts, and latency percentiles.

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

Connection exhaustion is one of the most common causes of database downtime at scale. Here is how production teams use PgBouncer and ProxySQL to handle 10,000+ concurrent connections.

Explore PostgreSQL 18 revolutionary features including async I/O, improved parallelism, enhanced JSON support, and developer experience improvements coming in 2025.

A detailed comparison of ClickHouse and BigQuery for analytical workloads — MergeTree engine vs Capacitor storage, self-hosted vs serverless cost models, query latency, real-time ingestion, and when to choose each.

MySQL InnoDB full-text search is underused and often misconfigured. With 8.4 LTS, new defaults and tuning opportunities can cut FTS query time by 60% or more.

PostgreSQL offers multiple index types for different access patterns — and choosing wrong means slow queries or wasted space. A comprehensive guide to indexing strategy, from type selection to monitoring and maintenance.