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
Featured Articles
Hand-picked by our editors
StarRocks Monitoring & Alerting: The Complete Production Guide
Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.
Latest Articles
Showing 12 of 404 articles
Database Observability: Metrics, Logs, Traces, and Prometheus Alerting
Build a complete database observability stack with Prometheus metrics, slow query logs, and OpenTelemetry distributed traces. Includes alert rules for replication lag and cache hit rate.
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.
MySQL Schema Migration Best Practices: Expand-Contract and Batch Backfills
Execute MySQL schema migrations safely with the expand-contract pattern, batched backfills, backward-compatible changes, and migration tooling comparison (Flyway, Liquibase, gh-ost).
ClickHouse MergeTree Engine: Storage Architecture and Query Optimization
ClickHouse MergeTree is why ClickHouse queries 1 billion rows in 0.3 seconds. Learn how parts, merges, and sparse indexes work, and how to choose the ORDER BY key, secondary indexes, and MergeTree variants.
MySQL Query Cache Removal: Why It Was Removed and Modern Alternatives
Understand why MySQL removed the query cache in 8.0 and what to use instead: application-level Redis caching, ProxySQL query cache, and pre-computed summary tables.
PostgreSQL 17 Vacuum Improvements: Preventing Bloat and Wraparound
PostgreSQL 17 ships eager freezing and improved autovacuum prioritization, the most significant vacuum improvements in a decade. Learn how to tune autovacuum for high-write tables and prevent transaction ID wraparound.
PostgreSQL Query Planner Hints: pg_hint_plan and Statistics Tuning
Guide the PostgreSQL query planner with enable_xxx settings, pg_hint_plan extension, and extended statistics for correlated columns. Fix bad plans without rewriting queries.
sysbench MySQL Benchmarking: OLTP Workloads and Performance Baselines
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.
FoundationDB Architecture: ACID Transactions at Distributed Scale
FoundationDB powers Apple iCloud and Snowflake's metadata layer with ACID transactions across distributed nodes. Learn how its ordered key-value core, layer architecture, and simulation testing deliver unmatched reliability.
pgbench: PostgreSQL Benchmarking for Configuration Validation
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.
pg_repack: Online Table and Index Compaction Without Exclusive Locks
Use pg_repack to reclaim PostgreSQL table bloat without the exclusive lock of VACUUM FULL. Covers installation, table vs index repack, disk space requirements, and throttling.
Redis Streams vs Kafka: Choosing the Right Event Streaming Architecture
Redis Streams and Kafka both handle millions of events per second, but they solve different problems. Compare latency, retention, delivery guarantees, and operational overhead to choose the right architecture.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed