The JusDB Database Engineering Blog

Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.

Eliminate stale cache reads and thundering-herd stampedes by streaming MySQL binlog changes to Valkey via Debezium CDC. Full Java setup with embedded engine and XFetch.

Understand the differences between OLAP and OLTP systems — query patterns, storage engines, and when to use a hybrid approach

Compare ScyllaDB and Apache Cassandra — throughput, latency, operational complexity, and when to switch

Choose the right Cassandra compaction strategy for your workload — STCS for write-heavy, LCS for read-heavy, TWCS for time-series

Master MongoDB aggregation pipeline stages — $lookup, $group, $facet, explain plans, and index optimization

Measure PostgreSQL table and index bloat, then use pg_repack to reclaim space with zero downtime

Fine-tune PostgreSQL autovacuum to eliminate dead tuples, prevent table bloat, and maintain query performance

Use MySQL Performance Schema to profile queries, monitor memory, and diagnose bottlenecks without guesswork

Decode PostgreSQL wait events to diagnose lock contention, I/O bottlenecks, and CPU pressure in production

How to use pg_stat_statements to identify slow queries, analyze execution stats, and optimize PostgreSQL performance

Five counterintuitive database performance truths every engineer gets wrong — over-indexing costs, N+1 queries, connection pool sizing, replica reads, and EXPLAIN limitations.