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 326 articles
ClickHouse Explained (2026): MergeTree, Distributed Engine & Real-Time OLAP
Build blazing-fast analytics with ClickHouse columnar database. Learn MergeTree engine, data modeling, query optimization, and cluster deployment strategies.
EC2 for Databases (2026): Graviton4, M7i, X2gd & Instance Selection Cheat Sheet
Choose the optimal EC2 instance for your database workload. Compare R, X, I, and Graviton families with real-world benchmarks and cost-performance analysis.
PostgreSQL Explained (2026): Architecture, MVCC, JSONB & Production Patterns
Comprehensive PostgreSQL guide covering MVCC, extensions, partitioning, logical replication, and performance tuning. Learn why PostgreSQL powers modern applications.
MongoDB Explained (2026): Replica Sets, Sharding, Atlas & Production Patterns
Complete MongoDB guide covering document modeling, aggregation pipelines, sharding, replication, and Atlas deployment. Learn when MongoDB is the right choice for your application.
Open Source Databases (2026): PostgreSQL, MySQL, ClickHouse, Cassandra & Beyond
Navigate the open source database landscape. Compare MySQL, PostgreSQL, MongoDB, Redis, and Cassandra with detailed feature analysis and selection criteria.
TimescaleDB Hypertables, Continuous Aggregates & Compression (2026 Production Guide)
Use TimescaleDB for time-series data in PostgreSQL. Covers hypertable creation, continuous aggregates with refresh policies, retention policies, and 10-20x compression.
PostgreSQL 13 EOL Survival Guide (2026): Upgrading to 16 or 17 Safely
PostgreSQL 13 will officially reach end of life on November 13, 2025. After this date, the PostgreSQL Global Development Group will stop releasing security patc
MySQL 8.4 Parallel DDL: innodb_parallel_read_threads & innodb_ddl_threads Tuning
Leverage MySQL 8.4 InnoDB parallel DDL for faster schema changes. Learn parallel index creation, online DDL improvements, and reduced maintenance windows.
Normalization vs Denormalization (2026): When Each Wins for Database Performance
Explore the trade-offs between database normalization and denormalization for optimal performance. Learn when to normalize for data integrity and when to denormalize for query speed.
StarRocks vs ClickHouse: Architecture, Table Models & When to Choose Each (2026)
StarRocks is an open-source MPP analytics database. This 2026 guide covers FE/BE/CN architecture, the four table models, vectorized execution, and when to choose StarRocks over ClickHouse.
MySQL "Communications Link Failure": Fix wait_timeout, HikariCP & All 8 Timeout Variables
MySQL wait_timeout, net_read_timeout, innodb_lock_wait_timeout and max_execution_time — production tuning rules and the HikariCP alignment trick that prevents 'communications link failure' errors.
MySQL binlog Retention, Rotation & Purge: Production Guide (2026)
Configure MySQL binlog retention safely: binlog_expire_logs_seconds, manual purging rules, AWS RDS retention, and the disk-exhaustion failure mode you should monitor for.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed