The JusDB Database Engineering Blog

Comprehensive PostgreSQL guide covering MVCC, extensions, partitioning, logical replication, and performance tuning. Learn why PostgreSQL powers modern applications.

Leverage MySQL 8.4 InnoDB parallel DDL for faster schema changes. Learn parallel index creation, online DDL improvements, and reduced maintenance windows.

Use TimescaleDB for time-series data in PostgreSQL. Covers hypertable creation, continuous aggregates with refresh policies, retention policies, and 10-20x compression.

Navigate the open source database landscape. Compare MySQL, PostgreSQL, MongoDB, Redis, and Cassandra with detailed feature analysis and selection criteria.

Everything you need to know about MySQL: storage engines, replication topologies, performance tuning, and cloud deployment. From basics to advanced optimization.

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.

Choose the optimal EC2 instance for your database workload. Compare R, X, I, and Graviton families with real-world benchmarks and cost-performance analysis.

Complete MongoDB guide covering document modeling, aggregation pipelines, sharding, replication, and Atlas deployment. Learn when MongoDB is the right choice for your application.

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.

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.

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.

MySQL architecture from query parser to disk: optimizer pipeline, InnoDB buffer pool, redo log, and storage internals every production DBA needs in 2026.